Today’s winner is Linn Zaw “I always” Win. And you can be one too if you email your tip to jar@crmtipoftheday.com! Have you ever added the 1:N or N:1 relationship into the solution, created new mappings in the solution and deployment the solution to another environment only to find out that the mappings are not […]
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 #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 #1390: Bring back the green bar
In Tip 1386 we bemoaned the death of the green bar indicator of the installation status of solutions in Power Apps and Dynamics 365. Chart Guy to the rescue! Ulrik Carlsson has created a Power BI report leveraging the FetchXML in Tip 1386 to create a report with green bars that you can use to […]
Tip #1386: I miss the green bar
If you use the new solution import process at make.powerapps.com, you might miss the old green bar that told you how far the import had proceeded. The good news is, while the green bar is gone, the underlying data that fed the bar is still there. You can query the importjob entity to see how […]
Tip #1360: Customizing the activity timeline
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? […]
Tip #1353: Rename entity form
Remember our entity creation guide? Surprisingly it did withstand the test of time. But I’d like to make a small addition. When you done creating the fields, do yourself a favor and rename the main and quick create forms. Don’t care what the new name is as long as it’s NOT Information. Why? Because when […]
Tip #1307: PowerApps designer makes your work in progress easier
Today’s tip is from EY Kalman. Got a tip? Send it to jar@crmtipoftheday.com (and include either your Twitter handle or LinkedIn profile link for the eternal appreciation link). Late last night I decided to start playing around with entering the data fields directly into the entity first (the aim is to drive a Model App […]