Category Archives: Power Automate

How to: not to get stuck on the required fields when creating a Power Automate Flow

Microsoft Dataverse has a somewhat unique interpretation of what a “required” field is. It’s a bit of “do as I say not as I do”. For example, I can’t create an account in the user interface not having “account name” populated (since it’s a required field): But, of course, behind the scene… whether through Excel… Read More »

Incremental refresh for the Dataflows which are loading data from SQL to Dataverse

In one of the earlier posts this month I was seemingly unhappy about the missing “incremental refresh” option: But, having thought about it a bit more, I don’t think it’s such a big issue. Not when working with the SQL data sources, at least. All we really need is a view that will pre-filter… Read More »

Canvas App on the Dashboard – how do we handle application url?

Environment variables can be very helpful in a lot of situations. Here is yet another scenario where I found them very useful the other day. Imagine you have a Canvas Application you wanted to display in a web resource. Maybe even on the dashboard… something like this: The app there is very simple, but it’s… Read More »

Power platform Dataflows – have I missed “Incremental refresh” option somehow?

This month seems to be all about data integration/data migration for me, so, even though I’m still using good old SSIS in many cases, I wanted to look at the Dataflows a little closer. After all, they don’t require any additional deployment/licensing – we just need to go to the maker portal and start building… Read More »

Power Platform Elephants

A few things happened recently which got me thinking about things we usually don’t talk about in the Power Platform world: Steve Mordue mentioned Dunning-Kruger Effect in his recent podcast/blog post: Another fellow MVP, Olena Grischenko,  posted this interesting comment on Linkedin: “Doing lots of error handing in Power Automate recently Feels more and… Read More »

Power Automate word templates in Model-Driven apps – forms integration

Now that we went through the process of creating a Power Automate flow that’s using Word Template action, why don’t we get this integrated into a model-driven application?   Let’s first create a very simple invoice form. You should be able to do it easily (or you could use any other entity – I’m just… Read More »