Tag Archives: PowerAutomate

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: https://www.itaintboring.com/dynamics-crm/power-platform-dataflows-have-i-missed-incremental-refresh-option-somehow/ 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 »

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:  https://stevemordue.com/microsoft-marching-masses-to-peak-of-mt-stupid/ 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 »

Excel Online connector vs Google Sheets connector

Recently, I happened to look into how google sheets connector works, and, to be honest, I was a little bit disappointed. First, I wanted to blame google. But, it turned out,  there is no hiding the fact that’s it’s been provided by Microsoft itself: https://docs.microsoft.com/en-us/connectors/googlesheet/ In general, this connector works. But there is one notable… Read More »