Power Automate - Get Microsoft Forms Data including Attachments 10-20-2020 08:43 AM

[RezaDorrani]

Hello everyone,

In this video, you will learn about how to build a flow to connect to Microsoft Forms.

We will use flow to get forms data for all column types - choice, multiple choice, numbers, multiple attachments etc. and move them to a SharePoint list.

Expressions Used in Video:

To get JSON value for string data types -

json(Dynamic content column)

To set multiple choice column value (Select action) -

{ "Value": "@{item()}" }

To convert string to number -

float(Dynamic content column)

To get id of file uploaded -

item()?['id']

To get name of file uploaded -

item()?['name']

To learn more about expressions-

https://aka.ms/learnexpressions

#PowerAutomate #MicrosoftForms #FormsAttachments #SharePoint

watch?v=kbqXsKPTmZk

[elliegeraets]

Also having this issue.

[cds63]

This is great, however my Apply to Each statement fails, if there's no attachments.  I get the following error details:

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('Compose_Files')' is of type 'Null'. The result must be a valid array.

Everything still populates properly on the MS List when there's no files and the Flow runs successfully when there's attachments. Is the Flow statement designed to always have attachments or have I done something wrong?  Thanks for your time.