Alternate keys are great way to enforce uniqueness of the column values. For example, if you want lead emails to be truly unique, just add an alternate key and no user will be able to bypass that (unlike the duplicate detection which is a fairly timid mechanism). The challenge is when you want that uniqueness […]
Tip #1409: Count records for all tables in Dataverse
Want to count all records in all Dataverse tables like a boss? Say no mo. Make sure TDS endpoint is enabled using Manage feature settings. Connect to your Dataverse as described in Use SQL to query data (Microsoft Dataverse) We cannot use some of the features including loops (see How Dataverse SQL Differs from Transact-SQL) […]
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 #1402: Why you should not use Microsoft Lists/SharePoint Lists for business-critical Power Apps
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 #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 #1378: Update Common Data Service user photo from Office 365 profile
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 #1375: Get record count for entities
I need to perform some data… uhm… “augmentation”. Easy as using Power Automate – get all the records, loop through, fudge I mean augment the data. Right? Except there could be more than 100,000 records. Why 100K? That’s the maximum you can get with the List Records action. (Wanted to insert a reference here but […]
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 […]