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. 

[msnc_leet]

Hi! @narendra and @v-micsh-msft 

Thanks for this but I had a doubt.

How do we get only the form responses which were submitted today ?

I am trying to create a string variable which holds date in the format '7/28/21'.

My form has a column 'Completion time'.

So, I tried using filter array data operation to choose Column of excel sheet with 'Starts with' my date variable but there has been zero elements in the output body of Filter Array.

Thank you.