Hi,
this is basically a double from https://powerusers.microsoft.com/t5/Building-Flows/How-to-use-a-Date-Time-Operation-with-Power-BI-Data/m-p/1374262#M155051 but the solution given there doesn't work for me.
I have a Power Automate Flow designed as this:
the export works ok, but the dates in there are in ISO 8601 format which doesn't suit the users. Is there a way to convert it to short format?
I tried solution from the link above, but the "select" action doesn't work. I have no idea how to put it to use.
Thank you
Hi GrantJenkins, how did you add the Value Name? Is it expression as well, but based on the icon of "Name" is for the icon of compose?
Correct - so you can add your Headers manually and add the corresponding fields. And with your Date fields you can use formatDateTime to get the format you want. The expression I've used below for my date field called Date is:
formatDateTime(item()?['Date'], 'yyyy-MM-dd')
Hi, thanks for the reply.
Do you mean like this?
Do you know what fields will make up the CSV table? If so, you can click on Show advanced options and set each field separately. You can then use formatDateTime for your date fields and set whatever date format you want to output.
Also, you should be able to use Power BI data directly in your Create CSV table without adding it to the Compose first.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2