web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Need to put Jotform da...
Power Automate
Answered

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

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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.

Categories:
  • Verified answer
    DeepakS Profile Picture
    2,301 Most Valuable Professional on at

    Hi @Anonymous , 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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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-in-Excel-not/m-p/753559

     

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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

     

    Hi @DeepakS,

     

    I have searched for a while now and I can't find a way to loop through a JSON object that isn't an array so that I can convert the values into an array, can you please help?

    This is what I'm presented with from Jotform (Excuse the key naming, my boss set this form up): 

     

    {
     "16 - Select your vehicle from the list of below stocked vehicles": "<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"left\"><tbody><tr><td><ul style=\"padding-left:10px\"><li>Hyundai Ioniq (Amount: 0 GBP, Quantity: 1)</li></ul>Total: 0 GBP</td></tr></tbody></table>",
     "04 - Name": "TEST TEST",
     "08 - Email": "test@test.co.uk",
     "10 - Age?": "25 or Over",
     "06 - Phone Number": "0987654567890",
     "17 - PCO Uber Hub Enquiry": "",
     "15 - Page Break": "",
     "12 - When Do You Want To Rent From?": "2022-02-25T00:00:00+00:00",
     "14 - How Long Do You Want To Rent For?": "6+ Months +",
     "05 - divider": "",
     "07 - divider72": "",
     "09 - divider73": "",
     "11 - divider74": "",
     "13 - divider75": "",
     "01 - Submission ID": "00000000000000",
     "02 - Form ID": "000000000000",
     "03 - Form Title": "Web Enquiry Form"
    }

     

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 330

#2
11manish Profile Picture

11manish 282 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 123

Last 30 days Overall leaderboard