Tip #1378: Update Common Data Service user photo from Office 365 profile

Female avatar

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