Unanswered

Need help Parsing JSON to CSV

(0) Share

Report

Posted on by pwruser123

I'm using power automate to retrieve survey data from Customer Voice, my issue is the response is all coming in one column. I used Parse JSON to get the data, here's what the data look like (body from Parse JSON function):

[

{

"questionId": "r3333444",

"response": "5"

{

"questionId": "r3333444555",

"response": "5"

{

"questionId": "r33334442233",

"response": "Yourself"

{

"questionId": "r33334442222",

"response": "John Doe"

{

"questionId": "r3333444998888",

"response": "email@yahoo.com"

{

"questionId": "r3333444334455",

"response": "111-222-3333"

{

"questionId": "r333344422344",

"response": "need help"

{

"questionId": "r33334442211111",

"response": "Opt-in"

}

]

-------

I would like to get this to a CSV, the questionID supposed to be the question names, but it's only coming out as QuestionID.

Categories:

General topics

I have the same question (0)

All responses (18)

Answers (0)

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

Hi @pwruser123

Can you paste the survey data you are getting before you run it through a Parse JSON action?
Remove any sensitive data

Was this reply helpful? Yes No
pwruser123 16 on at

Like (0)

Report

@DJ_Jamba Here's what the data looks like before Parse JSON action:

[{"questionId":"r3333444","response":"5"},
{"questionId":"r3333444555","response":"5"},
{"questionId":"r33334442233","response":"Yourself"},
{"questionId":"r33334442222","response":"John Doe"},{"questionId":"r3333444998888","response":"email@yahoo.com"},
{"questionId":"r3333444334455","response":"111-222-3333"},
{"questionId":"r333344422344","response":"Need help"},{"questionId":"r0a19a484ddba431fae09671970a0b36b","response":"Opt-in"}]

This is coming from a table in the Customer Voice Survey Response table, then I use List Row action. Here's the screenshot:

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

@pwruser123

I need whatever is inside this:

not the schema

Was this reply helpful? Yes No
pwruser123 16 on at

Like (0)

Report

@DJ_Jamba
This is what I sent, it's the responses in JSON format

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @pwruser123

so you want to retrive questions names from dataverse instead of question id > am i correct ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
pwruser123 16 on at

Like (0)

Report

@Nived_Nambiar Yes, I want to retrieve all the questions and their responses, right now it's coming has question IDs, which is fine, but need to get the JSON to a CSV so I can export it in a table format

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

So how should expected format something like this

Question ID1, Question ID2, .....

Response1, response 2.......

where question ID should be headers and responses should be values, am i correct?

Or in below format ?

This flow would help

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
pwruser123 16 on at

Like (0)

Report

@Nived_Nambiar yes, but right now, it's all showing up as just QuestionID for all questions
here's an example:
[{"questionId":"r3333444","response":"5"},
{"questionId":"r3333444555","response":"5"},
{"questionId":"r33334442233","response":"Yourself"},
{"questionId":"r33334442222","response":"John Doe"},{"questionId":"r3333444998888","response":"email@yahoo.com"},
{"questionId":"r3333444334455","response":"111-222-3333"},
{"questionId":"r333344422344","response":"Need help"},{"questionId":"r0a19a484ddba431fae09671970a0b36b","response":"Opt-in"}]

so the questionids need to be headers, and the response should be rows, for each responses

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @pwruser123

see this flow (you have to make modifications to your existing flow)

1. Initialize two variables after list rows action (one for array type, other for object type)

2. After parse json action, use apply to each loop again to loop through results of parse json

2.1 - inside that use compose action to add properties to tempObject variable

2.3 then set the value from that compose action to tempObject

addProperty(variables('tempObject'),items('Apply_to_each_2)?['questionId'],items('Apply_to_each_2)?['response'])

3. After the loop , use append to array to append tempObject to FinalArr variable

4. set the tempObject as {}

Now outside of Apply to each loop, use create csv table action (I think you need to create csv table after looping through all).

Hope it helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

@pwruser123
Could you post a screenshot of your whole flow including the trigger?

Was this reply helpful? Yes No