This is an exceptional tutorial and much appreciated! Excited to implement for our PO process! I am amazed at how generous some people can be with sharing their knowledge!
This video was brilliant. Thank you very much for demonstrating the functions of the document library as well as linking it with a Flow. Well done mate 👍
I'm new to Sharepoint and all the Power Platform tools. This is not your first video I watch and I have to say that they are very well explained and useful for a beginner. Thanks!
Really great video, Reza! I'm now committed fully to the power platform with my job at Quisitive and have started the certification process. I miss you more here all the time!
simple and neat combo of content approval with flow approval action. Thanks for sharing and appreciate including trigger condition to save flow API call !
@@MrDecarte 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
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Excellent thorough explanation Reza. Thanks for taking the time to share your process. The only thing I would recommend is to check into the quality of the images. They are quite blurry and a bit hard to read. Thx
Awesome video Reza thank you ! Works fine on my side but the time stamp in the response summary is wrong, it is 4 hours ahead. What would you recommend to fix this ? I assume it is because i'm in Eastern Canadian Timezone. Is there an easy fix for this ?
Hello Reza, Great video, very helpful. Exactly what I was looking for. Thank you! but I have one question - How to identify who approved a SharePoint document?
Most welcome! Flow action of approval has details of who approved the document. You can use that to store the information. I have done several approval videos showcasing that. Check my approval playlist.
Really enjoy all your tutorials. Question related to this example. Is there a way I can call/invoke the "Submit for approval" from Power Apps? As is, I have to manually select a document and then select "Submit for approval" before the flow execute. Thank you :)
Thanks! I dont think there is a direct option to do so from Power Apps. You would need to create a flow that triggers from Power Apps and then implement similar pattern for flow.
@@RezaDorrani One question I got just now is how to modify the process so it would also deal with folders? It's just now, if I copy folder with files I'm able to submit files for an approval, but not the folder. As a result, files change status to Approved and folder shows as Pending.
@@olegguriev892 I have not done much work with folders. I will recommend checking on the forums powerusers.microsoft.com/ in case someone has done something similar.
AAWW Reza, JAK for continuing to share your wealth of knowledge. I know you refer to Dynamic approvers, hence my use case scenario is, I may have up to 10 approvers, thus what are the options to design an approval WF and assign it all 10 [either serial or parallel] using the most efficient method. Back in the day, SP had an out of the Box WK where document owners were able assign all approves and email the approval task to assignees, is there anything similar using the Power Automate? Appreciate your guidance.
Thanks! There are options but not as straightforward as old school SP workflows. I will recommend checking my playlist on approvals (covers various scenarios)
Great tutorial! Thank you. I love it. Quick question, particularly related different statuses. After it is uploaded and in draft and then selected for Submit for Approval and goes into Pending. Is there a way I can have it say "In Review" if it is in the approval process? Or would i just replace the "Pending" to "In-Review"?
Most welcome! Oh its been a while that I have done this. Do not remember the video :) Approval Status is an inbuilt column. You can always add another column and show different statuses there.
Hi Reza...this is superb...thanks..is it possible to have digital signature over a document itself as and when the workflow is approved by any individual...?
Possible but I believe that will require premium connectors. You could generate HTML and generate a PDF file with signature embedded. Check this video ua-cam.com/video/EACk5jlQ_jU/v-deo.html
Thanks Reza! We learn so much from you always!! Could you please explain how to notify users that a certain document is reaching its expiry and automatically unpublish the document or page using power automate
As always, this is a great video Reza around the document approval. Why is that Etag required in the flow? Without which the document status will not set to be approved?
Most welcome! Once approval process begins, only the approver can pick a different person. I have done many videos on approvals (all in a playlist on my channel) - where I have shown scenarios like approval timeouts, reminders, check if approver is out of office etc.
Thank you Reza for sharing. This is an excellent tutorial! One question: Is there a way to request the user to input the approver after the 'submit' button is pressed?
Another great video, Reza. A lot of interest in this topic as indicated by the number of comments! Just a question. Will the last Major version of a file be shown to a user with view permissions or will it not be visible at all if in draft (minor version)?
Great Tuto Reza. Now that you have an automated way to trigger your approval process. Do you know how I could remove the 'submit for approval' control in your top bar?
Hi Reza, great job on your videos...thank you! I do have a follow-up question, if I may: I'm building a document approval triggered by uploading a document to a specific SharePoint folder. I'd like to prompt the uploader, at inception, for three users; they represent the second and third recipients of the approval workflow and the third just receives an email with a copy of the document that was uploaded.
You can use the for a selected file trigger-based flow. In trigger action you can add input for 3-person selection. Something like ua-cam.com/video/2Hp9CTd8zQU/v-deo.html
Also can we stop Contributors from editing metadata or reupload approved files?...to stop them editing approved data, I created flow to 1st remove all access to approved files and then provide fresh read only access to those files. Is it correct method ?
Fantastic and what a coincidence, Gareth and myself were working this exact same situation this today, what our trigger method was to use a For Selected File and use a formatted column using JSON to act as the button to trigger our approval flow. :). For a Select File, it allows you to present a message box for the Requester and likewise can allow you to respond to the Requester who triggered the approval request (bit like last modified by). What we learnt was to just take advantage of the built-in capability for Content Approval in a document library/list.
@@RezaDorrani Great Video. What can be done if multiple users need to see the file which is in draft state before it is sent for approval? Can we implement the same workflow then?
@@gauravk1987 Draft status can only be viewed by user who uploaded file and site collection admins. I don’t think this concept will work for multiple users.
@@RezaDorrani Thanks Reza I actually changed the draft security to everyone and seems like your work flow still works with it. Thank you. Is there any way to declare an item as record that could be added as a step in the end of this flow so that the document will get locked after its approved? I looked at Plumsail SP but couldn't figure it out. Any info would be appreciated.
@@gauravk1987 Ideally draft security should only be visible to the user who created the item :) I believe there are APIs to declare item as a record in flow. You should use the new Labelling concept to set item as record. Check Joanne Klein's blog.
This video is fantastic! Does this follow a similar flow process if you're using a MS Teams library? Do you have a video on integrating that? Thank you again!
EXCELLENT video! One question, is there a way to add a step for digital signature to get the order approved? I mean the approver sign the doc, then got approved. Thanks!
Dear Reza, thank you for your clear video. Do you know how to make the approval/rejection comments show up in the versioning history of a file? This would be really helpful. Kind regards, George
Thanks Reza, very clear instructions. I have two questions, 1. when the approver is viewing the document, is there a way to see what changes have been made? 2. what happens if you have multiple people modifying the document and submitting their changes for approval. Is there any lockout on a document that is in draft state by someone else to prevent issues with multiple people editing the document?
1 - Approver can check the version history of the document in SharePoint. That will provide all the details. 2 - You have the option to check out a document as well. That prevents other users from making changes until checked in. Both of the above are SharePoint features.
@Reza you are the best, I learn a lot with your videos. I am facing a demand: Client wants approve in batch and it would be the best approach (current I set buttons for each row to either accept or reject), however, the problem I notice is: #1 We are limited to accept this 3 status only (Approved; Rejected; Pending); #2 After 'Approved' or 'Rejected', the command for it is still available, so the approver can modify their response at any time, and it has an issue, because sometimes people wait for some approval so they can maintain a data, for example, and in this case would not be useful. Having said that, do you recommend anything in order to avoid these issues above ?
#1 Approved, Rejected is related to the SharePoint "Approval Status column". In flow approval action, you can use custom approvals and add your own buttons. #2 Depends on the approval flow pattern you define. I will have to get a complete picture of your entire scenario to provide any guidance. I have an approval flows playlist which includes many use cases. It might help - 7_jq_Aipe
This is awesome Reza! I've spent hours plodding around other training and couldn't get it 😂 I have a question tho.... Is it possible to stamp sharepoint documents with meta data from sharepoint? For ISO9001 compliance. I would appreciate your help
Thanks. Stamp docs with metadata I am not sure about it. I will recommend checking on forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
@@RezaDorrani Hi Reza! Just a quick question, do you know how can I automate the step of when the file/item has been approved, it should be moved to another navigation bar in sharepoint? i.e. New Submission Navigation > Approved > Submission Queue Navigation Thanks!
@@verleengonzales4562 Nav bar would be either a folder or another library related. There are ways to move files but I have not done videos on those. I will recommend checking on forums at powerusers.microsoft.com in case someone has done something similar
Thank you Reza for this tutorial i really appreciate it. I would like to ask why the time in your computer did not match in the time of the response that the requestor received. Thank you again.
@@RezaDorrani If you can see the date & time that you received the email is Saturday May 8, 2021 2:14PM. But in the body of the email it show that request date is Saturday May 8, 2021 9:12PM and response date is Saturday May 8, 2021 9:14PM.
This was so helpful. If the manager requires corrections on the document before approving, can those comments be made directly onto the document so that when the request is rejected, the employee can go into the document to see the comments the manager made within the actual document?
Thank you Reza. Your videos have really helped me in my 365 journey. Quick question, after a document has been approved, is there a way to lock down the document so no amendments can be made?
You would need to break item permissions and set it to view only after document is approved. Or you could just move the file to a different library using flow (library that has permission set to read only for users).
Excellent Video Reza, thanks for uploading. I have a couple of issues with my workflow that I hope you can help me with. The 'Submit for approval' button is missing in my document library. Also the approval workflow triggers as soon as I upload a 'draft' document or update the metadata, although I have added the trigger condition: '@equals(triggerOutputs()?['body/{ModerationStatus}'], 'Pending')' as explained in the video to trigger when the approval status is 'pending'.
I will have to look at your flow & library setup in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks for your quick response, Reza. I replicated the flow you created in the above video in Power Automate with no issues. The issues I have are in SharePoint. I will post the screenshots in SharePoint on the forum.
@@RezaDorrani Hi Reza, the submit for approval button has reappeared. However, I seem to have an issue with the workflow in Power Automate. The approvers are getting notifications when the document is still in draft status although I have configured the approval to trigger only when the approval status is 'Pending'. Is this how the flow is supposed the work?
Great Video Reza showcasing Approval Workflows in Power Automate. I want to ask if there is a video for the Power App development, that would be great as the app looks really awesome.
There is no Power App in this video. It's all SharePoint & flow. You may be relating to my video on leave request application. I am working on a video on that as well.
@@RezaDorrani Yes I am sorry, I was about to delete the comment as I had commented on the wrong video. And yes I was referring to the Leave Request video which has a Power App for requestor and approver. Thanks for the update, eagerly waiting for that video.
@@RezaDorrani Yes I can see that in the comments sections of the video and this would be really awesome as I can present the idea to my customers of a single power app for request creation and approval. You are really great. Thanks for all these videos with in depth details.
Hi Reza, thank you for awesome video as always. May i ask what is your advice between using this method compare to SharePoint list? Which one has more advantages to apply? (Lets say for project approval and has 1 word file to attach too).
Thank you for sharing Reza this is a fantastic video demonstration. I have been using the exact set-up for content approvals for a while now and it has been flawless. However, 24 hours ago the Submit for approval button that appears when selecting a draft item no longer appears. The only way I can move the document from draft to pending is by right-clicking on the item and going to More then Publish. Have you ever seen this before? Any idea how this could happen or beter still do you know how I can fix it. Any knowledge you have would be greatly appreciated.
Draft is only accessible to current user. The owner of the flow will not be able to access draft items of other users. Not sure if this is something related to a change that was done recently (but never know, may be a change with SharePoint). I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has run into something similar.
I have the same exact question. My Submit for approval button disappeared from the libraries. I lost a tons of time, trying to figure out if it was some setting I messed up. Guess Microsoft changed stuff for the worst again...
About 3 hours ago my submit for approval button returned. The only thing I did between it being missing and returning was go to manage my flows open it and hit turn off. I have since turned it back on and it is still there. I have no idea if it was my actions that caused the submit for approval button to return or just coincidence but it's worth a shot. Let me know how you go.
@@travishill4613 I still don't have the button. Tried to turn off and turn on. My flow is a bit different from Reza's one, but the trigger is the same (with the same trigger condition and all). Either way, I thought this button was SPO library Approval setting bounded and not flow related.
Great video thanks Reza, just a few questions: 1. After approval status has been completed, what prevents anyone from editing an item and upload/remove attachment on an item? Can only owners edit/delete items? 2. From audit compliance perspective, any additional settings needed for compliancy?
1 - If requirement is not prevent further updates, then you could either set item level permissions (make item read only) or move it to a different list (read only data) 2 - You can track entire approval process via flow + versioning of item will provide full details.
@@RezaDorrani How can you make the item with attachment read only once the content approval has been set to approved? How do you set the workflow to go through 2 additional set of approvals without modifying the document?
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
Great tutorial, thanks Reza! So thats a really nice out of the box feature, but how would you update metadata (e.g. approval date) AFTER it's approved? Cause then the status goes back to "Draft", is there a way to solve this?
When an update is made it does go back to Draft. However, the users (who have read access) will see the last published version until the new draft version is Approved. That is the default behavior of the Content Approval feature.
Anyone finding this guy's videos is really lucky. Thank you so much for the nice demonstration. Do you have any connection with Bahalpur city in Pakistan?
Great tutorial Reza, thanks. I can't get the comments out to the email and SharePoint library. I get the response summary only. But when i watch your video, the comments you enter at 25:43 don't appear in the email at 26:45 or your SharePoint at 27:17, so maybe you could look at this again?
The comments don't appear in email because I did not add the comments to my send email action. Check 23:00 onwards I did mention in video that I missed showing the part to add comments. If you want to learn more about adding approval comments then check my full playlist on approvals (it contains various scenarios where I used it) - ua-cam.com/play/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe.html
one of the best videos on approval flow. I have 1 Q. Suppose I do not activate content approval via versioning setting instead add a col for "Approval Status" with choices of Pending, Approved and Rejected. Default selection is Pending. If the file is approved, the Approval status col should change to "Approved", if rejected, it should change to "Rejected". What condition do I need to follow to ensure the flow works. If you have any video which caters this point with reference to a document library, pls. share the link. Thank you in advance!
Thank You. I may not have an exact use case match video, but I do have a full series of videos on approvals that would help. Check ua-cam.com/play/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe.html
Hi Reza, great video!! I have a question regarding editing a document DURING (not before) the approval flow. In our scenario, a user submits a document for approval. The approver needs to be able to review the document from the email and make changes to the document where needed before the request will be approved. Once the changes are made, the approver will approve the request from within the email. As changes to the document are made during the approval flow, the “Approval Status” of the document is set from “Pending” to “Draft” and not “Approved” Is there a workaround to enable approves to make changes in documents and approve the submitted request? Many thanks in advance 👍
Hello Reza, an excellent video tutorial like all the others you have. How can I define my approvers based on a sharepoint list?. I know you have another video where you define your approvers based on a sharepoint list, but I would like to know how I can merge that with this video tutorial, because that's what I really need.
Thank You. I have done multiple videos on those. Check ua-cam.com/play/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe.html You would have to mix the logic in both the videos.
Excellent work Reza. Can you please elaborate if instead of sending each invoice separately what if we need to make a recurring flow (say weekly) that gets all items in "Pending" status and send one email to Approvers with data in tabular format in email body. How this can be done alongwith Approve / Reject updates? Would appreciate if you can make a video on this pls....
Approvals work on single items. You could run flow on recurrence and send 1 approval action, but response will be for all together. I do not have any reference videos on your scenario though. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com
@@capstonepm111 I only make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community tab of my channel. Most voted ideas get added to my backlog. Make sure to post this idea there once the next topic suggestion post comes.
Hi Reza. Thank you for this video. I am currently using a basic approval workflow (start approval + wait for approval) for our organisational document control. Basically issuing documents to users to confirm they have read and understood internall process documents. My organisational requirement is to be able to log each approvers response as they come in. At the moment i am unable to track the responses until after 'wait until approval' function is completed. Is there anyway to track individual responses in real time? Ive created a seperate list for these responses but i cant seem to get it working. Thank you so much for your work Reza
To log each response whil approval is ongoing - you would need to query Approval tables in dataverse (premium feature). I did show one query to approvals in dataverse to find out which user(s) have not responded so they get reminder emails. ua-cam.com/video/ZupQ0AbDl0I/v-deo.html
HI Reza, Very Good Explanation, when a file deleted from sharepoint, document owner notify approve or reject using power automate. Please make a demo for this
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hello Reza thank you! excellent tutorial. My flow works perfectly but my trigger/flow keeps running after it has been approved. How can I set the Power Automate flow to run only once after Sharepoint column has a value? Please assist, thank you.
You can run flow for a selected item from sharepoint. Check my approvals playlist. I have done some videos on them. Approvals playlist ua-cam.com/play/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe.html
Thank you so much this was so helpful. Do you know if an email notification can be sent to a different person depending on the payee account? I created a column to show the account it should be paid from (Payee Account) as we have multiple accounts/locations, each location has a different approver?
I do not have a video reference on file deletion 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.
@@RezaDorrani I went through your recommended link but no luck if you get chance please create it will be very thankful. Much appreciate for your excellent work Man keep it up.
@@asadmughal6431 You can post your question on the forum. I make videos on topics when I receive many requests on it. This is the first request on this topic. Chances of video being made on this are very low.
Hi Again Reza. Thank you for all your videos, Ive watched so many haha. I have another question. I currently have my doc library with subfolders to house SOPs for each department at my company. Is it possible to have the approval request go to different people based on the folder(department)? Meaning it goes to specific people based on which subfolder the document is located in. Also, Is it possible for approvers to not have access to edit the documents? Thanks again for all your help.
You could create a mapping list to define who the approvers are for each folder. folder name approvers. Similar to what I showcase in this video - ua-cam.com/video/R18_qYVPWl4/v-deo.html Your reviewers can have read only access on folders. You can set the security at folder level.
@@RezaDorrani Hello Reza! This is very useful. However, I'm running into a failed status because it can't find the Approver. My approver is coming from file properties where Approver is indicated. How should I use this instead of hardcoding it?
@@ming-nomadictrotter You can get the approver email from that property and associate it with the approver property. I will also recommend posting your query with screenshots on the forums at powerusers.microsoft.com
Thanks for step by step guide and sharing, this is very useful for beginner. However would like to check how can we auto populate "approver name" under "Approver Name Column". I believe "Approver Name Column" was hidden in All Document view in your video above. Thanks in advance!
Paused the video for a quick to say Thanks. Ok, back to watching.
😊 thank you
This is an exceptional tutorial and much appreciated! Excited to implement for our PO process! I am amazed at how generous some people can be with sharing their knowledge!
You are most welcome! Welcome to the most generous channel 😊
This video was brilliant. Thank you very much for demonstrating the functions of the document library as well as linking it with a Flow. Well done mate 👍
You're very welcome!
I'm new to Sharepoint and all the Power Platform tools. This is not your first video I watch and I have to say that they are very well explained and useful for a beginner. Thanks!
Glad to hear that! Thanks for watching and liking the videos.
Excellent! You helped me with a customer. Great explanation and very clear every step (something that is not usual on UA-cam). Thanks!
Glad to hear that! Thank You for the feedback and thanks watching the video.
You are an excellent instructor. Concise and complete. Thank you for these videos.
Glad you like them!
Really great video, Reza! I'm now committed fully to the power platform with my job at Quisitive and have started the certification process. I miss you more here all the time!
Awesome! Excited to know you are working fully on the power platform. I miss you’ll as well.
Thank You for this. This was just the level I needed to make the transition from SPD to Flow for approvals.
Glad to hear that
Thank you, sir!
After watching your videos, I am trained in MS PowerApp, MS Sharepoint. Thanks a lot sir!
Your most welcome!
simple and neat combo of content approval with flow approval action. Thanks for sharing and appreciate including trigger condition to save flow API call !
Thanks for the great feedback.
This is the best video out there on this topic. You are so clear and articulate and easy to follow. Appreciate your work.
Wow, thank you!
Awesome Reza! Thanks a million for those great tutorials. I am a big fan -Thumbs up!!
Thank Anthony. Appreciate the support and thanks for watching and liking the videos.
@@MrDecarte 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
Seems no matter what I am looking for you have a video. Thank you for making this content and for making it available to everyone.
My content is driven from subscriber requests. I listen to signals. Most requested topics are my favorite signals :)
Clear video demonstrating the approval flow. very useful. Except I am getting a bad gateway error at set content approval status.
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
This is exactly what I needed!! Thanks Reza. Great video. So easy to follow along.
Great to hear!
Excellent thorough explanation Reza. Thanks for taking the time to share your process. The only thing I would recommend is to check into the quality of the images. They are quite blurry and a bit hard to read. Thx
Thanks Perry.
I would like to know which images are you relating to? Video is loaded in full HD.
Thank for your step by step guide which is very easy to follow and understand. Appreciate your efforts in contribution to others.
Glad it was helpful!
Excellent video Reza. 10 out of 10... well spoken and a very good demo!
Thank you!
excellent video, very help ful to show our users how the approval feature works in sharepoint!
Thanks
Awesome video Reza thank you ! Works fine on my side but the time stamp in the response summary is wrong, it is 4 hours ahead. What would you recommend to fix this ? I assume it is because i'm in Eastern Canadian Timezone. Is there an easy fix for this ?
Power Automate works with dates and times in UTC format. Check flow expressions that allow you to change the time zone.
Hello Reza, Great video, very helpful. Exactly what I was looking for. Thank you! but I have one question - How to identify who approved a SharePoint document?
Most welcome!
Flow action of approval has details of who approved the document. You can use that to store the information. I have done several approval videos showcasing that. Check my approval playlist.
Both Comprehensive and Clear as always. Thanks Rezza Dorrani, you've been a huge help
Thank you for the amazing feedback
Exceptional tutorial with excellent detailed guidance. JAK for continuing to share your wealth of knowledge.
Much appreciated!
Excellent tutorial. Thank you for taking the time to explain it so thoroughly.
You're very welcome!
Your videos are great. Realistic use cases and very clear explanations. Thanks a lot.
You are most welcome.
Really enjoy all your tutorials. Question related to this example. Is there a way I can call/invoke the "Submit for approval" from Power Apps? As is, I have to manually select a document and then select "Submit for approval" before the flow execute. Thank you :)
Thanks!
I dont think there is a direct option to do so from Power Apps.
You would need to create a flow that triggers from Power Apps and then implement similar pattern for flow.
Great tutorial. This was exactly what I was looking for! Thanks Reza!
Most welcome!
@@RezaDorrani One question I got just now is how to modify the process so it would also deal with folders? It's just now, if I copy folder with files I'm able to submit files for an approval, but not the folder. As a result, files change status to Approved and folder shows as Pending.
@@olegguriev892 I have not done much work with folders. I will recommend checking on the forums powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thanks Reza!
you are best of the best. a refresher after 3 years .:)
Glad to hear that
I tried and it is working beautifully :) Reza is amazing :)
Great to hear!
AAWW Reza, JAK for continuing to share your wealth of knowledge. I know you refer to Dynamic approvers, hence my use case scenario is, I may have up to 10 approvers, thus what are the options to design an approval WF and assign it all 10 [either serial or parallel] using the most efficient method. Back in the day, SP had an out of the Box WK where document owners were able assign all approves and email the approval task to assignees, is there anything similar using the Power Automate? Appreciate your guidance.
Thanks!
There are options but not as straightforward as old school SP workflows.
I will recommend checking my playlist on approvals (covers various scenarios)
Thank you so very much! This was very easy to follow and helpful!
You're very welcome!
thank you for this easy to follow and great tutoial!
You are most welcome
Thank you so much, your videos are awesome, contains every minute detail
Thanks so much for watching and liking the videos
Thank you Reza for sharing 'Approvals' in simple terms. Makes it easier to implement.
Glad it was helpful!
❤❤ Amazing tutorial
Will this still work if minor versioning is disabled in the library settings?
Most welcome!
Try turning off minor versions and check
Great tutorial! Thank you. I love it. Quick question, particularly related different statuses. After it is uploaded and in draft and then selected for Submit for Approval and goes into Pending. Is there a way I can have it say "In Review" if it is in the approval process? Or would i just replace the "Pending" to "In-Review"?
Most welcome!
Oh its been a while that I have done this. Do not remember the video :)
Approval Status is an inbuilt column. You can always add another column and show different statuses there.
A simple solution for a modified file approval ! This worked for me like a charm 🙌
Excellent!
Reza you are legend !
We cannot thank you enough for all of your great work.
Thank you for your kind words but I am no legend.
Great. Thanks Reza for the step-by-step guide.
My pleasure!
Great video, very helpful. Exactly what I was looking for. Thank you!
Great to hear!
Hi Reza...this is superb...thanks..is it possible to have digital signature over a document itself as and when the workflow is approved by any individual...?
Possible but I believe that will require premium connectors. You could generate HTML and generate a PDF file with signature embedded. Check this video ua-cam.com/video/EACk5jlQ_jU/v-deo.html
Thanks Reza! We learn so much from you always!! Could you please explain how to notify users that a certain document is reaching its expiry and automatically unpublish the document or page using power automate
Will add it to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.
@@RezaDorrani I need this too please :)
@@nicoleq146 Noted!
I have topics with over 20 requests that is in my backlog. I will need a lot more folks requesting this.
@@RezaDorrani I need this as well please 🙂
I'd also be interested in this topic
Awesome video Reza. Thanks so much for this - timely and apt. Can this be cascaded to multiple levels of approvals ?
Yes, absolutely. You can design any approval pattern of your choice.
As always, this is a great video Reza around the document approval. Why is that Etag required in the flow? Without which the document status will not set to be approved?
ETag is part of the file properties which are stored together with the file and is required for tracking content approvals in documents & pages.
Thank you so much for this tutorial. It's exceptional.
You’re most welcome
Thank You for this awesome video.
If the document approver on Annual Leave, can the requestor pick a different person to approve?
Most welcome!
Once approval process begins, only the approver can pick a different person.
I have done many videos on approvals (all in a playlist on my channel) - where I have shown scenarios like approval timeouts, reminders, check if approver is out of office etc.
@@RezaDorrani Thank you, I'll check them.
Thank you Reza for sharing. This is an excellent tutorial! One question: Is there a way to request the user to input the approver after the 'submit' button is pressed?
Look at for a selected item trigger in flow. Check approvals playlist on my channel. I have done 18 videos on approvals with various scenarios.
Another great video, Reza. A lot of interest in this topic as indicated by the number of comments!
Just a question. Will the last Major version of a file be shown to a user with view permissions or will it not be visible at all if in draft (minor version)?
Last Published Version only!
Great Tuto Reza.
Now that you have an automated way to trigger your approval process. Do you know how I could remove the 'submit for approval' control in your top bar?
I don't think we can hide that since it is a feature in SharePoint.
Hi Reza, great job on your videos...thank you! I do have a follow-up question, if I may: I'm building a document approval triggered by uploading a document to a specific SharePoint folder. I'd like to prompt the uploader, at inception, for three users; they represent the second and third recipients of the approval workflow and the third just receives an email with a copy of the document that was uploaded.
You can use the for a selected file trigger-based flow.
In trigger action you can add input for 3-person selection.
Something like ua-cam.com/video/2Hp9CTd8zQU/v-deo.html
Thanks Reza...Your expression tricks was super helpful...👍 Keep posting such wonderful videos...🙏
Also can we stop Contributors from editing metadata or reupload approved files?...to stop them editing approved data, I created flow to 1st remove all access to approved files and then provide fresh read only access to those files. Is it correct method ?
My pleasure 😊
That is correct. You would have to play with permissions.
Fantastic and what a coincidence, Gareth and myself were working this exact same situation this today, what our trigger method was to use a For Selected File and use a formatted column using JSON to act as the button to trigger our approval flow. :). For a Select File, it allows you to present a message box for the Requester and likewise can allow you to respond to the Requester who triggered the approval request (bit like last modified by).
What we learnt was to just take advantage of the built-in capability for Content Approval in a document library/list.
Great! Like minds think alike :)
@@RezaDorrani Great Video. What can be done if multiple users need to see the file which is in draft state before it is sent for approval? Can we implement the same workflow then?
@@gauravk1987 Draft status can only be viewed by user who uploaded file and site collection admins. I don’t think this concept will work for multiple users.
@@RezaDorrani Thanks Reza I actually changed the draft security to everyone and seems like your work flow still works with it. Thank you. Is there any way to declare an item as record that could be added as a step in the end of this flow so that the document will get locked after its approved? I looked at Plumsail SP but couldn't figure it out. Any info would be appreciated.
@@gauravk1987 Ideally draft security should only be visible to the user who created the item :)
I believe there are APIs to declare item as a record in flow. You should use the new Labelling concept to set item as record. Check Joanne Klein's blog.
This video is fantastic! Does this follow a similar flow process if you're using a MS Teams library? Do you have a video on integrating that? Thank you again!
MS Teams libraries are also SharePoint Libraries. Process should be the same. I do not have a specific video on that.
@@RezaDorrani Indeed, should have checked before coming straight to ask. I really appreciate the video again, very easy to follow!
@@oduwrestler 👍
This is awesome Reza but in my power automate, I couldn't locate the Trigger Conditions which you show at 15:12.
If you watch video from 15:00, I show how to get to it. It only works for the trigger action (first action in flow).
EXCELLENT video! One question, is there a way to add a step for digital signature to get the order approved? I mean the approver sign the doc, then got approved. Thanks!
You would need to integrate adobe sign into your flow to get digital signatures.
Yes Very good , This is a new concept about data security that we can do that not just a lock it as we do so far .
Thanks
Fantastic tutorial. Love your approach.
Thank you
Excellent. Thank you so much,Reza!
You’re most welcome
Great and informative content, Thank you for your time and effort.
I have small query, How Can i Add external 365 user into Approval loop?
I do not have a specific video on that.
Check powerusers.microsoft.com/t5/General-Power-Automate/Approval-with-external-users/td-p/327840
thank you Reza, beautifully explained.
What if I want the document to be sent to an external email (eg. supplier) once it's been approved?
You could use flow to send the file as an attachment to the external user by using the email connector.
Thanks for a great tutorial. Do you have video where approver does approval in sharepoint list instead of from outlook email ?
Most welcome!
I do not remember to be honest. Check my Playlist on approvals.
Reza this is great!, thank you your, videos are very helpful!
Thanks Chad
Dear Reza, thank you for your clear video. Do you know how to make the approval/rejection comments show up in the versioning history of a file? This would be really helpful. Kind regards, George
I have not tried that. One alternative would be to write those comments in a separate column so it shows in version history.
Thanks Reza, very clear instructions. I have two questions, 1. when the approver is viewing the document, is there a way to see what changes have been made? 2. what happens if you have multiple people modifying the document and submitting their changes for approval. Is there any lockout on a document that is in draft state by someone else to prevent issues with multiple people editing the document?
1 - Approver can check the version history of the document in SharePoint. That will provide all the details.
2 - You have the option to check out a document as well. That prevents other users from making changes until checked in.
Both of the above are SharePoint features.
@Reza you are the best, I learn a lot with your videos.
I am facing a demand: Client wants approve in batch and it would be the best approach (current I set buttons for each row to either accept or reject), however, the problem I notice is:
#1 We are limited to accept this 3 status only (Approved; Rejected; Pending);
#2 After 'Approved' or 'Rejected', the command for it is still available, so the approver can modify their response at any time, and it has an issue, because sometimes people wait for some approval so they can maintain a data, for example, and in this case would not be useful.
Having said that, do you recommend anything in order to avoid these issues above ?
#1 Approved, Rejected is related to the SharePoint "Approval Status column". In flow approval action, you can use custom approvals and add your own buttons.
#2 Depends on the approval flow pattern you define.
I will have to get a complete picture of your entire scenario to provide any guidance.
I have an approval flows playlist which includes many use cases.
It might help - 7_jq_Aipe
This is awesome Reza! I've spent hours plodding around other training and couldn't get it 😂 I have a question tho.... Is it possible to stamp sharepoint documents with meta data from sharepoint? For ISO9001 compliance. I would appreciate your help
Thanks.
Stamp docs with metadata I am not sure about it.
I will recommend checking on forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
So glad I found this gem! Thank you so much for this super informational video! Will subscribe to you now.
Thanks for subbing!
@@RezaDorrani Hi Reza! Just a quick question, do you know how can I automate the step of when the file/item has been approved, it should be moved to another navigation bar in sharepoint? i.e. New Submission Navigation > Approved > Submission Queue Navigation
Thanks!
@@verleengonzales4562 Nav bar would be either a folder or another library related. There are ways to move files but I have not done videos on those. I will recommend checking on forums at powerusers.microsoft.com in case someone has done something similar
Thank you Reza for this tutorial i really appreciate it. I would like to ask why the time in your computer did not match in the time of the response that the requestor received. Thank you again.
Sorry I did not understand the question. Can you point to times in video when this was shown.
@@RezaDorrani time is 26:53. The date and time in your email does not match the one approved by the approver. Is that a UTC time or your country time?
@@Rolly_De_Castro Where is my system time shown in video? 26:53 simply shows date and time based on the time zone I calculated it for (if I remember)
@@RezaDorrani If you can see the date & time that you received the email is Saturday May 8, 2021 2:14PM. But in the body of the email it show that request date is Saturday May 8, 2021 9:12PM and response date is Saturday May 8, 2021 9:14PM.
@@Rolly_De_Castro Email shows UTC + many times I may record video in parts and join.
This was so helpful. If the manager requires corrections on the document before approving, can those comments be made directly onto the document so that when the request is rejected, the employee can go into the document to see the comments the manager made within the actual document?
Any changes in document will re-triegger the flow.
Thank you Reza. Your videos have really helped me in my 365 journey.
Quick question, after a document has been approved, is there a way to lock down the document so no amendments can be made?
You would need to break item permissions and set it to view only after document is approved.
Or you could just move the file to a different library using flow (library that has permission set to read only for users).
Thank you. Very much appreciated. 🙏🏾
Reza, you are the man!
Thanks
Excellent Video Reza, thanks for uploading. I have a couple of issues with my workflow that I hope you can help me with. The 'Submit for approval' button is missing in my document library. Also the approval workflow triggers as soon as I upload a 'draft' document or update the metadata, although I have added the trigger condition: '@equals(triggerOutputs()?['body/{ModerationStatus}'], 'Pending')' as explained in the video to trigger when the approval status is 'pending'.
I will have to look at your flow & library setup in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks for your quick response, Reza. I replicated the flow you created in the above video in Power Automate with no issues. The issues I have are in SharePoint. I will post the screenshots in SharePoint on the forum.
@@hannahmay3078 Let me know what you find!
@@RezaDorrani Hi Reza, the submit for approval button has reappeared. However, I seem to have an issue with the workflow in Power Automate. The approvers are getting notifications when the document is still in draft status although I have configured the approval to trigger only when the approval status is 'Pending'. Is this how the flow is supposed the work?
Great Video Reza showcasing Approval Workflows in Power Automate. I want to ask if there is a video for the Power App development, that would be great as the app looks really awesome.
There is no Power App in this video. It's all SharePoint & flow. You may be relating to my video on leave request application. I am working on a video on that as well.
@@RezaDorrani Yes I am sorry, I was about to delete the comment as I had commented on the wrong video. And yes I was referring to the Leave Request video which has a Power App for requestor and approver. Thanks for the update, eagerly waiting for that video.
@@sumitkohli5550 No worries. I will have that video out by next week. I have never had so many requests for a follow up video :)
@@RezaDorrani Yes I can see that in the comments sections of the video and this would be really awesome as I can present the idea to my customers of a single power app for request creation and approval.
You are really great. Thanks for all these videos with in depth details.
Awesome. Is it possible to select multiple files and submit for approval? I can't find the button after selecting more than 1 file.
Only allows single file selection.
Thanx again, great stuff as always !!
Most welcome
Hi Reza, thank you for awesome video as always. May i ask what is your advice between using this method compare to SharePoint list? Which one has more advantages to apply? (Lets say for project approval and has 1 word file to attach too).
It depends :)
sharepointmaven.com/why-you-should-never-use-sharepoint-lists-for-storing-files-and-attachments/
Nice, thank you :)
Thank you for sharing Reza this is a fantastic video demonstration. I have been using the exact set-up for content approvals for a while now and it has been flawless. However, 24 hours ago the Submit for approval button that appears when selecting a draft item no longer appears. The only way I can move the document from draft to pending is by right-clicking on the item and going to More then Publish. Have you ever seen this before? Any idea how this could happen or beter still do you know how I can fix it. Any knowledge you have would be greatly appreciated.
Draft is only accessible to current user. The owner of the flow will not be able to access draft items of other users. Not sure if this is something related to a change that was done recently (but never know, may be a change with SharePoint).
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has run into something similar.
I have the same exact question. My Submit for approval button disappeared from the libraries. I lost a tons of time, trying to figure out if it was some setting I messed up.
Guess Microsoft changed stuff for the worst again...
@@pcostarg I did not see any communication on this on any forum either. Its strange that a change was made by MSFT!
About 3 hours ago my submit for approval button returned. The only thing I did between it being missing and returning was go to manage my flows open it and hit turn off. I have since turned it back on and it is still there. I have no idea if it was my actions that caused the submit for approval button to return or just coincidence but it's worth a shot.
Let me know how you go.
@@travishill4613 I still don't have the button. Tried to turn off and turn on. My flow is a bit different from Reza's one, but the trigger is the same (with the same trigger condition and all). Either way, I thought this button was SPO library Approval setting bounded and not flow related.
Great video thanks Reza, just a few questions:
1. After approval status has been completed, what prevents anyone from editing an item and upload/remove attachment on an item? Can only owners edit/delete items?
2. From audit compliance perspective, any additional settings needed for compliancy?
1 - If requirement is not prevent further updates, then you could either set item level permissions (make item read only) or move it to a different list (read only data)
2 - You can track entire approval process via flow + versioning of item will provide full details.
@@RezaDorrani How can you make the item with attachment read only once the content approval has been set to approved? How do you set the workflow to go through 2 additional set of approvals without modifying the document?
@@shanellcopeland6431 Explore rest api options in SharePoint to set item permissions. I do not have a specific video on it.
Great Tutorial Reza!
i made a mistake i guess. it creates always the apply to each loop when i add responses comments afterwards.
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
Great tutorial, thanks Reza! So thats a really nice out of the box feature, but how would you update metadata (e.g. approval date) AFTER it's approved? Cause then the status goes back to "Draft", is there a way to solve this?
When an update is made it does go back to Draft. However, the users (who have read access) will see the last published version until the new draft version is Approved. That is the default behavior of the Content Approval feature.
Anyone finding this guy's videos is really lucky. Thank you so much for the nice demonstration. Do you have any connection with Bahalpur city in Pakistan?
Thanks for your kind words.
Great tutorial Reza, thanks. I can't get the comments out to the email and SharePoint library. I get the response summary only. But when i watch your video, the comments you enter at 25:43 don't appear in the email at 26:45 or your SharePoint at 27:17, so maybe you could look at this again?
The comments don't appear in email because I did not add the comments to my send email action. Check 23:00 onwards I did mention in video that I missed showing the part to add comments. If you want to learn more about adding approval comments then check my full playlist on approvals (it contains various scenarios where I used it) - ua-cam.com/play/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe.html
I can't wait to eventually implement approvals for SharePoint, once I get the basics of PowerApps down.
I have a full playlist on approvals on my channel covering various scenarios.
Hi Reza, you legend! Love your videos!
Thanks Joel
Thanks Reza for sharing such useful content...
You are most welcome
Thank you Sir for sharing this. Can we print the approved document or the document with notes "approved"? Thanks
Possible may be using flow. I think there are 3rd party actions that can do that.
one of the best videos on approval flow. I have 1 Q. Suppose I do not activate content approval via versioning setting instead add a col for "Approval Status" with choices of Pending, Approved and Rejected. Default selection is Pending.
If the file is approved, the Approval status col should change to "Approved", if rejected, it should change to "Rejected". What condition do I need to follow to ensure the flow works. If you have any video which caters this point with reference to a document library, pls. share the link. Thank you in advance!
Thank You.
I may not have an exact use case match video, but I do have a full series of videos on approvals that would help.
Check ua-cam.com/play/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe.html
Hi Reza, great video!!
I have a question regarding editing a document DURING (not before) the approval flow.
In our scenario, a user submits a document for approval. The approver needs to be able to review the document from the email and make changes to the document where needed before the request will be approved. Once the changes are made, the approver will approve the request from within the email.
As changes to the document are made during the approval flow, the “Approval Status” of the document is set from “Pending” to “Draft” and not “Approved”
Is there a workaround to enable approves to make changes in documents and approve the submitted request?
Many thanks in advance 👍
There is no workaround with this approach. You would need to avoid using "Approval Status" and create your own status column and track through that.
Hello Reza, an excellent video tutorial like all the others you have.
How can I define my approvers based on a sharepoint list?.
I know you have another video where you define your approvers based on a sharepoint list,
but I would like to know how I can merge that with this video tutorial, because that's what I really need.
Thank You.
I have done multiple videos on those. Check ua-cam.com/play/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe.html
You would have to mix the logic in both the videos.
Absolutely fantastic, thank you for sharing this.
Most welcome!
Excellent work Reza.
Can you please elaborate if instead of sending each invoice separately what if we need to make a recurring flow (say weekly) that gets all items in "Pending" status and send one email to Approvers with data in tabular format in email body. How this can be done alongwith Approve / Reject updates? Would appreciate if you can make a video on this pls....
Approvals work on single items. You could run flow on recurrence and send 1 approval action, but response will be for all together. I do not have any reference videos on your scenario though. I will recommend checking on forums in case someone has done something similar
powerusers.microsoft.com
@@RezaDorrani thanks for your prompt reply. Can you pls make a video on this scenario? I guess it would benefit your community including myself🙂
@@capstonepm111 I only make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community tab of my channel. Most voted ideas get added to my backlog. Make sure to post this idea there once the next topic suggestion post comes.
Hi Reza. Thank you for this video. I am currently using a basic approval workflow (start approval + wait for approval) for our organisational document control. Basically issuing documents to users to confirm they have read and understood internall process documents. My organisational requirement is to be able to log each approvers response as they come in. At the moment i am unable to track the responses until after 'wait until approval' function is completed. Is there anyway to track individual responses in real time? Ive created a seperate list for these responses but i cant seem to get it working. Thank you so much for your work Reza
To log each response whil approval is ongoing - you would need to query Approval tables in dataverse (premium feature). I did show one query to approvals in dataverse to find out which user(s) have not responded so they get reminder emails.
ua-cam.com/video/ZupQ0AbDl0I/v-deo.html
HI Reza, Very Good Explanation, when a file deleted from sharepoint, document owner notify approve or reject using power automate. Please make a demo for this
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hello Reza thank you! excellent tutorial. My flow works perfectly but my trigger/flow keeps running after it has been approved. How can I set the Power Automate flow to run only once after Sharepoint column has a value? Please assist, thank you.
Check trigger conditions in flow. I would also recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Excellent Video. but quick question how to make this flow run with manual trigger
You can run flow for a selected item from sharepoint.
Check my approvals playlist. I have done some videos on them.
Approvals playlist ua-cam.com/play/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe.html
Thank you so much this was so helpful. Do you know if an email notification can be sent to a different person depending on the payee account? I created a column to show the account it should be paid from (Payee Account) as we have multiple accounts/locations, each location has a different approver?
You could use a shared mailbox to send the emails.
Thanks! What if multiple people need to approve the document? And allow them each to approve at their convenience, not in a specific order ?
Check my playlist on approvals. I have shown various approval patterns.
Hello Reza, Excellent work can you please guide flow for file deletion. I mean if any one delete a file it must go for approval. Thanks.
I do not have a video reference on file deletion 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.
@@RezaDorrani I went through your recommended link but no luck if you get chance please create it will be very thankful. Much appreciate for your excellent work Man keep it up.
@@asadmughal6431 You can post your question on the forum. I make videos on topics when I receive many requests on it. This is the first request on this topic. Chances of video being made on this are very low.
Hi Again Reza. Thank you for all your videos, Ive watched so many haha. I have another question. I currently have my doc library with subfolders to house SOPs for each department at my company. Is it possible to have the approval request go to different people based on the folder(department)? Meaning it goes to specific people based on which subfolder the document is located in. Also, Is it possible for approvers to not have access to edit the documents? Thanks again for all your help.
You could create a mapping list to define who the approvers are for each folder.
folder name approvers. Similar to what I showcase in this video - ua-cam.com/video/R18_qYVPWl4/v-deo.html
Your reviewers can have read only access on folders. You can set the security at folder level.
@@RezaDorrani Thank you
@@RezaDorrani Hello Reza! This is very useful. However, I'm running into a failed status because it can't find the Approver. My approver is coming from file properties where Approver is indicated. How should I use this instead of hardcoding it?
@@ming-nomadictrotter You can get the approver email from that property and associate it with the approver property.
I will also recommend posting your query with screenshots on the forums at
powerusers.microsoft.com
@@RezaDorrani thanks. I created a new one and it worked in a way.
Thanks for step by step guide and sharing, this is very useful for beginner. However would like to check how can we auto populate "approver name" under "Approver Name Column". I believe "Approver Name Column" was hidden in All Document view in your video above. Thanks in advance!
You can populate hidden columns via flow.
@@RezaDorrani It would be good if you could also list down the guide in chat. Appreciate it :) thanks!
@@jodieang8944 I would have to try it out to list it out in chat. Best to post queries on forums at powerusers.microsoft.com