Sometimes, good news sneaks into our world undetected. Big int as a separate data type has been available in Dataverse for about two years now.
Tip #1460: Loops and ThisRecord in low-code plug-ins
When you use loops like ForAll function in a low-code plug-in, ThisRecord will change its meaning from the table row associated with the plug-in run, to the row inside the loop. Disambiguating is fairly straightforward… once you know how.
Tip #1449: Formula columns love calculated columns
Can’t return the data type you need from a formula column? Do your homework then create a calculated column that simply casts to the correct type.
Tip #1448: Never delete columns in translation
Dealing with Dataverse translation file? Never delete columns. But you are free to delete rows and tabs.
Tip #1441: Owner is a user is a team
WARNING: Niche L400 tip ahead. tl;dr If you’re expect primary column name to be tablename + “id“, add an exception for systemuser and team tables – both will come back as ownerid in custom API. L400 If custom API has an output property of type EntityReference then, for example, for account (or any other “normal”) table, the […]
Tip #1440: Relative dates in sample data
We all enjoy flexing our Dataverse or Dynamics 365 skills from time to time. Many of us have meticulously crafted a demo instance from proverbial stone and blood. However, one of the challenges is keeping the data up-to-date. There’s nothing worse than displaying 20 tasks that are all overdue by four months. Fortunately, Dataverse offers […]
Tip #1438: Turn on auto search for lookups
Today’s tip is from Amey “Anything But Code” Holden. You can drop your priceless tip into our tipping jar too, thank you very much! I (Amey, not me – t.j.) often see users struggle with the confusing behaviour of lookups in model-driven apps. Typical sketch from an average week of consulting with model-driven apps looks […]
Tip #1433: How to list all Dataverse tables in style
Is there any way to export automatically or with a script a list of all the Dataverse tables in an organisation? From our good friend Shan McArthur came a multilayer answer (narrated and illustrated by The Enabler): One: We have a virtual entity called entities that will give you a list of all entities in […]
Tip #1432: Create records in Power Automate without mandatory fields
I really like mini truck stops when two or more MVPs brainstorm a random problem, usually because they are bored 😈. Help me understand scenarios where one would use a guid() expression in flow when creating new rows. Antti Pajunen What Antti left out was (reasonably) common wisdom that explicitly setting identifiers for new records […]
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 […]