How to Add Form Attachment in Power Automate Approval
Vložit
- čas přidán 27. 08. 2024
- In this video, you will see how to collect Microsoft Forms upload in Flow and add it as a supporting document in your approval request action card.
Making use of Microsoft Forms, Power automate, and Office365 Outlook.
Let me know if you have any questions in the comment session.
Link to the JSON code: gist.github.co...
#automation #analytics #powerautomate #approval
Yaaaaaas, finally. THANK you sooo much, I have been watchiing videos for 2 days & you are the first to solve my issue. Now I have to add a condition to route the form to specific approvers depending on a selection on the form. Great & clear instructions.
Thank you Col O. I am glad you found the video useful.
thanks, i stucked a long time until ur video
Thank You So Much! You saved me from my approval process that I have been working for weeks without any priory training on Power Automation!
This is exactly what I'm looking for. Thank you so much. Greetings from the Philippines. 🇵🇭
Glad you found the video useful. Thank you for watching @Rommel
Finally I found someone who really saved my life. Your video is perfect! Thank you so much for that man.
Hi Tassio, Glad you found the video helpful.
Thank you my friend! Excellent video! A special thanks from Brazil!
Amazing, the first video that has worked for me without any complications.
Thank you so muchhhhh for making this video. You saved me from my approval process that been stucked for weekssss!!!
Clear, concise, and worked flawlessly. Thank you!
Thank you so much ricardosolorzanoc. Glad you found it resourceful
Thank you mate. Excellent tutorial. Worked flawlessly!
Glad it helped
THANK YOU! I have been trying for days to find the way to do this.
great, that is it what I am looking for since weeks, nice greetings from germany :-)
Thank you Alexander. Glad you found it useful.
Thank you this is the easiest way to attached the file in email 🥰🥰🥰
Wow, thanks a lot this worked perfectly well for what I am currently working on big ups to you and your team.
You are a legend! I finally got it working because of your video :D
Thank you so much. Glad it helped
Nice, finally got it to work, thanks!
Thanks, your video helped me to attach a file in the email.
I have multiple files which need to be attached in the approval, does it work?
Thank you!!! I'm struggling too much for this and you solved it. Greetings from Europe!
Hi Ana Dordevic, glad this video was found useful and thank you for your comment.
Deeply appreciated
Yey! this is very helpful! :) thank you for sharing your expertise!
Trully appreciate your work, it helps me a lot! Thank you so much!
Glad it helped! you are very much welcome
I really need this, thank you very much!!
Thank you so much! this helped me alot ! Thank youuuuuu
Thanks so much!
very very useful! thanks a lot!
Glad you found this useful
very nicely explained! 👍
Sooo helpful! Thank you
Hello, I have tried this method but when I put more than one attachment, only one file attached and approval looping two times for each file. Any thought?
Hi, your video helped me a lot when I am using personal form. May I know if I am using a group form, I will face issue at the Get file content action. My file is stored in SharePoint sites, Shared Document > Apps > Microsoft Form > [File Name] > [Question request to upload attachment] > [Attachment File Name]
Could you give advice? Thank you!
Awesome.buddy thank u
My pleasure!
how to adding attachment to sequential approval?
thank you my brother
Thank you for the encouragement
Great video. It helps! By the way, how about for multiple attachments uploaded in the form?
Hi @ching Hon Lim. This is the video for multiple attachment czcams.com/video/Sz_pHKnOj1U/video.html
Thank you for the video! This works perfect for the Outlook email approval requests, but I can't see my attachment in the Approvals app in Teams. Are there extra steps needing to be taken to ensure I can see the attachment in Teams?
You are awesome!
thank you so much!!!!!!!
U saved my day brother
Hi! thank you so much for the video but how do i extract email id from sharepoint list for when the approval status is set for 'pending' but it is a multi level workflow.
hi thanks for the video but i had this issue, when viewing the attachment. 'It looks like we don't support this file format ' i tried png anf PDF both same
Thanks a lot for your message. This error is likely due to the file extension. Can you check the name of the file in the attachment. Did you add the file extension to it?
Thank you for the video! but I faced problem the attachment fail to load or no content in attachment. Any advise. Thank you.
I have both teams and outloook install on my system. The request pops up in Teams for like 5 seconds and then the outlook will show Request 9 was rejected without clicking on anything. Though if i open teams i will be able to approve from my approval add on. What seems to be the problem please?
have you had any issues lately where microsoft is making all the pdfs blank?
Thanks it helped me a lot
could you advise for multiple attachments
how about the attachment is more than one attachment?
Thanks for the thorough explanation. Please, is it possible for the the approver to view the form itself before approving? The approver will like to view a display of the form filled before approving. is it possible?
Hi Samuel, thank you for your comment. You can add the details of the form to the Approval. I guess what matters here is seeing what the person filled.
Better way to view the form than a link
Is there a video where you show us how you can add multiple attachments to Forms and so the approval mail? I can only get one attachment thourgh the flow with your help.
Hi, thank you for going through this resource.
You can add multiple attachment directly to the Parse JSON Action Card.
Just add as many file upload questions on the form to the Parse JSON input.
Leave other action cards intact.
It will processes the multiple inputs and add all as attachment to the approval.
Try this and let me know if it works.
@@TheOyinbooke i tried this but it triggers separate workflow for each file where only after approval of first file, second workflow is initiated.
Let me tell you my used case. I have two questions in Microsoft form to upload different files. For eg: Question 1: upload offer (this can have one or multiple files as upload) Question 2: upload negotiated order (this can have one or multiple files as upload). Now lets take a case if a a person uploads two files in question 1 and two files in question 2. Then the result expected is all four files to come as attachment in single email for approval.
Currently i am getting only file 1 from question 1 for approval, once it is approved, get file 2 of Question 1 for approval. Files from question 2 are not sent.
Eagerly awaiting your reply
Hi! Do you have tutorial for multiple files upload in forms?
Hi Myria Rafiz.
I am currently working on it and should be available tomorrow.
@@TheOyinbooke WOOWWW THANK YOUUU
@@TheOyinbooke Would appreciate that, please share the link once it is available. Thanks!
@@TheOyinbooke This is perfect timing as I have been getting an error when I try to upload more than one attachment from one question.
The Upload Multiple File In Power Automate Video will drop in 30 minutes time. Thank you for your patience and support
I am getting error at the says get action file failed. The JSON went through fine. Great video just not sure the issue.
Hi Misty, thank you for your comment.
Are you replicating similar scenario here?
@@TheOyinbooke I am the Json ran but it won't pull the file in. Does it need to be a certain type of file? Pdf or word?
thank you so much, i have case like this
i make a form and result of form i put in word with a mail merge concept, and i have a file of word that if responder fill the form and upload document the admin will aprove it after seeing the document. after seeing it admin will send a pdf that field of form has wrote on mail merge? can i use it in power automate ?
My get response details loads List of Response id instead of Response Id, and when I run the flow it talk about deserialisation needed, what do I do wrong🤔
Dear Sir...thank you for posting this video.
Suppose i allowed multiple upload in my form...let say 3
Will it send three approvals cause of the loop? Kindly help with this. I need one approval to be sent with all files attached
Hi Varun Goolaub, thanks for finding this video useful.
If the upload files are more than one, they will still get uploaded along side.
Kindly try it out and let me know if it work for you.
Am getting multiple approval...depending on number of file i hv uploaded...one more thing after approval I need to update sharepoint with manager response n comments...it prevents me to do so in that loop. If u hv any idea on this...kindly let me know. Thank you for ur video :)
hello boss, I am not able to see the attachment in the approvals page for teams application but able to see it in email. why is that ?
Thank you for your question. at the moment, the attachment doesn't appear in Teams Approval. I believe this will be worked on by the Microsoft Teams soon.
After watching the latest video I have a question which is the attachment in a Microsoft form shouldn’t it be saved automatically to One drive or Sharepoint?
And if so, why use JSON when you can use the sharepoint or one drive directly?
Kindly help expatiate more the need for the JSON code?
By default, every attachment in Microsoft Forms are saved in a folder on OneDrive for business.
However, for you to use the attachment meant for each respondents in Power Automate, you will need to follow the process shown here. E.g. we want to make sure the manager who is receiving the approval request have access to any supporting document, this is why we use Power Automate to attach the file alongside.
I do hope this clarifies your question?
@@TheOyinbooke yeah but the main reason for the JSON script is what am a bit confuse about?
Like the birthday video, we didn’t use the JSON script
I really want to know when we use the JSON script?
@@AMAdet when you upload a file using Microsoft Forms. Several other data are collected alongside, e.g. filename, filesize, file content, and other metadata.
The JSON file will help to separate all these elements so that you can pick the exact one you need which in our case is the Content uploaded and not it's accompanied metadata
@@TheOyinbooke thanks for this, understood the importance now
Thanks for your guidance,
I tried this but when I have to take decision basis the approver action like if approver approve it should add details in excel file on onedrive, it's giving error as below,
correct to include to valid reference first approval to input parameters(s) of action apply to each
Dear Amol,
Apologies for the late response. The error message is unclear and I hope you have been able to fix it.
The JSON file is it a constant code or alter-able based on the content of the attachment?
It is a constant code.
How did u get the id?
Hi , which of the id?
Does the flow can carry more than 1 attachment to the approver? Like if i uploaded 2 soft file which is needed for approval. Does the flow can carry it all for approval? Will it all reflect on the email approval???
Hi SUNDAE SOUP,
Yes, the flow can carry multiple files as well.
If I upload 2 files on the forms it only carry one file on the approvals any idea why this is happening?
Hi Many thanks for the above which explains one attachement to be sent on the approval flow stage iteself. Is there a way to send multiple attachments in an approval action stage. The flow i have created works on the Teams alert with hyper link to two attachments, through a create variable option, but in the email, the hyper link is not showing and only shows as string. So the approve/reject email does not have the attachments.
Thank you for your feedback.
See the link for multiple attachment
czcams.com/video/Sz_pHKnOj1U/video.html
Hello,
Could you please let me know.
How can I create the microsoft form for approval with many attachments on power automate. ?
I have already created the flow as your suggestion on video , but when approver received the attachments.
It shown only 1 file even I attached 7-8 files
Please kindly give me a trick😅.
Remark : currently my company has not allow to access to sharepoint on microsoft365.
hi
I need small support.
I am getting below error
Unable to process template language expressions in action 'Parse_JSON' inputs at line '1' and column '36082': 'Required property 'content' expects a value but got null. Path ''.'.
could you pls help me?
Hi, Apologies for my late response. Have you been able to fix this issue?