get form response details as json

[narendra]

hi,

Is possible to retrieve Forms "get response details" in Json format?

or an object that can be converted  using json function like json(object)

Best regards,

Narendra

[v-micsh-msft · Accepted solution]

Hi @narendra,

Please take a try with the following expression:

body('Get_response_details')

For example:

Using the Body() would have the response Action Outputs returned in JSON format.

Results as below:

Things to note is:

Using hte Whole body instead of each seperated dynamic content would have the Question shown in GUID (not the corresponding question name).

To workaround this, you could add a Select Action, with the from input, enter the following expression:

createArray(body('Get_response_details'))

Then, map the value from the dynamic content:

See the results:

And if you would like to take use of the Select outputs, try the following expression:

first(body('Select'))

See reference:

Regards,

Michael

[rmath]

Im trying to use this same exact flow without the date requirement but keep getting errors. Any suggestions? Here are the settings that i use and the error i get.