Save Microsoft Forms Attachments to SharePoint or Send via Email with Power Automate
HTML-код
- Опубликовано: 24 ноя 2023
- In this video I show you how to work with attachments that have been uploaded from Microsoft Forms. The techniques shown in the video will work well if there are multiple files uploaded or none at all.
I then show how you can send the file attachements in an email or upload to a SharePoint list. 
Хобби
Hi friend. You save my life. Thank you.
Thank you Paul.
Nice! I’ve always used a parse json step but this is much more elegant! I learn something from every video you post!!
Thank you Paul. I’ve tried like 5 other people’s solutions and yours is the only one’s who’s has worked. Not to mention the elegance of the if statement to parse out blank attachment submissions. Cheers!
You’re welcome and I’m glad you like the solution - but the sequel video solution is even better! Check it out …
ruclips.net/video/6dbL4aepkHo/видео.htmlsi=sRZ7YaJW6RFg1uc7
This is excellent!
I've been working on this issue for the past few days. My issue is that the attachment isn't in my OneDrive as form is Group-based, so the attachment goes into Shared%20Documents. "Get File Content" fails because it can't see/find the attachment.
Any tips on this please.
(now watching your part 2)
Thanks Paulie, I actually forgot to test a form response with a blank file upload before this video
Glad it helped Tyler! But the updated video is even better ruclips.net/video/6dbL4aepkHo/видео.html
@@PaulieM thanks, my client only has one upload field though so I’d rather keep it simple for them.
@@tylerkolota fair - I think the form actions could do with a little attention from Microsoft to make them a bit easier to use.
Thank you Paulie
Hi, Sorry another question, I've got the flow and everything working perfectly, Unfortunately i am leaving my current job and so i would like to pass this flow onto someone else, I have already made him a co owner and he can see the flow and edit it if needed, but when my account gets deleted I don't believe the flow will run because (correct me if I'm wrong) the Form automatically saves the file upload "attachments" to my One Drive, which will no longer exist soon. Any ideas please
Paul, as of 2024, before digging into your great video, is this the only way to add file(s) that's uploaded from MS Form via PowerAutomate to the SharePoint List? I've been hunting with the built in Action just in case there's a straightforward no-code approach, e.g., if form has attachment, copy/move/upload file(s) to desired created list item entry. It seems there should given PowerAutomate's other no-code solution... Thanks!
There isn’t a really easy way. It’s more difficult than it should be in my opinion. Hope the video helps you do what you need
Hi Paulie, Great Video!!
I have been trying to get form attachments to an email inbox for around a week - i created a sample form to get the power automate flow right and that has worked no problem.
My issue is, I have multiple questions are the 'upload' question option.
My question, is it possible to send an email with attachments if the attachments come from different questions within the SAME form?
And if the answer is Yes, how so.
a reply would be massively appreciated and i'll even go ahead and buy you a coffee via the link if succesfull! :)
Thanks in advance,
Ryan, a novice power automater.
Hi Ryan - it’s totally possible and pretty easy to do. Most of what you need to know is in this video. If you’re really stuck then please get in touch via my blog: www.tachytelic.net and I will help you out.
Hi, Thank you this is really helpful. I have a flow that needs to send an email that will contain an attachment of a PDF that the flow creates from the submitted form (already working well) but any ideas please how I can include the form file attachment as in your video to the same email. Thanks Again
Yes, you would just add your created PDF to the array of attachments.
Thanks for the reply, but sorry I don't understand, do I add the information to the "Append to Array Variable" somehow? Currently the PDF is created by the flow and saved to SharePoint then is attached to the "send email" using both attachments Name and Attachments Content. Thanks again @@PaulieM
Scrap that i've just figured it out, you need to make a second attachment "append to array variable" and put the PDF name and content in that json
@@deanotter7869 well done, that’s exactly the right thing to do.
Thank you for all of your videos Paul, I have tried following this tutorial verbatim (minus using my response ID's) and for some reason when I try to make the "if expression", it does not work. I get an error stating that the (expression is invalid).
Do you have any tips to get around this?
Please show me your expression and I will see if I can spot what is wrong with it.
Also check out my newer video which is titled the ultimate guide to forms etc. the method in that version can be even easier.
This is the if statement that I have following your tutorial.
if(
empty(json(outputs('Get_response_details')?['body/rccbcc2e482134ce1a0a5f288521bf305']))
json([])
json(outputs('Get_response_details')?['body/rccbcc2e482134ce1a0a5f288521bf305'])
)
@@PaulieM
This is the expression that I was using:
if(
empty(json(outputs('Get_response_details')?['body/rccbcc2e482134ce1a0a5f288521bf305']))
json([])
json(outputs('Get_response_details')?['body/rccbcc2e482134ce1a0a5f288521bf305'])
)
@@PaulieM
I Think my comments are getting flagged by the RUclips auto mod. I have replied twice with the expression that I have been using but the comment gets removed. @@PaulieM