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 […]
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 #1358: Are you fit?
Nope, it’s not about weight loss programs. Nor, strictly speaking, it’s about Power Platform. I can’t believe I’m even writing this tip but, after discovering that some of my very technically proficient friends asked me to rotate my phone during the meeting because they could only see my nose (it’s big but not THAT big, […]
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 #1355: Sales order – why you no recalculate?
For one of our customers we only use write-in products for the sales orders. (Some of you may wonder why do we use built-in sales orders in the first place but it eeez what it eeez). What I did notice is that the sales order entity will not recalculate manual items until the price list […]
Tip #1353: Rename entity form
Remember our entity creation guide? Surprisingly it did withstand the test of time. But I’d like to make a small addition. When you done creating the fields, do yourself a favor and rename the main and quick create forms. Don’t care what the new name is as long as it’s NOT Information. Why? Because when […]