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 … th-cam.com/video/6dbL4aepkHo/w-d-xo.htmlsi=sRZ7YaJW6RFg1uc7
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.
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.
Hi Paul, do you have a solution on how to share attachment in an email using the "Share Email Notification (V3)" flow for a SharePoint group form? My form includes a mixture of single and multiple file upload options. Thank You!
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 .
@@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.
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.
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!
Could you please advise how to proceed with this matter? I create a Microsoft forms for Purchase Requisition (data with attachments). Then I create a flow in Power Automate (get response details , add a row in a Excel table (I didn't use Sharepoint List, Start an approval and wait for approval, email to submitter whether it is approved or reject). It is successful. But I still have the requirements which I stuck on Power Automate flow; - save approval email as .eml file - Create new folder in specific sharepoint library. - send the .eml file with attachments from submitted Microsoft Forms to specific sharepoint folder.
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
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
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
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?
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 TH-cam auto mod. I have replied twice with the expression that I have been using but the comment gets removed. @@PaulieM
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)
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!
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 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.
The absolute easiest way - Extract those attachments in a single action! th-cam.com/video/HczcB6n7FnY/w-d-xo.html
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 …
th-cam.com/video/6dbL4aepkHo/w-d-xo.htmlsi=sRZ7YaJW6RFg1uc7
Nice! I’ve always used a parse json step but this is much more elegant! I learn something from every video you post!!
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 th-cam.com/video/6dbL4aepkHo/w-d-xo.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.
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.
if(
empty(json()),
json('[]'),
json()
)
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.
Hi Paul, do you have a solution on how to share attachment in an email using the "Share Email Notification (V3)" flow for a SharePoint group form? My form includes a mixture of single and multiple file upload options. Thank You!
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 .
No, it’s still there. It’s under data operations.
@@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.
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.
You would use the create file action using the array variable as the source.
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
Could you please advise how to proceed with this matter?
I create a Microsoft forms for Purchase Requisition (data with attachments).
Then I create a flow in Power Automate (get response details , add a row in a Excel table (I didn't use Sharepoint List, Start an approval and wait for approval, email to submitter whether it is approved or reject). It is successful.
But I still have the requirements which I stuck on Power Automate flow;
- save approval email as .eml file
- Create new folder in specific sharepoint library.
- send the .eml file with attachments from submitted Microsoft Forms to specific sharepoint folder.
Hi - please post a question on powercoders.net and I will try to help you there.
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.
Hi friend. You save my life. Thank you.
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
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 TH-cam auto mod. I have replied twice with the expression that I have been using but the comment gets removed. @@PaulieM
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)
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!
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 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.
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?
Thank you Paulie
Thank you Paul.