News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Adjust String Formatti...

Power Automate - Building Flows

Unanswered

Adjust String Formatting when Parse JSON - create CSV

(0) Share

Report

Report

Posted on by SLO1995

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:

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

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

All responses Img

All responses (1)

Answers Img

Answers (0)

Ellis Karim 11,113 Super User 2025 Season 1 on at

Like (0)

Report

Re: Adjust String Formatting when Parse JSON - create CSV

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:

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

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans