cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SLO1995
New Member

Adjust String Formatting when Parse JSON - create CSV

Hello Team,

 

I have a flow set up with a https get call. I then parse the JSON, create a CSV and save it do my desktop.

 

My Column headers however are all formatted as the JSON String and I haven't figure out a way to format the dates to MM/dd/yyyy or be able to add spaces to the column headers. See below for my flow as well as the csv output:

SLO1995_0-1638470421681.png

here are the column headers I am trying to format to make them more readable:

SLO1995_1-1638470539642.png

 

Any help on how to output the dates in MM/dd/yyyy format as well as formatting the other header's would be greatly appreciated.

 

Thanks!

 

Sean

 

1 REPLY 1
ekarim2020
Super User
Super User

You can use a Select action to select the "columns" from the HTTP action, name the columns, and format the data  using expressions. For example:

2021-12-02_23-43-55.png2021-12-02_23-46-19.png2021-12-02_23-45-40.png

 

The output of the select action should be used for the Create CSV Table action:

2021-12-02_23-51-09.png

 


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,997)