How to Add Form Attachment in Power Automate Approval

Рет қаралды 19,261

3 жыл бұрын

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.com/theoyinbooke/...
#automation #analytics #powerautomate #approval

Пікірлер: 98

@colzo6361 3 жыл бұрын

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.

@TheOyinbooke 3 жыл бұрын

Thank you Col O. I am glad you found the video useful.

@krhodem 3 жыл бұрын

THANK YOU! I have been trying for days to find the way to do this.

@dataisfun4964 2 жыл бұрын

Wow, thanks a lot this worked perfectly well for what I am currently working on big ups to you and your team.

@ricardosolorzanoc 3 жыл бұрын

Clear, concise, and worked flawlessly. Thank you!

@TheOyinbooke 3 жыл бұрын

Thank you so much ricardosolorzanoc. Glad you found it resourceful

@MitchTorres 2 жыл бұрын

Yey! this is very helpful! :) thank you for sharing your expertise!

@armandofalcao5639 2 жыл бұрын

Thank you my friend! Excellent video! A special thanks from Brazil!

@user-gh5sm1rj6x Жыл бұрын

Thank you so muchhhhh for making this video. You saved me from my approval process that been stucked for weekssss!!!

@sharonmary7082 6 ай бұрын

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!

@nishchaymohan4574 2 жыл бұрын

Thank you mate. Excellent tutorial. Worked flawlessly!

@TheOyinbooke 2 жыл бұрын

Glad it helped

@rommelmangundayao5880 3 жыл бұрын

This is exactly what I'm looking for. Thank you so much. Greetings from the Philippines. 🇵🇭

@TheOyinbooke 3 жыл бұрын

Glad you found the video useful. Thank you for watching @Rommel

@EpicDreamer_ 3 жыл бұрын

Thank you!!! I'm struggling too much for this and you solved it. Greetings from Europe!

@TheOyinbooke 3 жыл бұрын

Hi Ana Dordevic, glad this video was found useful and thank you for your comment. Deeply appreciated

@tekhaitan2501 Ай бұрын

thanks, i stucked a long time until ur video

@primrosematsika948 5 ай бұрын

Amazing, the first video that has worked for me without any complications.

@filmyfilms6905 3 жыл бұрын

You are a legend! I finally got it working because of your video :D

@TheOyinbooke 3 жыл бұрын

Thank you so much. Glad it helped

@thomassinks5093 4 ай бұрын

Nice, finally got it to work, thanks!

@relayprotection 2 жыл бұрын

Trully appreciate your work, it helps me a lot! Thank you so much!

@TheOyinbooke 2 жыл бұрын

Glad it helped! you are very much welcome

@adrianarestrepom24 2 жыл бұрын

I really need this, thank you very much!!

@alexanderkruger1344 3 жыл бұрын

great, that is it what I am looking for since weeks, nice greetings from germany :-)

@TheOyinbooke 3 жыл бұрын

Thank you Alexander. Glad you found it useful.

@tassioferreira4028 3 жыл бұрын

Finally I found someone who really saved my life. Your video is perfect! Thank you so much for that man.

@TheOyinbooke 2 жыл бұрын

Hi Tassio, Glad you found the video helpful.

@ShafikaNadia Жыл бұрын

very nicely explained! 👍

@kwekkazoid1524 7 ай бұрын

Thank you so much! this helped me alot ! Thank youuuuuu

@arps0813 Жыл бұрын

Sooo helpful! Thank you

@justrhuna2263 2 жыл бұрын

Thank you this is the easiest way to attached the file in email 🥰🥰🥰

@FrankSzalai 2 жыл бұрын

You are awesome!

@deasuluashvili5530 2 жыл бұрын

very very useful! thanks a lot!

@TheOyinbooke 2 жыл бұрын

Glad you found this useful

@hormuzddaruwalla5465 2 жыл бұрын

U saved my day brother

@madridi907 3 жыл бұрын

Thanks it helped me a lot

@vishalkarthik9971 3 ай бұрын

Thanks, your video helped me to attach a file in the email.

@vishalkarthik9971 3 ай бұрын

I have multiple files which need to be attached in the approval, does it work?

@KhadeejaAhmed-bp8gb 2 ай бұрын

thank you so much!!!!!!!

@hormuzddaruwalla5465 2 жыл бұрын

Awesome.buddy thank u

@TheOyinbooke 2 жыл бұрын

My pleasure!

@s.ziemianin 3 жыл бұрын

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?

@MrKaluuka 2 жыл бұрын

thank you my brother

@TheOyinbooke 2 жыл бұрын

Thank you for the encouragement

@mohammadnajibdaud8844 3 жыл бұрын

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?

@luckiestgirl3138 11 ай бұрын

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.

@muhamadismail8671 6 ай бұрын

Thank you for the video! but I faced problem the attachment fail to load or no content in attachment. Any advise. Thank you.

@sethuelijah5342 3 жыл бұрын

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🤔

@poeret1 Жыл бұрын

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 ?

@idrislabaran2686 Жыл бұрын

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?

@noppw.8649 Жыл бұрын

could you advise for multiple attachments

@chinghonlim5158 2 жыл бұрын

Great video. It helps! By the way, how about for multiple attachments uploaded in the form?

@TheOyinbooke 2 жыл бұрын

Hi @ching Hon Lim. This is the video for multiple attachment kzfaq.info/get/bejne/ieCPo6t807XOYYk.html

@amolmane8747 3 жыл бұрын

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

@TheOyinbooke 3 жыл бұрын

Dear Amol, Apologies for the late response. The error message is unclear and I hope you have been able to fix it.

@ucup33 7 ай бұрын

how about the attachment is more than one attachment?

@siva65kumar 2 жыл бұрын

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.

@TheOyinbooke 2 жыл бұрын

Thank you for your feedback. See the link for multiple attachment kzfaq.info/get/bejne/ieCPo6t807XOYYk.html

@sachiniwickramasinghe1912 8 ай бұрын

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

@TheOyinbooke 8 ай бұрын

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?

@sagasam1 3 жыл бұрын

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?

@TheOyinbooke 3 жыл бұрын

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

@myfaithisdivinity Жыл бұрын

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.

@AMAdet 3 жыл бұрын

The JSON file is it a constant code or alter-able based on the content of the attachment?

@TheOyinbooke 3 жыл бұрын

It is a constant code.

@damindagunasekara3485 3 жыл бұрын

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?

@TheOyinbooke 2 жыл бұрын

Hi, Apologies for my late response. Have you been able to fix this issue?

@KellysOnlineTechTips 3 жыл бұрын

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.

@TheOyinbooke 3 жыл бұрын

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.

@rupeshmalewadkar454 3 жыл бұрын

@@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

@bashthetrader 2 жыл бұрын

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 ?

@TheOyinbooke 2 жыл бұрын

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.

@nickisashkir 3 ай бұрын

have you had any issues lately where microsoft is making all the pdfs blank?

@sundaesoup6865 2 жыл бұрын

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???

@TheOyinbooke 2 жыл бұрын

Hi SUNDAE SOUP, Yes, the flow can carry multiple files as well.

@aarondiaries1519 2 жыл бұрын

If I upload 2 files on the forms it only carry one file on the approvals any idea why this is happening?

@AMAdet 3 жыл бұрын

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?

@TheOyinbooke 3 жыл бұрын

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?

@AMAdet 3 жыл бұрын

@@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?

@TheOyinbooke 3 жыл бұрын

@@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

@AMAdet 3 жыл бұрын

@@TheOyinbooke thanks for this, understood the importance now

@mistyw9531 2 жыл бұрын

I am getting error at the says get action file failed. The JSON went through fine. Great video just not sure the issue.

@TheOyinbooke 2 жыл бұрын

Hi Misty, thank you for your comment. Are you replicating similar scenario here?

@mistyw9531 2 жыл бұрын

@@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?

@shazja25 2 жыл бұрын

Hi! Do you have tutorial for multiple files upload in forms?

@TheOyinbooke 2 жыл бұрын

Hi Myria Rafiz. I am currently working on it and should be available tomorrow.

@shazja25 2 жыл бұрын

@@TheOyinbooke WOOWWW THANK YOUUU

@chinghonlim5158 2 жыл бұрын

@@TheOyinbooke Would appreciate that, please share the link once it is available. Thanks!

@doublegg2k145 2 жыл бұрын

@@TheOyinbooke This is perfect timing as I have been getting an error when I try to upload more than one attachment from one question.

@TheOyinbooke 2 жыл бұрын

The Upload Multiple File In Power Automate Video will drop in 30 minutes time. Thank you for your patience and support

@varungoolaub4437 3 жыл бұрын

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

@TheOyinbooke 3 жыл бұрын

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.

@varungoolaub4437 3 жыл бұрын

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 :)