Save Microsoft Forms Attachments to SharePoint or Send via Email with Power Automate

Рет қаралды 6,348

8 ай бұрын

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.
If you want the absolute easiest method of extracting attachments, check out Power Automate Power Tools:
www.tachytelic.net/power-auto...

Пікірлер: 39

@PaulieM 10 күн бұрын

The absolute easiest way - Extract those attachments in a single action! www.tachytelic.net/power-automate-power-tools/

@robofski 8 ай бұрын

Nice! I’ve always used a parse json step but this is much more elegant! I learn something from every video you post!!

@Rsdixiedoo2 5 ай бұрын

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!

@PaulieM 5 ай бұрын

You’re welcome and I’m glad you like the solution - but the sequel video solution is even better! Check it out … kzfaq.info/get/bejne/bMqSf5eSytbPeKM.htmlsi=sRZ7YaJW6RFg1uc7

@AlejandroGarcia-tn5nj 2 ай бұрын

Hi friend. You save my life. Thank you.

@AlejandroGarcia-tn5nj 2 ай бұрын

Thank you Paul.

@nguyenmanhtuan1772 8 ай бұрын

Thank you Paulie

@tylerkolota 5 ай бұрын

Thanks Paulie, I actually forgot to test a form response with a blank file upload before this video

@PaulieM 5 ай бұрын

Glad it helped Tyler! But the updated video is even better kzfaq.info/get/bejne/bMqSf5eSytbPeKM.html

@tylerkolota 5 ай бұрын

@@PaulieM thanks, my client only has one upload field though so I’d rather keep it simple for them.

@PaulieM 5 ай бұрын

@@tylerkolota fair - I think the form actions could do with a little attention from Microsoft to make them a bit easier to use.

@taimishu Ай бұрын

Hi Paul- this is undoubtedly the best video for dealing with attachments/no attachments from forms. Thank you! One question- if I needed to drop the attachment (if any) in a newly created folder, how would this differ from sending an email? I am a bit lost after initializing the variable.

@PaulieM Ай бұрын

You would use the create file action using the array variable as the source.

@JessicaAdams-tw4hc Ай бұрын

Hi. Thank you very much for this video. Solution was extremely helpful for my project. I was hoping to get some more advice from you on taking it one step further. At the end of your video, you show us how to create a file and add it to a document library and also how to add metadata. In my business case, my flow continues on after this to Create an Item in SharePoint and to Send an Email. I use a Condition/Control in this step because there is a Yes/No question in my Form that drives how the Item is created and what email is sent - one way for Yes responses and another way for No responses. Anyways, I'm getting stuck with the Update File Properties action because I need to add metadata to the file created in the last step of the video, but the metadata needs to come from the Item that is created in the later step. If I try to Update File Properties within the apply to each action, by copying the code from the later Create Item step I obviously get an error because it's trying to pull data from an action that hasn't run yet. However, if I add an action after the Create Item / Send Email steps then I still get an error because it says I cannot update the file outside the apply to each step. Any suggestions?? It has to be doable and adding this step is critical to the overall success of my business case.

@PaulieM Ай бұрын

It is undoubtedly possible. Perhaps add a variable in the apply to each loop that you can access from outfit of the loop to control your condition?

@deanotter7869 4 ай бұрын

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

@pmd7530 2 ай бұрын

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)

@kimkeane Ай бұрын

Hi, what if we have branching options within the form, with each branch requiring a file upload? This flow only works on one branch even if i create a parallel within power automate or use a condition. Despite the one issue above, thank you so much for youre amazing video though!

@boelsevier8346 6 ай бұрын

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!

@PaulieM 6 ай бұрын

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

@user-pm2wp9pw2v 7 ай бұрын

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.

@PaulieM 7 ай бұрын

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.

@mariuskombou6729 Ай бұрын

Thank you Paul for this elegant videos. I'm trying to apply it but I can't find the Compose action. I am wondering if it has been deleted in the recent version .

@PaulieM 26 күн бұрын

No, it’s still there. It’s under data operations.

@mariuskombou6729 22 күн бұрын

@@PaulieMThanks for your reply. I think it has been named "Message". Actually I am using the French version and the action named Message has the samedi field.

@colzo6361 Ай бұрын

Good Day, sorry but what did you enter at 10:16 the "If" expression for the Each Form Attachment? I don't get what happened there; I'm stuck. Just a little tip to go/click a little slower as well for non-computer majors.

@JessicaAdams-tw4hc Ай бұрын

if( empty(json()), json('[]'), json() )

@JessicaAdams-tw4hc Ай бұрын

in the first json() and second json() you just need to copy and paste the code for that item...i was able to get it by clicking the "fx" and then doing the Dynamic Content and clicking on the field I wanted to pull from.

@deanotter7869 4 ай бұрын

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

@PaulieM 4 ай бұрын

Yes, you would just add your created PDF to the array of attachments.

@deanotter7869 4 ай бұрын

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

@deanotter7869 4 ай бұрын

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

@PaulieM 4 ай бұрын

@@deanotter7869 well done, that’s exactly the right thing to do.

@CTC-Wade 4 ай бұрын

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?

@PaulieM 4 ай бұрын

Please show me your expression and I will see if I can spot what is wrong with it.

@PaulieM 4 ай бұрын

Also check out my newer video which is titled the ultimate guide to forms etc. the method in that version can be even easier.

@CTC-Wade 4 ай бұрын

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

@CTC-Wade 4 ай бұрын

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

@CTC-Wade 4 ай бұрын

I Think my comments are getting flagged by the KZfaq auto mod. I have replied twice with the expression that I have been using but the comment gets removed. @@PaulieM