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 Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,530)