Power Platform Community Forum Thread Details

Hi,

I'm trying to take data from Jotform that typically comes through like the below (Excuse the key naming, my boss set this form up) and:

initialise an array variable ✔
Parse the data into a JavaScript Object ✔
Loop through the the JavaScript Object and populate the array variable with values ❌
Create a CSV table from the array variables ❌

I can't find a way to loop through the JavaScript object and extract the values into an array.

Can someone please help with this, it would really help me to take a lot of mundane but necessary work out of our staff's workload.

Thanks

{
 "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"
}

Categories:

General topics