Skip to main content

Notifications

Power Automate - Get Microsoft Forms Data including Attachments

RezaDorrani Profile Picture Posted 20 Oct 2020 by RezaDorrani 12,141

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

Categories:

Comments

  • elliegeraets Profile Picture elliegeraets
    Posted 08 Mar 2022 at 21:02:29
    Power Automate - Get Microsoft Forms Data including Attachments

    Also having this issue.

  • cds63 Profile Picture cds63 28
    Posted 26 Jan 2022 at 01:57:23
    Power Automate - Get Microsoft Forms Data including Attachments

    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.