Getting responses from Microsoft Form to "Create CSV table"

Question

Getting responses from Microsoft Form to "Create CSV table"

Justin Doh 860

I am trying to complete 3rd part "Create CSV table", and I am stuck because I do not see any content available.

BTW, I tried to mimic this Logic App based on this post.

https://learn.microsoft.com/en-us/answers/questions/1341692/logicapps-saving-all-microsoft-form-responses-to-a

Bottom is screenshot of my current Logic App:

User's image

When I ran the Logic App, I got results from first two parts as shown below:

User's image

What should I do or what am I missing?

BTW, my Microsoft Form looks like this (just one question for now).

User's image

VenkateshDodda-MSFT 25,241 Reputation points Microsoft Employee Moderator

2024-12-30T03:57:23.2966667+00:00

@King Java Following up to see whether the answer provided by @Silvia Wibowo is helpful or not, do let me know if you have any further questions on this.
Justin Doh 860 Reputation points

2024-12-30T18:53:13.5+00:00

@VenkateshDodda-MSFT

Thank you for following up on this post.

Yes, I was able to add two more steps between, and I am getting this error:
Justin Doh 860 Reputation points

2024-12-30T21:46:55.47+00:00

@VenkateshDodda-MSFT

So, I tried to break down the array into each parts like example below:

Do I have to modify from "Append to array variable" or modify only on the "Create CSV table"?

I was trying to modify from "Append to array variable", but I am not able to express with icons shown on the example on the top:
Silvia Wibowo 6,066 Reputation points Microsoft Employee Volunteer Moderator

2024-12-31T00:17:45.8033333+00:00

Hi @King Java , please provide screenshot of your configuration for the steps "Initialize variable" and "Append to array variable".
Justin Doh 860 Reputation points

2025-01-01T03:29:03.5066667+00:00

@Silvia Wibowo

Thank you for helping me:

Here are screenshots:

Answer accepted by question author

0 additional answers

Your answer

VenkateshDodda-MSFT 25,241 Reputation points Microsoft Employee Moderator

2024-12-30T03:57:23.2966667+00:00

@King Java Following up to see whether the answer provided by @Silvia Wibowo is helpful or not, do let me know if you have any further questions on this.
Justin Doh 860 Reputation points

2024-12-30T18:53:13.5+00:00

@VenkateshDodda-MSFT

Thank you for following up on this post.

Yes, I was able to add two more steps between, and I am getting this error:
Justin Doh 860 Reputation points

2024-12-30T21:46:55.47+00:00

@VenkateshDodda-MSFT

So, I tried to break down the array into each parts like example below:

Do I have to modify from "Append to array variable" or modify only on the "Create CSV table"?

I was trying to modify from "Append to array variable", but I am not able to express with icons shown on the example on the top:
Silvia Wibowo 6,066 Reputation points Microsoft Employee Volunteer Moderator

2024-12-31T00:17:45.8033333+00:00

Hi @King Java , please provide screenshot of your configuration for the steps "Initialize variable" and "Append to array variable".
Justin Doh 860 Reputation points

2025-01-01T03:29:03.5066667+00:00

@Silvia Wibowo

Thank you for helping me:

Here are screenshots:

Answer 1

Silvia Wibowo 6,066 Microsoft Employee Volunteer Moderator

Hi @Justin Doh , you can follow the answer from original poster, which describes 2 additional steps required between "Get response details" and "Create CSV table":

Initialize variable
Append to array variable

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Silvia Wibowo 6,066 Reputation points Microsoft Employee Volunteer Moderator

2025-01-02T21:02:51.09+00:00
Hi @King Java , the step "Append to array variable" must be a valid JSON array, with curly brackets and commas. This example uses the column name so the CSV file knows which column to put the values into:

So, in your case, you would use this value:

{ "FavDish": variable-of-select-your-favorite-dish, "Email": variable-of-Responders-Email, "Time": variable-of-Submission-Time }

If you don't want to insert column name in the array variable, you'd need to configure column name in the "Create CSV Table" settings. In this case, your value of array variable (add curly bracket and commas to your existing value):

{ variable-of-select-your-favorite-dish,variable-of-Responders-Email,variable-of-Submission-Time }
Justin Doh 860 Reputation points

2025-01-02T23:43:25.08+00:00

@Silvia Wibowo Thank you for helping.

I did this way, and it worked.
Justin Doh 860 Reputation points

2025-01-07T00:20:25.2833333+00:00

@Silvia Wibowo I have posted another new question here:

If you can help me again, that would be great.

https://learn.microsoft.com/en-us/answers/questions/2141038/how-to-retrieve-the-output-from-microsoft-form-in

Share via

Getting responses from Microsoft Form to "Create CSV table"

0 additional answers

Your answer