cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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

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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (3,735)