Need to put Jotform data into a CSV, but no array to choose from

[trobbani]

I am trying to make a CSV out of jotform data in order to transfer it to an excel file. However, Jotform only supplies me with "body" which seems to be a JSON object but I need an array to make a CSV table. Here are the screenshots:

Any suggestions?

Thanks in advance.

[DeepakS · Accepted solution]

Hi @trobbani , As the response you are getting a JSON response you should create an Array based on the information in JSON.

1. Initialize an Array variable
2. Loop through each item in JSON and append the data to Array variable 
3. use the array variable to create table

Regards,

DS

[trobbani]

Thank you @DeepakS , this fixed it. However, I have another problem with the CSV table that is explained here:

https://powerusers.microsoft.com/t5/General-Power-Automate/Want-CSV-table-to-have-output-vertically-...

If you have any input let me know! Thank you.