Adjust String Formatting when Parse JSON - create CSV

[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

[ekarim2020]

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.