Get values only from array into csv file

Like (0) Share

Report

Posted on 16 May 2024 14:53:26 by Oscart

I'm sending in a collection from my app by using flowName.Run(JSON(myCollection)). After initializing the variable and using parse JSON, the output looks something like: [{"AMDTime":"6-12", "MiddayTime":"12-3", "EveningTime":"6-12"}]. I then add this Parse JSON Body value into Create CSV Table and use Sharepoint Create File after to create a csv file. Everything in the flow works so far, but the key and values show up in the csv file. So instead of having one row with the keys and a row beneath with the values, how can I just put the values into the csv file?

All responses (1)

Answers (1)

Verified answer

v-yetonggu-msft on 17 May 2024 at 01:42:36

Like (0)

Report
Re: Get values only from array into csv file

Hi @Oscart ,

Please check this test:

The Result:

My Flow Parameters:

trim(replace(body('Create_CSV_table'),split(body('Create_CSV_table'),decodeUriComponent('%0A'))[0],''))

The CSV File Content:

Best Regards,

Sunshine Gu