Tip #1402: Why you should not use Microsoft Lists/SharePoint Lists for business-critical Power Apps

Long list of things to do before I die written by chalk on blackboard

SharePoint lists (and now Microsoft Lists) are an easy way to quickly create lists of data for use in a Power App. Makers can quickly create lists, add fields, and populate data for canvas apps. However, not all apps are equal from a complexity perspective. If the app is simple and contains data that is […]

Tip #1397: Reduce extra Power Automate runs and overcome trigger limitations

You know I’m a sucker for some open source goodness. This time the goodness is from Aiden “President” Kaskela. (Got something to share? Send your wares to jar@crmtipoftheday.com). The Common Data Service (Current Environment) trigger in Power Apps allows you to run your cloud flow when certain fields are updated, but there are two shortcomings: […]

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 #1378: Update Common Data Service user photo from Office 365 profile

Female avatar

I had things stolen from me, I gave things away on many occasions. But I never ever lost anything. What’s the secret? Time perception. I do not lose things, I only temporarily misplace them The Enabler Consider this. Last year I created a folder for all the good tips coming in from the fellow tipsters, […]

Tip #1367: Tell apart create, update, and delete events

It’s not every day one gets to chime in on a post from Jerry, the lifetime tipster and Power Automate connoisseur. In this post Jerry talks about When a record is created, updated, or deleted trigger in CDS (current environment) connector and how to tell the event that triggered the flow using a clever combination […]

Tip #1362: Trigger Power Automate on Associate / Disassociate

Many to many relationship is everywhere, from good old marketing lists to web roles in Power Apps portals. The secret sauce is in the little hidden intersect entity holding the relationship together, those of you who used FetchXml Builder from XrmToolBox to craft a query, are very familiar with. The messages to control the relationship […]

Tip #1360: Customizing the activity timeline

Timeline of the universe. A representation of the evolution of the universe over 13.77 billion years.

You migrate data to Dynamics 365/Common Data Service and in the migration, you close activities. After the migration, the activity timeline shows the migration account in the top line of every activity. Say you want to have the timeline display something other than the account who closed the task. How do you customize this layout? […]