web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : q/PvzqYBjty1qKAYQxyVoY
Power Automate - Building Flows
Unanswered

Formatting date fields of CSV export from Power BI

Like (0) ShareShare
ReportReport
Posted on 15 Nov 2022 08:00:06 by 2

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:

Nightingale131_0-1668499048756.png

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

  • Iamsatisacro Profile Picture
    2 on 26 Jul 2023 at 13:34:31
    Re: Formatting date fields of CSV export from Power BI

    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?
    Iamsatisacro_0-1690378362415.png

     

  • grantjenkins Profile Picture
    11,059 Moderator on 18 Nov 2022 at 12:34:07
    Re: Formatting date fields of CSV export from Power BI

    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')

    grantjenkins_0-1668774813919.png

     

  • Nightingale131 Profile Picture
    2 on 15 Nov 2022 at 08:29:21
    Re: Formatting date fields of CSV export from Power BI

    Hi, thanks for the reply.

     

    Do you mean like this?

     

    Nightingale131_0-1668500949640.png

     

  • grantjenkins Profile Picture
    11,059 Moderator on 15 Nov 2022 at 08:25:19
    Re: Formatting date fields of CSV export from Power BI

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2