When using the “Create CSV table” action of Power Automate, I found out some useful tips and suggestions:

1 – Using “Automatic”, all fields in the JSON input string are converted to a column in the CSV table output. For CDS purposes, that can be a lot of fields!

2 – Using “Custom”, you may select the necessary output fields from the Dynamic Content list.

3 – When using FetchXML with a linked entity, the linked entity fields are not found in the Content list. You may enter them by hand using the syntax: “item()?[‘EntityAlias.FieldName’]”. Or, even better, check the JSON input of the action to find out the correct fieldnames


4 – CSV output is only American style; dots before digits and comma’s as delimiters. I didn’t find a way to make this European unfortunately…

5 – Specific fields with special characters, like a comma or semicolon, are places within brackets. I didn’t find a way to alter this behavior where necessary.

0 antwoorden

Plaats een Reactie

Meepraten?
Draag gerust bij!

Geef een reactie

Het e-mailadres wordt niet gepubliceerd. Vereiste velden zijn gemarkeerd met *