How to get 'value' for Data Operation field From

(0) Share

Report

Posted on by mhorn30

I'm capturing a Form response that I want to turn into an HTML table.

Question: How do I get 'value' for the From field?

I assume that I need to set / create it somehow, but I have not been able to find a forum or blog post that explains this step.

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (2)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

@mhorn30

Hi there. You might be able to use an expression like body('Get_response_details') - not sure...but worth a shot.

Keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (1)

Report

Hi @mhorn30 ,

Forms response is an object, but an array is required when creating an HTML table.

You need to initialize an array variable and fill the array with the form response in the following way.

Best Regards,

Was this reply helpful? Yes No
mhorn30 56 on at

Like (0)

Report

Hi @v-bacao-msft

I get this error when I try your method:

Flow:

I initially tried this template flow: https://emea.flow.microsoft.com/en-us/galleries/public/templates/6f59ddf2e91147e892e2ccf4f179fdb7/create-a-file-in-sharepoint-on-microsoft-forms-submission/

which makes use of "value" by default (without adding Initialize variable as a step).
But of course it fails saying: "The 'from' property value in the 'table' action inputs is of type 'Null'. The value must be of type 'Array'."

Was this reply helpful? Yes No
mhorn30 56 on at

Like (0)

Report

@edgonzales

Unfortunately Flow does not like this, it says: "The 'from' property value in the 'table' action inputs is of type 'Object'. The value must be of type 'Array'."

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @mhorn30 ,

The end of Value should be] instead of }.

Best Regards,

Was this reply helpful? Yes No
mhorn30 56 on at

Like (0)

Report

Hi @v-bacao-msft

I corrected the } to ] but experience the same error:

Flow:

Was this reply helpful? Yes No
Verified answer

mhorn30 56 on at

Like (0)

Report

Finally solved it:

Thanks to this forum post: https://powerusers.microsoft.com/t5/Building-Flows/Create-HTML-Table-from-MS-Flow-inputs/m-p/482443/highlight/true#M59094

Was this reply helpful? Yes No
v-bacao-msft on at

Like (1)

Report

Hi @mhorn30 ,

But, you forgot to add a comma after Responders’ email.

Best Regards,

Was this reply helpful? Yes No
mhorn30 56 on at

Like (0)

Report

You're right, thank you, that also works and it's one less step:

Was this reply helpful? Yes No