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.

Lees meer

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.

Lees meer

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:

Lees meer

When using prices, for example when calculating invoice lines, it is important to round the numbers before you make a total calculation. To prevent a difference in the calculated total (if this is a float) and the actual sum of all lines.

Lees meer

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. Downsite of this is that CDS returns a list of records (wit just one record) and when you want to use the contents of a field in the record, Flow creates a loop automatically.

Lees meer