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!
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!
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 👍
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 !
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
@@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
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.
@@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.
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
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 ?
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
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) - ruclips.net/p/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
Reza - This is an excellent tutorial on SharePoint Approval workflow. Thank you so much. I had a quick question on 'set content approval status' action under Yes condition. I have a use case where I need to update couple of SharePoint columns if the Approval status is "Approved". I have added that action 'update sharepoint field' just before 'set content approval status'. The Approval Status column is to 'Approved' and then it immediately changes to 'Draft', probably because a SharePoint column was updated. What's the best way to keep the workflow status as 'Approved' in this case ? I am using the exact same flow as you have described above with the only change where I am trying to update couple of SharePoint columns
Thanks! For this you would probably be better off not using content approval or first updating the column values and then setting content approval to Approved.
@@RezaDorrani - Thank you Reza for the quick reply. I really appreciate it. I am actually updating the column values first and then setting the content approval to approved, even after that the status is changing from Approved to Draft. Would you instead recommend a custom approval workflow if content approval is not recommended in this case? Do you cover topics like this in your paid training for members ? I would love to subscribe if that's the case
@akashsaini684 Not sure why that would be the case. You could try custom approval. Paid trainings has a set agenda and folks vote for topics there. Would definitely cover this in a future training program if there is interest from all.
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 ruclips.net/video/2Hp9CTd8zQU/видео.html
@@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
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.
Thank you for this info! This was extremely helpful and I was able to complete this with ease because of your video. I do have a small question.... when you click submit for approval, it shows a box where you are able to type in comments about changes in the document. How do I include that in the Details section of my Start and Wait for an approval step? I want that included in the email to the approver.
Those comments are office 365 comments and not readily available. I believe it requires a graph api call to get that info. Something that I have not explored.
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 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?
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
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 ?
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.
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)
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.
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.
thanks Reza. when I did the same the flow wait at Apply each. But in your case i can't any apply each on Respone comment when it run log.. Do we need to do any change to overcome the Apply each ? I can see the apply each was till 23:38 but once you save it gone
Im not sure what the question is. I did mention a part was missed and showed it in video. This video was done a while ago, hence I do not remember much either.
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.
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.
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
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 ruclips.net/p/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
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!
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 ruclips.net/p/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe You would have to mix the logic in both the videos.
@@RezaDorrani In Send an email option I have placed the dynamic content "Response Summary", When I add this, it displays output in one line. I want to break it down to multiple line for readability. How do I do this? I have searched many articles and couldn't find any.
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.
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!
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.
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.
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?
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.
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 ruclips.net/video/EACk5jlQ_jU/видео.html
Hello @reza dorrani Great video!!! When using out of the box content approval, is there a way to append multiple approvers comments in Set Content Approval Status - Comments field?
Thanks Lyn. Interesting question. I would have to try it out myself to know if it’s possible. My guess would be Yes. I would recommend to check on the forums at powerusers.microsoft.com in case someone has done something similar
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?
Thanks for the video. But my recent experience with this was the version history is not well maintained, meaning you will not know who has approved the document and will have to depend completely on the Approval comments. Handled it with a manually triggered flow.
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.
Flow actions run under context of its connections. This is an automated flow, so the action would run under creator name. You could build the flow with a service account so the approval goes from that accounts name.
@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 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 😊
Paused the video for a quick to say Thanks. Ok, back to watching.
😊 thank you
Thank you, sir!
After watching your videos, I am trained in MS PowerApp, MS Sharepoint. Thanks a lot sir!
Your most 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.
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!
You are an excellent instructor. Concise and complete. Thank you for these videos.
Glad you like them!
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!
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 :)
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
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.
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.
Excellent! You helped me with a customer. Great explanation and very clear every step (something that is not usual on RUclips). Thanks!
Glad to hear that! Thank You for the feedback and thanks watching the video.
excellent video, very help ful to show our users how the approval feature works in sharepoint!
Thanks
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
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!
A simple solution for a modified file approval ! This worked for me like a charm 🙌
Excellent!
I tried and it is working beautifully :) Reza is amazing :)
Great to hear!
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
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!
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.
This is exactly what I needed!! Thanks Reza. Great video. So easy to follow along.
Great to hear!
Thanks!
Welcome
you are best of the best. a refresher after 3 years .:)
Glad to hear that
A refresher would be nice, a lot has changed I would think in 3 years.
Excellent video Reza. 10 out of 10... well spoken and a very good demo!
Thank you!
Thank you Reza for sharing 'Approvals' in simple terms. Makes it easier to implement.
Glad it was helpful!
Your videos are great. Realistic use cases and very clear explanations. Thanks a lot.
You are most welcome.
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.
Excellent tutorial. Thank you for taking the time to explain it so thoroughly.
You're very welcome!
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
Great. Thanks Reza for the step-by-step guide.
My pleasure!
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!
thank you for this easy to follow and great tutoial!
You are most welcome
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 you so much for this tutorial. It's exceptional.
You’re most welcome
Thank you so much, your videos are awesome, contains every minute detail
Thanks so much for watching and liking the videos
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).
Reza, you are the man!
Thanks
Fantastic tutorial. Love your approach.
Thank you
Thank you so very much! This was very easy to follow and helpful!
You're very welcome!
Great video, very helpful. Exactly what I was looking for. Thank you!
Great to hear!
Excellent. Thank you so much,Reza!
You’re most welcome
Thanx again, great stuff as always !!
Most welcome
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.
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
Hi Reza, you legend! Love your videos!
Thanks Joel
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) - ruclips.net/p/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
Thanks Reza for sharing such useful content...
You are most welcome
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.
Absolutely fantastic, thank you for sharing this.
Most welcome!
Reza this is great!, thank you your, videos are very helpful!
Thanks Chad
Thank you Reza for creating this.
Thanks for watching Robin
Reza - This is an excellent tutorial on SharePoint Approval workflow. Thank you so much.
I had a quick question on 'set content approval status' action under Yes condition. I have a use case where I need to update couple of SharePoint columns if the Approval status is "Approved". I have added that action 'update sharepoint field' just before 'set content approval status'.
The Approval Status column is to 'Approved' and then it immediately changes to 'Draft', probably because a SharePoint column was updated. What's the best way to keep the workflow status as 'Approved' in this case ?
I am using the exact same flow as you have described above with the only change where I am trying to update couple of SharePoint columns
Thanks!
For this you would probably be better off not using content approval or first updating the column values and then setting content approval to Approved.
@@RezaDorrani - Thank you Reza for the quick reply. I really appreciate it.
I am actually updating the column values first and then setting the content approval to approved, even after that the status is changing from Approved to Draft.
Would you instead recommend a custom approval workflow if content approval is not recommended in this case?
Do you cover topics like this in your paid training for members ? I would love to subscribe if that's the case
@akashsaini684 Not sure why that would be the case.
You could try custom approval.
Paid trainings has a set agenda and folks vote for topics there. Would definitely cover this in a future training program if there is interest from all.
@@RezaDorrani Thanks Reza. I will further investigate this at my end.
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 ruclips.net/video/2Hp9CTd8zQU/видео.html
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 for explaning soo well
Thanks for the feedback and thanks for watching
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.
Thanks for creating video it is very useful for my current project
Glad to hear that
Thank you for this info! This was extremely helpful and I was able to complete this with ease because of your video. I do have a small question.... when you click submit for approval, it shows a box where you are able to type in comments about changes in the document. How do I include that in the Details section of my Start and Wait for an approval step? I want that included in the email to the approver.
Those comments are office 365 comments and not readily available. I believe it requires a graph api call to get that info. Something that I have not explored.
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 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.
Nice and usefull. Thank you very much.
Thanks David
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.
That was a wonderful vid, Thanks bro !
My pleasure!
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.
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.
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)
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.
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.
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.
thanks Reza. when I did the same the flow wait at Apply each. But in your case i can't any apply each on Respone comment when it run log.. Do we need to do any change to overcome the Apply each ? I can see the apply each was till 23:38 but once you save it gone
Im not sure what the question is. I did mention a part was missed and showed it in video. This video was done a while ago, hence I do not remember much either.
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.
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
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.
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
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 ruclips.net/p/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
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.
Hi Reza... can u please Give one example for :- Can the override label be blank ? If so we can combine 2 parameters under a single label.
👍
Sorry I did not understand the request. Override which label?
For example : notify a team when a new form response is submitted.
@@VinodKumar-vu7sd Absolutely can be done. There are flow templates available for that.
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
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 ruclips.net/p/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
You would have to mix the logic in both the videos.
In timestamp 26:27 In the email notification, is it possible to break down the response to individual lines rather than having it in the same line?
Email body accepts html
@@RezaDorrani In Send an email option I have placed the dynamic content "Response Summary", When I add this, it displays output in one line.
I want to break it down to multiple line for readability.
How do I do this? I have searched many articles and couldn't find any.
@@asankalk This is something I would have to try to know the steps.
❤❤ Amazing tutorial
Will this still work if minor versioning is disabled in the library settings?
Most welcome!
Try turning off minor versions and check
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.
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 👍
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.
Thank you and well done.
Most welcome
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.
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.
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
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.
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 ruclips.net/video/EACk5jlQ_jU/видео.html
Great video, thanks Reza
My pleasure!
Hello @reza dorrani Great video!!! When using out of the box content approval, is there a way to append multiple approvers comments in Set Content Approval Status - Comments field?
Thanks Lyn.
Interesting question. I would have to try it out myself to know if it’s possible. My guess would be Yes.
I would recommend to check on the forums at powerusers.microsoft.com in case someone has done something similar
Hi question - on the compose step 13:46 I do not see this"add dynamic content" is this a setting I can change?
Thanks
Check your screen resolution. You may be zoomed in too much.
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.
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.
Thanks for the video. But my recent experience with this was the version history is not well maintained, meaning you will not know who has approved the document and will have to depend completely on the Approval comments. Handled it with a manually triggered flow.
True! We can always add additional columns to track that information.
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.
great video. The only error I face is the Approver Email is sent from My Name and ID whoever modifies it. It doesn't come from flow.
Flow actions run under context of its connections. This is an automated flow, so the action would run under creator name. You could build the flow with a service account so the approval goes from that accounts name.
@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