From time to time you may be forced to deal with JSON objects in Power Automate that contain duplicate property names. Consider this object, for example: To make this object maker-friendly, the common approach is to use Parse JSON action and derive schema from the data itself. When done, maker can use properties as dynamic […]
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 #1345: When Power Automate picks the wrong type
When using the Parse JSON action in Power Automate, flow will guess what type of data your fields are. Sometimes it guesses incorrectly, such as thinking a number field should be a text string. When this happens, you will only be able to select the field for test fields, not number fields in update record […]