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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Adjust String Formatti...
Power Automate
Unanswered

Adjust String Formatting when Parse JSON - create CSV

(0) ShareShare
ReportReport
Posted on by

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

 

Categories:
I have the same question (0)
  • Ellis Karim Profile Picture
    11,691 Super User 2025 Season 2 on at

    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.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard