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.
After upgrading our Dynamics environment to the new Unified Interface, the Advanced Find button/icon in the top navigation was missing:
When using the “Create CSV table” action of Power Automate, I found out some useful tips and suggestions:
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.
How to define the filter on CDS records? With the FetchXML builder from the XRMtoolbox! There is a dropdown “View” available containing a “Flow list parameters” option. Selecting this option shows the Flow list parameters that suit the query that you have build.