Need to reference a fixed record, for example, Accounts Payables, or SARS-CoV-2? Challenge with fixed records is that we have no idea what the record identifier is, how to reliably search for the record and how to pass it as a parameter between environments. Why not to use a fixed guid and create that entity […]
Tip #1376: Antivirus for portal attachments
One taketh one giveth (or other way around). Returning a favor to AK who asked: How does the portals handle uploading of virus? (Want your favor returned? Send your awesome tip to jar@crmtipoftheday.com!) There are multiple mechanisms you can put in place to protect your users from the viruses (no, not that virus, unfortunately).
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 #1372: Synchronous Power Automate Flow on create/update of a record
Today’s tip is indirectly from Alex Shlega. Alex is very thorough in his writing so I was a bit surprised that his answer to running a synchronous flow from a webhook was a ‘no’. The reason cited was that CDS “execution pipeline” won’t wait for the Flow completion. Well, it will indeed not, but only […]
Tip #1371: i18n of the links
Today’s tip has nothing to do with Power <insert noun here>. Not because I have nothing to talk about but because I feel strongly about today’s subject. tl;dr When sharing a link, remove en-us from the URL. What are you talking about? We all consume and produce a fair amount of the computer-related material. Being […]
Tip #1370: Handle RemoteExecutionObject in Power Automate
When we talked about triggering Power Automate on Associate/Disassociate, I did set aside the task of “dealing with horrendous serialization”. Short version: it’s a RemoteExecutionObject that is serialized in the message and every DataCollection property is serialized as an array of objects with the key and value properties. Fair enough. But in the jsonified world […]
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 #1363: Get Environment Variables in Power Automate (and Power Apps)
Is there a smart way to get an Environment Variable in a flow? Jonas “Giving XrmToolBox a good” Rapp Say no mo…
Tip #1362: Trigger Power Automate on Associate / Disassociate
Many to many relationships are 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 […]