cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trobbani
Frequent Visitor

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

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:initialerror.pngerrorcsv.png

Any suggestions?

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
DeepakS
Super User
Super User

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

View solution in original post

2 REPLIES 2
DeepakS
Super User
Super User

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

View solution in original post

trobbani
Frequent Visitor

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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,846)