If you ever wanted to use Google sheets in Power Automate, there is a connector for that: However, it turned out to be a little tricky, and this is what this post is about. Imagine there is a very simple spreadsheet: What if I wanted to read a specific row from that spreadsheet in the… Read More »
Earlier this month, I wrote a couple of post about reporting/document generation. While working on it, I also tried one other option which you may find useful, too. One of the biggest problems with Word Templates, be it classic word templates in model-driven apps or new populate word template action in Power Automate is that… Read More »
Connection references have been released (well, not quite, but they are in public preview, which is close enough), and, from the ALM support perspective, it might be one of the most anticipated features for those of us who have been struggling with all those connections in the Flows (chances are, if you are using Flows,… Read More »
How do we add file download button to the model-driven apps? To start with, why would we even want to do it? There can be some interesting scenarios there, one being to allow your users to download PowerAutomate-generated word templates (see my previous post). That, of course, requires some custom development, since you may want… Read More »
Document Templates have been available in model-driven apps for a while now – they are integrated with the model-driven apps, and it’s easy for the users to access them. They do have limitations, though. We cannot filter those documents, we can only use 1 level of relationships, on each relationship we can only load 100… Read More »
There was a quick discussion on linkedin yesterday where the post by Jerry Weinstock stating that change tracking must be enabled for the Flows to work was mentioned: https://www.crminnovation.com/blog/microsoft-flow-crm-change-tracking-option/ Given that I did not do anything with the Flows 3-4 years ago, and I never had to worry about change tracking recently, I was a… Read More »
In a few of my previous posts, I used a custom connector which had a “regex” action implemented in it. In case that’s something you might try using in your flows as well, a non-production version (no up-time guarantee, no guarantee at all whatsoever. Feel free to use it, but you can’t hold me responsible)… Read More »
When thinking about user licensing in D365 instances, you may be thinking of D365 applications. However, from the licensing standpoint D365 instance is nothing but an “advanced” CDS instance with a bunch of first-party apps deployed there, so it is still possible to use Power Apps “per app” and “per user” plans in those instances.… Read More »
Looking at the 2020 Release Wave 1 features, it’s kind of hard to figure out which ones will be more useful. Somehow, all of those I’ve read through so far seem to have the potential to strike a chord with those working with Power Platform / Dynamics 365, so it’s going to be a very… Read More »
For some reason, I got hooked up on the custom connectors for the time being. It’s a bit of a learning curve for somebody who has not been doing a lot of development outside of the plugins/scripts/occasional .NET for a while, so, if nothing else, it’s a good exercise in re-building at least some of… Read More »