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 #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?

The "Glasses Apostle" painting in the altarpiece of the church of Bad Wildungen, Germany. Painted by Conrad von Soest in 1403, "Glasses Apostle" is considered the oldest depiction of eyeglasses north of the Alps.

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. […]

Tip #1354: UI Flow: Setting document typeface properties

I recently was evaluating using UI Flow RPA to automatically print barcode labels. Using Microsoft Word or Wordpad and a freely available barcode TTF, I passed the barcode value to the document and hit the print button. All worked as expected, except I could not get the flow to properly record selecting the correct font. […]

Tip #1351: Flows not triggering after environment copy

Today’s tip from Ankita Chavan – a good reminder to get your housekeeping in order while copying the environments. Got a tip of your own? Send it to jar@crmtipoftheday.com! We were working on the full copy of data from UAT Environment to dev Environment and we were testing existing functionality. We found that flow was […]