Tip #1425: Dataverse CSV import using alternate keys

Today’s tip is from Alex McLachlan (@alex_mcla), saving the day (no kidding – I used it the very next day after receiving the tip). You can be a hero too by emailing your tip to jar@crmtipoftheday.com! With the classic import experience, you couldn’t use a CSV import containing an Alternative Key column to update existing […]

Tip #1424: The user does not have sufficient access right to run flow with custom connector

I’ve tried all the right things: Created, deployed, and configured custom connector into the target environment before importing the solution that uses the connector. All tests pass. Created a manual Power Automate flow as part of the solution. Shared the flow with the user (should not need to for the solution flows but just in […]

Tip #1421: Hide form selector in model-driven apps

Everybody take a seat. Tanguy WiTouzard has the floor. (You can grab everyone’s attention too by sending your useful tip to jar@crmtipoftheday.com) Wizardry starts here I don’t know if it was published before but I just found out that we were able to remove “forms” from “form selector” using Javascript. It’s really useful when you […]

Tip #1404: App secrets that last longer than 2 years

Pyramids Gardens, Al Haram, Egypt

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 #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 … […]