Using service principals is the great way to ensure that Dataverse connections in your Power Automate flows are not user-dependent and nothing is going to break when the original creator’s account gets disabled. These are good step-by-step instructions: How to setup a Common Data Service Application User (and why) (I’ll give Nick Doelman a separate […]
Today’s conversation: – Hey, wanna see cool way to round time in Power Automate?- Sure- *shows the trick*- Why it’s not a tip yet?- Mmmmm, dunno… True story. Sometimes we need to round time in Power Automate. For example, you want to schedule a meeting for tomorrow, at the same time as now. Except “now” […]
We rarely publish tips outside of our cozy Power Platform bubble (more like a Zeppelin these days though!). But this one… THIS ONE… I’ve been dreaming about it since I’ve got my first email eons ago… It’s here now! Support for Dynamic ‘+’ Email Aliases in Office 365 – Customer Feedback for Microsoft Office 365 […]
Calculated fields columns are great for quick simple formulas. They are fast, instant, and always up to date. But what if you need to clear the value of the column as part of the calculation? Customer has sites, sites have assets in various categories (hardware, software, etc). The other day I’ve had a requirement to […]
tl;dr When using aggregates with multiple currencies make sure the business understands how the totals are calculated, how exchange rate is used, and why it’s a good idea to roll out your own calculations. Bring it on Multi-currency support has always been one of the staple features of …. eerrr … Dataverse since version … […]
Have you tried turning it off and on again? IT Support Dataverse connector in Power BI is all the rage: fast, efficient, understands metadata well, supports both Import and DirectQuery, makes sushi upon request, you name it. Except that sometimes it does not work. Try selecting account table, for example: If you try accessing it […]
The classic “give me 5 minutes and I’ll whip a flow for you” did not start well. Users entity table was not there. Options Choices: It’s something trivial and I’m simply no longer worthy. ‘u’ is not an actual ‘u’ but Russian ‘и’ typed accidentally but in a weird font. It’s a UI bug It’s […]
They said Power Apps portals are only good for building functionality. They said Power Apps portals can’t do content management. They said Power Apps portals do not support publishing cycle without taking pages offline. They. Were. Wrong. The Enabler Watch this video to learn how to use language feature in Power Apps portals to create […]
I finally found some courage to publish a video tip of my own. Why now? Because the topic is just too good to simply write it down. You have to see it! What is it? It’s JavaScript code inside Power Automate – yes, we can! Watch this video to learn how to build the simplest […]
When you fire up a child workflow in classic workflow, it’s always asynchronous. Fire and forget. Sometimes it’s what you need, sometimes you want to insist on child finishing their greens before the dessert, so to speak. Power Automate, on the other hand, always wants the result when you call a child flow and nags […]
of the