of the
Cover photo by invisiblepower from Pexels
Tip #1406: Flow history takes long time to load
Tip #1405: Unable to assign license to a guest user
B2B collaboration is great. For example, you can share a canvas app with guest users or invite users to use with Azure Active Directory B2B collaboration . One of the steps in the process is adding B2B collaboration users in the Azure portal. But when you try adding a license assignment you maybe faced with […]
Tip #1404: App secrets that last longer than 2 years
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 […]
Tip #1401: Round time in Power Automate
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” […]
Tip #1399: Dynamic ‘+’ email aliases in Office 365
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 […]
Tip #1398: Set calculated field to null
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 […]
Tip #1396: Multi-currency aggregates in Dataverse
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 … […]
Tip #1393: If TDS endpoint does not work
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 […]
Tip #1392: Missing entities in Power Automate
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 […]
Tip #1391: Content management in Power Apps portals
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 […]