Save Microsoft Forms Attachments to SharePoint with Power Automate 05-05-2021 07:03 AM

[aprildunnam]

See how to save attachments from Microsoft Forms to SharePoint using Power Automate. I'll walk you through all the steps from creating the form with the attachment to finding where the files are saved and of course creating the flow that will take those attachments and add them to SharePoint either as a list attachment or upload to a document library.

Functions Used:

Get File Name: first(body('Parse_JSON'))?['name']

To learn more about expressions- https://aka.ms/learnexpressions

watch?v=Xb_k8vOERpU

[jconnelly]

PS. they also store in the Document library where the group is, under Apps / Microsoft Forms / [put the name of the form here] / file name uploaded... so they made some improvements!

Thanks again for the video!

[jconnelly]

Thank you for this video April - I love the short snippet of info! A quick note - I found the folder in my OneDrive, but not the doc I uploaded and found that recently (not sure when), MS moved the attachments to the group where the form is created. I was able to find the docs there. Thank you for another wonderful video, this was perfect and just what I needed!

[gullettb]

Great tutorial! Thanks for sharing this info!
I was able to use this successfully yesterday. I ran into an issue with the "Parse JSON" action config. It wasn't creating the schema properly when I was entering sample data. After wrestling with that for a while in both the new Power Automate designer and classic, I used Copilot to help generate the schema. The Copilot schema was mostly correct, but it did require a couple of iterations and adjustments to get it all working correctly. My scenario had a group connected form with multiple attachments, so your additional details in handling that looping at the end of the video were super helpful!

Brian

[IamSriharat]

I would like to Know how to make a flow about 

first >> we create a form then we make a flow to show list in share point 

then 

second >> from the 1st form, we need to attached file with the new form  and how I can create the flow 

use the attached file form the 2nd form to update list in 1st form ?? 

Thank you in advance

Sriharat

[J_Ritschmann]

Hi,
Fantastic tutorial, thanks.
Maybe worth to notice, that the file is stored in Sharepoint if the form is part of a TEAMs channel.
Then you have to replace 

'Onedrive "Get File Content By Path"'
by
'Sharepoint "Get File Content By Path"'

[Dswenson]

Thanks @aprildunnam, What is the ETA on getting a native connector option for this without having to go through all these steps?