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 #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 #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 #1368: Missing a flow?
Today’s tip is from Rilsina Pegado. Got a tip of your own? Send it to jar@crmtipoftheday.com. If you happen to face a situation where your flows are not visible after signing into https://flow.microsoft.com/ > My Flows or by checking default solution with global admin login. Or if you removed flow from the solution and need […]
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 […]
Tip #1359: Whose fault is it in Power Automate?
Smart people are very useful. Sometimes just talking to them helps you understand the technology better. Consider, for example, John Liu educating ignorant yours truly about the intricacies of failing Power Automate flows. tl;dr For a flow run to be a success, all execution paths including those containing skipped actions, must complete.
Tip #1357: Avoid Power Automate emails being marked as spam
Today’s tip is from Tadashi Zialcita and it looks like one the best tips in terms of usefulness / word count ratio. Can you beat that? Send your tip to jar@crmtipoftheday.com. To avoid an email from Power Automate being marked as spam, set it as important. <ENDOFTHETIP> Don’t abuse the newly discovered magic though or […]
Tip #1356: Handle mandatory autonumber fields in automation
The usual workaround for dealing with business required fields when creating records in automation is to make them non-required, deal with the automation and then switch the required option back on. Now, add an autonumber on top of that. That’s right, you want the mandatory field to be blank so that the generator kicks in. […]