Category Archives: Power Automate

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:  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 »

How to: verify principle object access directly from the Flow

If you ever tried using “List Records” action with the POA table (principalobjectaccess), you might have noticed it’s not showing up in the dropdown list: However, it’s easy to solve. You just need to know the “set” name for that table (which is “principalobjectaccessset”), and, then, you can enter that name as a custom value:… Read More »