Flow Approval Attachments - Power Automate Tutorial

Подписаться 131 тыс.

Просмотров 85 тыс.

50% 1

This video is a beginner’s tutorial on working with the flow approval attachments feature in Power Automate. If you ever wanted to attach files to an approval flow, because you wanted to share a copy of a document without having to share a live online link, or you simply prefer file attachments, you are going to love this.
We will work with flow approval attachments array, attachments content, work with multiple attachments and more.
Video covers 4 scenarios:
✅ Microsoft Forms file uploads as flow approval attachments
✅ SharePoint document library file as flow approval attachments
✅ SharePoint list item attachments as flow approval attachments
✅ Outlook email attachments as flow approval attachments
Approval flows playlist: • Flow Approvals Cookbook
File attachments in approval flows: flow.microsoft.com/en-us/blog...
Flow approval attachments limits: support.microsoft.com/en-us/t...
#PowerAutomate #Approvals #SharePoint #Outlook #MicrosoftForms
Table of Contents:
00:00 - Introduction
00:49 - Power Automate flow Approval attachments overview
01:38 - SharePoint document - add file as attachment for approval flow
06:27 - Add SharePoint list item attachments as approval attachments
13:45 - Microsoft Forms file uploads - add as attachments to approval workflow
22:23 - Outlook email attachments as approval attachments in Power Automate
26:46 - Power Automate Approval Attachment Limitations and Restriction - max file size limit & more
28:52 - Subscribe to Reza Dorrani channel

Опубликовано:

5 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 445

@cmarkbernal 3 года назад

Once again, you're mind reading. We were just talking about a process we have that is being done via Outlook voting for approval and One Note, and now want to switch to Power Automate approvals as attachment. So this, partnered with PA print to PDF is going to be golden for us. I also love the Chapters feature added to your videos, so you can share directly to a specific spot. Thank you for adding that!!

@RezaDorrani 3 года назад

So glad to hear that this will be leveraged in a real world use case. Thanks for sharing the info. Chapters is my favorite as well :)

@nickolaslavrenchuk3890 2 года назад

I was struggling with this problem for about 5 hours and was so thankful to come by this video. THANK YOU!

@RezaDorrani 2 года назад

You are most welcome!

@teresaagustin5191 Год назад

Reza, thank you for making this video. You really helps me out today and obviously many others with almost 60,000 views. We appreciate all you do. Please keep the great content coming. Not sure what we’d do without you. Best regards, Teresa

@RezaDorrani Год назад

Thank You so much Teresa for all the appreciation

@elizabethtoby9086 11 месяцев назад

Thank you for a fantastic explanation for how to do this process and WHY you're having to add certain steps. This is the second video I've digested of yours today that has gotten me further than any Power Automate learning documentation has. Thank you!

@RezaDorrani 11 месяцев назад

So happy to hear the feedback! Thanks so much for watching and learning from the videos.

@catapalfi6760 Год назад

This is amazing! All your videos are PURE GOLD! Thank you so much Reza!

@RezaDorrani Год назад

Most welcome and thanks so much for watching and liking the videos.

@vfontanav 2 года назад

Man, I would like to thank you for this video! I was looking for days for a way to catch attachments from Outlook e-mail to approvals without any success! Your video explained all scenários with a LOT of USEFUL information! Thanks, thanks and thanks!!!!!

@RezaDorrani 2 года назад

Glad to know this video is useful. I always try to cover most common scenarios. Happy to hear the positive feedback. Thanks for watching.

@alzaimoor79 3 года назад

Great video. Full scenario of approval attachments. Thanks for sharing

@RezaDorrani 3 года назад

Glad you enjoyed it

@horamansarkhosh8615 3 года назад

Thanks Reza... Awesome...Your teaching style is excellent and is based on real-world projects...👍💚

@RezaDorrani 3 года назад

Glad you enjoyed the video. Thank You for your kind words :)

@amandaamarante6857 2 года назад

OMG!! Thank you Reza! Now Im going to speak in Portuguese (my language). Obrigada Reza, os seus vídeos estão me ajudando muito. Ótima explicação e ótimos exemplos.

@RezaDorrani 2 года назад

You are most welcome! VOCÊ É MUITO BEM-VINDO

@joetaylor1916 Год назад

Amazing video, been struggling with List Item attachments for Approvals for a while now! Thank you

@RezaDorrani Год назад

Most welcome! Thanks for watching Joe

@5394prashant 3 года назад

Amazing Video. You are a Genius Reza. I have been looking for this solution for such a long time. 😊

@RezaDorrani 3 года назад

Glad I could help. Goal was to cover multiple scenarios of approval attachments. Thank You for watching.

@MrPhelord 2 года назад

thank you for your guideline. this is a method what i've been waiting for multiple attachment.

@RezaDorrani 2 года назад

Thanks for watching

@calvinmunisi346 2 года назад

This is an awesome video. Pure gold as always!!

@RezaDorrani 2 года назад

Glad you enjoyed it!

@lxz86 3 года назад

Great video. Full scenario of approval attachments. Thanks for sharing totally agreed， perfect guide for the fresh learner

@RezaDorrani 3 года назад

Glad you enjoyed it!

@martinargimon730 Год назад

excellent video reza. Very practical example. thanks a lot ! ( martin from South Africa)

@RezaDorrani Год назад

Thanks for watching

@namangupta6440 3 года назад

I am a non engineering, non IT guy, with background in commerical studies only and now learned so much just from two videos and in-fact even started implementing at my workplace. WoW.

@RezaDorrani 3 года назад

Great story this! So happy to hear how quickly you have started implementing these at your workplace. Best of luck & keep learning.

@namangupta6440 3 года назад

@@RezaDorrani In a scenario where after the list item ( eg expense reimbursement) & its attachment (eg invoice) have been approved, how can the log of approval + attachment be generated as one file or a sharepoint item so that user can now proceed to upload the approval as well attachment on Expense reimbursement tool/ Payment tool

@ciglobal5304 2 года назад

You are great!!! Thanks, your video helped and taught me a lot.

@RezaDorrani 2 года назад

Glad to hear that!

@familiamorabarquero 2 года назад

Thanks for sharing. It was exactly what I was looking for.

@RezaDorrani 2 года назад

Glad it was helpful!

@goomis90 Год назад

The best video, thank you very much! :)

@RezaDorrani Год назад

Glad you liked it!

@somisadegi361 Год назад

Thank you Reza for your great videos!

@RezaDorrani Год назад

Most welcome

@EpicDreamer_ 3 года назад

Thank you Reza! That is what I need!

@RezaDorrani 3 года назад

Great!

@edwinjonah 2 года назад

Just what I needed, thanks!

@RezaDorrani 2 года назад

Glad to hear it!

@RobThornley Год назад

Spend ages today looking for a solution for processing Outlook email attachments and attaching them to an Approval workflow. Your video was very helpful and resolved by issue. 👍👍

@RezaDorrani Год назад

Glad I could help!

@ketlinelizabethgarcia6766 2 года назад

Hi, Reza tks for the video! U r the best!

@RezaDorrani 2 года назад

Hey, thanks!

@fe271 Год назад

You just saved my life... thanks a million

@RezaDorrani Год назад

Most welcome

@pratikdarak8863 3 года назад

Thanks for sharing this. For me perk of video was Limitations related info

@RezaDorrani 3 года назад

Thank you for watching

@cvkealey 3 года назад

This is a fantastic and comprehensive view of the most likely scenarios. The method you use for the Forms attachments is quite a bit simpler than what I've been using. I'll have to try that with a group form to see if it works there as well (I suspect it will). Also, as a heads-up to anyone that wants to save those files to SharePoint, you might want to append something to the file name to ensure uniqueness (for example, the current timestamp). If the "Create file" action tries to add a file with a name that already exists, the flow will fail.

@RezaDorrani 3 года назад

Thank you. All valid points. Group forms with SharePoint will also work. Check - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kbqXsKPTmZk.html

@cvkealey 3 года назад

OK, tried with a Group form and found that in the "Get file content" input, you need to add the "driveId" and a period before the "id". This can be done in one expression: concat(item()['driveId'],'.',item()['id']). The only issue is that I like to append a timestamp to the file name (to ensure unique values) and because the value returned by item()['name'] includes the file extension, it's difficult to insert it between the name and the extension. I got around this by adding a "get file metadata" action, which has a "file name without extension" output, and using some string manipulation to split out the extension and append it after the timestamp. Kind of messy, but it works.

@RezaDorrani 3 года назад

@@cvkealey As long as it works :)

@balqishaida2391 9 месяцев назад

thank you so much😭My friend and I struggle to create the flow :') We use the fourth scenario to create in lieu submission approval. This video really helpful!🤓

@RezaDorrani 9 месяцев назад

You're most welcome

@gledsonsantos7518 Год назад

Very useful, congratz Reza

@RezaDorrani Год назад

Thanks

@nick1345 2 года назад

Your a legend mate! Thank you

@RezaDorrani 2 года назад

Thanks Nick. My subscribers are legends who keep suggesting awesome topics.

@LuiIacobellis 3 года назад

Great tutorial, thanks Reza

@RezaDorrani 3 года назад

Thanks for watching

@user-rr5bl6hp9l 6 месяцев назад

thank you so much! been trying to find a tutorial how to attach existing sharepoint file to power automate approval.

@RezaDorrani 6 месяцев назад

You're welcome!

@akkaradechsrithongchai7766 3 года назад

This lesson is very good with Zoom screen too helpful .

@RezaDorrani 3 года назад

Glad to hear that!

@jorgeperal09 2 года назад

Great!!, Really you save me!!

@RezaDorrani 2 года назад

Glad to know the video is helpful.

@pawanmishra6549 3 года назад

Thanks Reza, big fan 👍👍

@RezaDorrani 3 года назад

Thank you for following my work.

@user-bt7ho9fp6y Год назад

Thank you very much, Reza. A very useful video on sending attachments from a SharePoint email. Please make a video about archiving SharePoint with attachments.👍🤝🙏

@RezaDorrani Год назад

Thanks! I make videos when I receive multiple requests on a topic. I have ideas with over 50+ requests in my backlog

@side54723 3 года назад

Thank you Reza :) Microsoft has improvements to make in order to make such scenario more accessible to business users... It is a low code platform.. Waiting for that there is Reza !!!

@RezaDorrani 3 года назад

I wish all the JSON outputs were the same for consistency. Till then you have my videos :)

@Post-it-note330 Месяц назад

Thanks so much!!!

@RezaDorrani Месяц назад

You're most welcome!

@prajwalskateel 3 года назад

Great video

@RezaDorrani 3 года назад

Thanks!

@Billbear24 3 года назад

Thank you!

@RezaDorrani 3 года назад

You're welcome!

@abbasthegreat5 Год назад

Thank you sir

@RezaDorrani Год назад

Most welcome

@dhootsachin 3 года назад

You are Awesome !!!. Great Thank you

@RezaDorrani 3 года назад

Happy to help!

@dhootsachin 3 года назад

@@RezaDorrani using Forms we are getting data from user then further generated approval process using power automate. Can we create same kind of form using SharePoint? so we can take input or response from user and automate this SharePoint for approval process. Could you please make this video Thank you So much !!! Really appreciated the way you explain in video.

@RezaDorrani 3 года назад

@@dhootsachin Power Automate approval forms cannot be customized. You could use SharePoint forms and trigger approval by calling flow. It all depends on use case. I do not have a specific video on this. I would recommend you post your query with screenshots on the forums at powerusers.microsoft.com/

@yanaandsophia 3 года назад

Thank you Reza great

@RezaDorrani 3 года назад

You are most welcome

@rudiolivier7494 3 года назад

LOVE This video. I was looking for a solution for so long and not being use to flow I did not understand the other videos. But this is great. I was wondering if I look at (Microsoft Forms file uploads - add as attachments to approval workflow) How do I add the responses in the Form as an attachment with the other attachments.

@RezaDorrani 3 года назад

Responses of the form is something that you could create an html file or pdf file of and then load it to attachments. I do not have a specific video on this. I have one that shows how to build the pdf file - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Da4do2DxmJE.html which may help.

@bharatishukla1358 Год назад

Reza to the rescue again 🙌🏻

@RezaDorrani Год назад

@christianneu1258 3 года назад

Thanks Reza for all your amazing videos & tips. Is it really recommendable to use approval attachments? What about the underlying Dataverse? Doesn't this approach consume an incredible amount of memory? Is there an "auto-cleanup" or something else to get rid-off already processed approval actions and their attachments? Otherwise, I see a big risk if such an approach is widely used in an organization.

@RezaDorrani 3 года назад

Great question. As far as I know, all approvals related data, history etc. get deleted after 28 days or so. So my assumption is the attachments will also get deleted.

@haliimailekaauwai2868 2 года назад

Hello Reza! Another great video. Question, with the attachments, if an approver needed to make edits to one of the documents, would they be able to open the document and make their edits? Or will the document need to be downloaded to their desktop, edited, and reuploaded? TIA

@RezaDorrani 2 года назад

Downloaded, edited and reuploaded.

@GregZanone 3 года назад

Hi Reza, Thanks for the great videos! 1) What's the difference between using the compose action with json() and just using the parse json action? 2) When I use your method I seem to be having problems getting Flow to recognize the array and allow me to use it in the approval action as an attachment. Not sure why. 3) What do I do if I have more than one question with attachments that need to be approved? (Not multiple uploads in the same question -- multiple questions.) 4) I seem to be getting the 'AttachmentContentNotValidBase64String' which is frustrating.

@RezaDorrani 3 года назад

1) You could go either ways. Parse JSON will always expect a particular JSON schema. json() will just return the JSON equivalent of the data. 2) I would have to look at your flow in action to provide guidance. Post your issue with screenshots on the forums at powerusers.microsoft.com/ 3) You loop through each question separately and load it in same attachments array 4) Post your issue with screenshots on the forums at powerusers.microsoft.com/

@kathrynhall2019 2 года назад

Such a detailed video, thank you. I've been battling with this and I'm so close, but I'm still hitting a couple of snags... - I'm trying to send an email after the create file step and include a copy of the attachment, but it's tapping out because it's looking for 'ContentBytes', not Content. - My attachments, although they are coming through and also saving in the correct format, are blank and I'm not sure why - Is there a point in the flow where I can rename the attachment to something more descriptive? Ideally using the dynamic content from the form itself? Thank you 😊

@RezaDorrani 2 года назад

1) Create file step needs contentbytes structure. You would need to modify the flow accordingly. 2) I would have to look at your flow in action to provide guidance. 3) When creating the file is your data source, you can rename it. I do not have a video reference on the above scenarios and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@julien8979 3 года назад

Amazing, thanks for sharing! Is it possible to track the versioning history of the file changes that are attached to an item in the SP list attachments (Word/PDF/Excel)?

@RezaDorrani 3 года назад

I don't think list item attachments are versioned.

@58oldguy 3 года назад

Thank you for this Reza. I could never have figured it out without your wonderful explanation. One thing though, I have not been able to get a submit button to appear in the approval email. Clicking approve or reject always opens the Approvals Center. Is there something I am missing?

@RezaDorrani 3 года назад

Thank you for watching. Actionable emails in Outlook is related to Outlook versions. Check docs.microsoft.com/en-us/outlook/actionable-messages/

@kathy5771 3 года назад

Hi Reza, Thank you for showcasing the approval flow with attachments! I follow the steps and successfully create the flow with attachments in the Outlook email. However, the action "start and wait for an approval" will also trigger approval requests on MS Teams with no attachment. My question is, would it be able to have the attachment on MS Teams too? If this is another limitation of Power Automate, is it possible to suspend the notification on MS Teams?

@RezaDorrani 3 года назад

I don't believe Teams attachments are supported yet. This is a current limitation.

@lidiamorazan530 5 месяцев назад

Hi, thank you so much for your tutorial, it's really helpfull! I'm trying to do the same thing but from a Sharepoint Document library and the ''Get attachements'' action doesn't work. Do you know which action I should choose? Thank you!

@RezaDorrani 5 месяцев назад

Get attachments is only for list items. Get files is for document library.

@vimbaimatanda3912 Год назад

Great video! I have a question regarding your start and due dates in your list, how were they populated? Is there a video where you demonstrate this? I would like to create the same flow with attachments that runs from the date the request is submitted up until a particular due date, with email reminders.

@RezaDorrani Год назад

Its a standard SharePoint list with 2 custom date columns added. I do not have a video showcase the steps.

@akanksha5573 9 месяцев назад

Hey i love the way u teaching ✨..want to ask u can we mandate or rename attachment field in sharepoint new list?

@RezaDorrani 9 месяцев назад

Thanks. Attachments cannot be made mandatory as far as I know. You could rename them. I kind of show it in my latest video - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Aerky9hiYDo.htmlsi=WELuuimiuNwFcsAT

@teganhage6612 2 года назад

Great video Reza. I need to create a flow where the attachments from a Sharepoint form generate on 2 subsequent approvals and then an email with attachments. The Attachments array variable you described works perfectly for both approvals and keeps failing on the last step 'Send an email'. Do you have any suggestions?

@RezaDorrani 2 года назад

I will have to look at your flow in action to know the cause of your issue. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

@ryanlevandoski2086 Год назад

Reza, great video again. Is there a way to add attachments when utilizing a Approval Matrix and a Create an approval. Adding Attachment array seems to work under a normal create an approval, but when doing custom utilizing an approval matrix I can't seem to get the attachment to add.

@RezaDorrani Год назад

Not sure as I have not tried this. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com

@yeetusfeetus8151 Год назад

Hi Reza, great video. Do you have a video for permissions with attachments?

@RezaDorrani Год назад

I do not have a video reference on this scenario. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

@santi-mr5zw 3 года назад

Thanks Reza Followed your step by step tutorial, however I'm getting an error under " start and wait approval" as follow: The request failed. Error code: 'InvalidRequestContent'. Error Message: 'The request content was invalid and could not be deserialized: 'Unexpected character encountered while parsing value: {. Path 'attachments[0].content', line 1, position 852.'.'. per checking, the varAttachments is causing this error, I would appreciate your feedback for any work around. Thank you

@RezaDorrani 3 года назад

I will have to look at your flow in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

@kabax5 2 года назад

I got the same issue. Were you able to find a solution?

@oluwatobiyusuf 3 года назад

Great video Reza. Thanks for the insight. I have a question, what if we have multiple fields with attach documents on the Microsoft Forms. How do initialize and append variables for the individual fields on the Forms?

@RezaDorrani 3 года назад

You can create variables for each field and then combine them (if required) using expressions.

@oluwatobiyusuf 3 года назад

@@RezaDorrani thank you so much

@tproto223 2 года назад

@@RezaDorrani Hi Reza, thank you for the video. In this scenario where there are multiple fields with attached documents, which expression should be used to combine them in order to attach all documents to the approval email? Thank you

@RezaDorrani 2 года назад

@@tproto223 It is not only expressions. Multiple actions and expressions would be needed to get it to work. I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

@IndianmominSweden 6 месяцев назад

Hey, 1st of all thanks for this video. I am using power automate for the 1st time in my career and really need your help. I have set up approval flow which is working perfectly fine, but when approvers try to open the file, they can't see the content. I have implemented the 1st of your scenario. When it is Excel file, the error comes file is corrupt, and when it is PDF, it just open but blank pdf. We mainly have to deal with PDFs and they contain drawings.. Looking forward for your help.

@RezaDorrani 6 месяцев назад

Welcome! I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

@IndianmominSweden 6 месяцев назад

@@RezaDorrani thanks for your reply, I will try that

@relaxingmusicsoundcorner9127 2 года назад

Can you help me, I have a question, what if the approver open the attachment and then edit the file such as insert a note or a picture into the file, and when a create flow send a email notifications and setting the attachment field as a file content it didn't show up in the recipient email, how to make the updated file show up in the notification email?

@RezaDorrani 2 года назад

The attachment being mailed out is a copy. Update is not currently a feature.

@koynabettawar1211 3 года назад

Sir, I have used tabbed forms, learnt from your video tabbed forms video. In that I want to disable and enable buttons based on check boxes. If check box is checked then button should be enable. Otherwise it should be disable. And the buttons are in the gallery, so what should I do sir? Please clear my doubt.

@RezaDorrani 3 года назад

I would have to recreate your scenario to provide any guidance. Idea would be to set the formula on the display mode property of the button. Here you will set the mode based on the checkbox value. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

@jmrendel98 2 года назад

Very helpful! I have been struggling, though, with what if the form results (and corresponding attachment) reside in sharepoint, not onedrive? Thank you!

@RezaDorrani 2 года назад

I have done videos on those too. Check the Power Automate playlist on my channel.

@danielrumbak2530 2 года назад

Hi Reza, Nothing short of brilliant. I noticed the keys for the approval action in the JSON was {"name": _________, "content": ______} whereas for an email action it's {"Name": _________, "ContentBytes": ______}. Will one work in the other or only for their respective actions (Approval vs Email)?

@RezaDorrani 2 года назад

Yes, it differs based on the connector type.

@PsYc87 9 месяцев назад

Hi Reza, another great video. Is it possible to upload an attachment to a sent approval? Eg. An approver needs to upload an additional attachment in to their Teams approval, which then gets added to the SharePoint list.

@RezaDorrani 9 месяцев назад

Approval forms does not allow for attachments to be uploaded.

@calvinmunisi346 3 года назад

Hi Reza, this is a great video as always. Is there a way to make the sharepoint list readonly when the approver needs to approve/reject so as to avoid making changes to the list item?

@RezaDorrani 3 года назад

You would need to set permissions on the list item as the item moves through the approval process.

@calvinmunisi346 3 года назад

@@RezaDorrani thank you..

@CS-dm8fu Год назад

Hi Reza, thanks so much for your content. @27:40 in the video you mention that the attachments cannot have special characters, but could be fixed using Expressions and Flow. Just wondering if you have a video on how this can be done? have a flow that copies attachments to a document library, but ones with special characters do not display. I’m hoping to find a solution to sanitize the attachment file names. Thanks for any direction/video that you can provide.

@RezaDorrani Год назад

you would need to use replace function to replace all those special characters example: replace(replace(filename,'*',''),'|','') I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

@HinaGeo 2 года назад

Hello Reza, Thanks for the videos helping people around the world. I always first come to your channel to get help :). I need your expert guidance/opinion, please. if an approver edits the attachment (In case of a list item with an attached file) or document (A library uploaded file) before approving or rejecting will save the edited file so that the updated/edited file now should be visible to all users? I mean if an approver edits the attachment or file it should be overwritten the actual attachment or file. Shall be very thankful if you please guide on it. Thanks

@RezaDorrani 2 года назад

The attachments being sent for approvals action cannot be edited. It is more like a copy. Approver would need to download it, edit it and the upload it back to data source (list or library).

@user-sr4od8xd1f 10 месяцев назад

Hi Reza, Greats videos! I need to insert a checkbox in the approval email such that the approver, reads and understands the text/string and clicks on the checkbox before they click on the Approve button. Is this something that can be accomplished?

@RezaDorrani 10 месяцев назад

The approval email form cannot be customized.

@user-jw9sj8ku5d 2 месяца назад

Reza, thank you for another great video. Question about this process. If the approver adds comments to a word document, do the comments get retained throughout the approval process across all approvers?

@RezaDorrani 2 месяца назад

Word doc is independent of the process. The doc is shared as an attachment so any updates made there wont reflect. Best for user to make changes to original document (wherever it is stored)

@shereenraza779 Год назад

Really informative videos Reza. I am trying to get data populated on my share point through MS forms (having attachments) and I am trying to get approvals where the approver gets the link to those attachments. The error that I get is Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'WebhookApprovalCreationInput' validation failed in workflow operation 'Start_and_wait_for_an_approval': The parameter with value '"@{variables('varAttachments')} "' in path 'WebhookApprovalCreationInput/attachments' with type/format 'String' is not convertible to type/format 'Array'.' and I don't really understand why

@RezaDorrani Год назад

I have not come across this issue hence not sure. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

@lionking.MuZimba 9 месяцев назад

Thanks for this walk through Reza, and for all your other awesome content. It makes our lives much much easier. Do you have any thoughts on why my use case of trying to extract attachments from a list item results in corrupt files that will not open? I've followed the section in your tutorial for this, but still get corrupt files in my approval email. Your thoughts will be much appreciated Reza, thank you.

@RezaDorrani 9 месяцев назад

You are most welcome! I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

@lionking.MuZimba 9 месяцев назад

@@RezaDorrani sure thing, i'll post an issue in the forum

@stevenls9781 3 года назад

Great video, but I am getting a base64encoded error when I use a docx file. I am using the file is created or modified trigger which works fine until I use the attachment options. I have the get file properties, get file content, all the same steps, but the base64encoded error at the 'start and wait' step at the Attachment Content spot. Do you have any thoughts on that?

@RezaDorrani 3 года назад

I did not run into that specific issue. I will have to look at your flow in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

@ammarwasif5337 2 года назад

Hi Reza, Thanks for these helpful videos. How can we have the audit log of these approvals for internal/external auditors. Further, if you could consider making a video on a scenario where initiator places a file on preapproval folder document library, approver receives the email, once approver approves the document, the files in preapproval folder are moved to another approved folder.

@RezaDorrani 2 года назад

Track approval history - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lYE7NXTDPJY.html I will add your approval scenario request to my backlog.

@ammarwasif5337 2 года назад

@@RezaDorrani Thank you so much boss.

@orleevelarde9997 2 года назад

Thanks for the step by step tutorial. How about if I need to exclude specific types of attachment like zip or pdf?

@RezaDorrani 2 года назад

You could use the Filter data operation to remove specific file types from the attachments array.

@shannonp3mo169 Год назад

Hi Reza, excellent video once a gain. I have a question. I can get the flow working correctly, but the attachments only come through with the email notification and in the Power Automate Approvals area. The MS Teams approval is not showing the attachments. We either need to have the attachments coming through in MS Teams as well, or we need to be able to turn off the approval requests going to Power Automate and MS Teams, and only have them going to email. Thanks in advance for your help!

@RezaDorrani Год назад

I believe that is a current limitation.

@shannonp3mo169 Год назад

@@RezaDorrani Hi, is there a way to stop notifications going to MS Teams or Power Automate, and only have them going by email?

@RezaDorrani Год назад

@@shannonp3mo169 Im not aware of an option

@shozrocks6307 2 года назад

Hello Reza, I followed all of your steps closely to send an approval when an item is created with an attachment. My test flow seems to get stuck. I stops at the Start and wait for an approval. There is an orange timer showing but it never seems to go anywhere. Its like the Connection: Approvals doesnt work. I've tried a few of your video's and this problem seem to happen to all of them. Any advice? thanks alot.

@RezaDorrani 2 года назад

I will have to look at your flow in action to provide guidance. My guess is something to do with your environment. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

@prielbuzny1812 Год назад

Hello, this video was very helpful, but I think I confused myself. Everything seemed to be going well, but when you selected the onedrive to grab the attachments I got a bit lost because I had watched one of your other videos on automated email messages with form responses and in that video you pulled from the sharepoint file location. I wasn't using onedrive to automate the approval, so I tried to pull from the sharepoint file path, but that didn't work. Is it possible to do Flow Approval with Attachments using a sharepoint file path?

@RezaDorrani Год назад

At what time in video I show the OneDrive action?

@prielbuzny1812 Год назад

@@RezaDorrani oh wow fast response, thanks. It was 18:41.

@RM-cn4fm Год назад

Thanks for another great tutorial Reza. I have used this to design an Approval flow with files attached. It works great but for a small error. As my flow calls for emailing the original file back to responder who submitted the form I'm getting the below error at that stage : The API operation 'SendEmailV2' is missing required property 'emailMessage/Attachments/0/ContentBytes'.

@RezaDorrani Год назад

I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@katymccormic6330 Год назад

I changed the JSON from "content": to "contentBytes": and it corrected this error.

@dreambymana4981 3 года назад

Hello Reeza,please let me know if we can filter a value from Excel online based on time stamp. Basically I want to filter response which was submitted today after 9AM,not before that

@RezaDorrani 3 года назад

I believe it is possible but I would have to try that out. I will recommend you check on the forums at powerusers.microsoft.com/

@tiagoarauko3857 2 года назад

Great Video! I have one question, how can I do it in case get the attachments of different questions from forms and send to approval, please? Thanks

@RezaDorrani 2 года назад

I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@tiagoarauko3857 2 года назад

@@RezaDorrani Thanks a lot!

@monashah4892 2 года назад

Hi Reza, this video is great, it is exactly what I needed for the workflow I am working on. However, I did encounter a tiny issue (referring specifically to the 3rd scenario explained in this video - about attaching attachments to the approval email). In the event where attachments are uploaded, the flow works beautifully. If no attachments are uploaded in the MS Form then the flow fails. Do you have a fix for this? The flow I am working on is: It starts with MS form is submitted with or without attachments, sent to the approver (with attachments where applicable) if approved the information and is saved in the group SharePoint list and if the form is declined, it is not saved anywhere.

@RezaDorrani 2 года назад

You can use the length expression to check if length of attachments array is more than 0.

@nohpetsrs 2 года назад

@@RezaDorrani can you expand on this a bit more - I have similar issues when the user does not attach anything which in this use case attachments are optional

@RezaDorrani 2 года назад

@@nohpetsrs Length is an expression in flow. Difficult to showcase steps here in chat. Check flow expressions video - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-O97IdCbfMQI.html

@tristynhuet-heart4056 10 месяцев назад

I'm having a similar issue but the flow is failing when an attachment is included.

@tornadomanhuman 2 года назад

Hi Reza, I got another problem about size of the attachments, if someone upload files over 5mb( most likely upload photos of receipts), the form allow 10mb, however the approval flow only accept 5mb in total, if over 5mb, the flow will fail in the approval step. do you have any suggestion? thank you so much!

@RezaDorrani 2 года назад

Thats a limitation of the approval flow. Not sure if there is a way to warn user if file is above 5mb. I think I did see something on this on the forums. Check the forums at powerusers.microsoft.com/

@adaguilarh 2 года назад

Hi Is there a way to make the Array Solution of multiple Atachment but from the Get File Content function from the Document Library? I use first Get File Properties, then Apply to Each Get File Content and populated the Array. The document is on the array but withe the file extention.

@RezaDorrani 2 года назад

I'm sure there is a way, but I would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@jagjitsingh8119 2 месяца назад

Hi Reza, Hope you're doing well. I really want to appreciate your efforts and creativity. I recommended to my friends. I am having trouble creating a flow, below mentioned are the details: 1. A form is submitted with or without attachment (as the attachement is not mandatory field) 2. Capture the info in MS list, also the attachment (if any) 3. Send for approval & attach the attachment (if any) 4. Send the approval response to requester & other departments or staff members 5. Update the status of the approval response in MS list. The problem that I'm facing if there is no attachment the flow gets confused on step 3 and gives me error. I tried to apply the condition but it didn't help. I really appreciate your support.

@RezaDorrani 2 месяца назад

This is the best reference video I have ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Aerky9hiYDo.htmlsi=6NFOMGCu7GyzMclZ Beyond the above, I will recommend posting your query on forums in case someone has done something similar powerusers.microsoft.com

@jagjitsingh8119 2 месяца назад

Hi Reza, You're Saviour!! 🙏 Thank you so much for sharing another video link, it answers all my doubts. I request you to keep on creating such useful content. I would keep on liking and sharing with my friends. Thanks once again 🙂

@annaadezati8400 2 года назад

Hi Reza, very useful, would it be possible to describe how to send an email to another email once validation is performed with the attachments ?

@RezaDorrani 2 года назад

Send an email to another email?

@smolahloe 3 года назад

Thank you Reza, how do I enable Actionable Email in my tenant? It used to be enabled and something changed - Chang was effected by Microsoft

@RezaDorrani 3 года назад

I would recommend to create a support ticket with Microsoft in that case.

@analuciamartinez2939 2 года назад

Hi, Reza, thank you for the video. I'm trying to attach a file that is uploded through a microsoft form, so i followed all your steps. However when y test my flow i get the following error in the approval: The request failed. Error code: 'InvalidRequestContent'. Error Message: 'The request content was invalid and could not be deserialized: 'Error converting value "name" and "content". Do you have any ideas on how to fix this?

@RezaDorrani 2 года назад

MS Forms files are a different ball game. I have a video coming on them next week.

@infy25 2 года назад

Hi Reza, I have a scenario where the file has to be attached from one drive or SharePoint document library if invoice number matches with the file name without extension. Invoice number is one of the column in my SharePoint list. Pls help

@RezaDorrani 2 года назад

I will have to recreate your scenario and/or look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@toddring9111 24 дня назад

Rezza, this video is great. I have a question. I have a form that may or may not contain a file attachment. I can determine if there is an attachment. How can I add the file to the Approval if there is an attachment and leave it blank if there is no attachment? Thank you for a response.

@RezaDorrani 24 дня назад

Easiest option would be to add an if condition in flow to check if attachment exists.

@cy1606 Год назад

Hi sir , may i know i follow ur step in the outlook email attachments, why when i run it , it send like 2 email for approve, but not included in one email as in the video u done

@RezaDorrani Год назад

I have not come across that issue hence I don’t know what is the fix or the reason for it. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

@yandisafanqa6050 Год назад

Hi Reza thank you once again. I was looking for MS form file upload and this video helped. Is there another shorter way to create Ms forms file ulpoad approval flow you can show us? Thanks.

@RezaDorrani Год назад

I am not aware of any other shorter way / I would have to try it out to know more. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

@yandisafanqa6050 Год назад

@@RezaDorrani Thank you for the feedback

@rhumeetsinus 2 года назад

is it possible to edit the attachment by clicking on it in the approval email directly, press approve & then save the edited document on sharepoint? thanks

@RezaDorrani 2 года назад

I don’t think that is possible.

@rudiolivier7494 2 года назад

Reza this solution works fine when the form is Personal but when you move it to a Group this does not work. it cannot find the file then. What must I do differently?

@RezaDorrani 2 года назад

Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kbqXsKPTmZk.html

@sonial.8345 2 года назад

Thanks for your video, really helpful! For the sharepoint list attachment, I did exactly the same configuration, but got error message saying "bad request. The request failed. Error code "attachmentcontentnotvalidbase64string" could you please advise what's the reason?

@RezaDorrani 2 года назад

I will have to look at your flow in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

@ResponsibleXI 3 года назад

Does the json structure vary when we try to send attachments from list item to outlook? Is your json structure was consistent because your use cases were covering only approval attachments at the receiving end? Below json works when I send list attachments to outlook. { "Name": @{items('Apply_to_each')?['DisplayName']}, "ContentBytes": @{body('Get_attachment_content')?['body']} }

@RezaDorrani 3 года назад

Yes it will vary. This video only showcases how to attach documents to the approvals action.

@azharshaik21 2 года назад

Hi Reza, can we also change the approval incase if the approver leave the company/on vacation ?

@RezaDorrani 2 года назад

You can always check if user is active or on vacation prior to assigning the approval task. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-r8jk5xigpQg.html

@Atilotto 2 года назад

Hello Reza, I have a question regarding power approval attachment. Is there any possibility to open file from an email which power flow sent, then edit it (for example add signature) and then clicking approve button to send approval notification to requester with edited file? Thank you in advance. BR

@RezaDorrani 2 года назад

Email attachment via flow are only for that email itself. It will not edit file in data source.

@nadilasetiabudiarto3988 2 года назад

Hi Reza, thank you for the video, is it possible to customize the approvals for different items in one email? sample, if we submit 3 items and attachments in ms. form then we send the items in 1 email and we can approve the item from 3 items based on our preference. Thank You

@RezaDorrani 2 года назад

Approvals action is meant for a single entity. You would need to fire multiple approval actions (emails).