For several of my customers I need to monitor if flows fail or are being set to the disabled state. For example if a solution import of flows fails. Till now this is not default functionality in Microsoft Automate, so has to be custom developed. I use a flow for this, the periodacaly checks if […]

In all my projects I come to the point where I want the user to wait for a flow to end ór get notified if so. Where is the possibility to start a flow synchronous, like when using workflows? Spoiler alert; I haven’t found a way to start Microsoft Automate flows synchronously from a Model […]

When updating rows using the CDS Current Environment Connection lookup values must be proceeded with the entity name for the reference. For example; But what if the ID is empty? In that case an error wil occur because the reference is null.

Use the Ticks function to compare dates with each other. For example calculating the number of days between two dates, you should convert the dates to Ticks first, subtract these from eachother and convert the result to the number of days back again.

If you want to check whether a field is empty when it comes from CDS, you should use the Empty function. And because empty is a function that refers to a object ,array or string, you need to convert the value to a string first. So for example:

If you want to retreive and use the contents of just one record from CDS, not knowing the GUID. You always have to use the “List records” action in Flow. For example when you want to retreive the account record with accountnumber 123, you will use 123 as the filter in the “List records” action. […]