This is gold standard of teaching for power automate/flow category..this is just fantastic. Last time i said gold standard of teaching was for PowerApps for Shane Young. Thanks a ton for sharing such a wonderful ,informative and greatly taught video. Waiting eagerly for next videos.

thanks Reza. Learnt many new things in this tutorial especially the last piece of sending reminders to only those who haven't actioned the approval.

I use this setup today for my approval reminders but the Multiple Approvers using CDS is new to me and is definitely going to be in my next approval reminder flow, that is quite awesome! One thing I do in addition is add a terminate as successful action when the approval is completed (either approved or rejected) so the flow doesn't keep running waiting for the next delay interval in the reminder. The first approval reminder flow I wrote the flows would run for 4 days even if the approval was complete in 10 minutes, just keeps the run history tidy (IMO).

Quick Update Required Instead of "List Records" you need to search for "List Rows", this can be found under "Microsoft Dataverse" Actions

Wow, Reza this is gold. The first to respond is quite straight forward. But my issue was the scenario where everyone must respond. I was thinking about how to implement that and here you just made it sweet and easy. Thanks for all you do Reza. The second option was basically my scenario.

Very helpful video. You have covered some topics which are not covered by any youtubers. Many many Thanks!!

God level of explanation, came here for approval process and learnt other actions like i never used them before. Very happy and lucky to found your tutorials. you are the boon for beginners.

The remainder email based on the current approver part was really useful ! Once again an amazing video 🙌

You are genious and exactly creating the videos which all public and bussines required. Excellent and thankful to you. Waiting for more complex and tricky flows and power apps videos

Hey Reza, this is an amazing video that I have watched at least a dozen times and still referring for various approval senarios. 😊

Your video was so helpful, thanks for sharing great content like this. It was exactly what I needed and worked in my flow. You rock!!

Hi Reza, so I followed your steps here regarding the CDS ( now Dataverse) and getting from a group of approvers where everyone must approve and checking to see who has and has not responded. In my example, I have 3 approvers where I am one of the approvers for a given item. When I use that filter query to loop through the current approvers email addresses, and I know 2 of the approvers including myself have already approved, it is only returning my response for some reason. I’m sure it’s user error in my example, but for a future video, I would love to see an expanded take on this scenario since it is very common that a manager of someone would want to see who hasn’t taken an approval action. I’m surprised Microsoft hasn't made this more intuitive to gather. Would be great to see an output updated in an Approval Summary Column and checked/update as part of the do until loop. Thanks for your amazing work!

Very nice and detailed tutorial Reza. Many thanks for sharing the information.!!!

Wow, Exelent video, This is exactly I need, I have my flow but my reminders are for all approvers, I wold like to send the reminders only that have not approved, I do not to have access to List records. I will continue finding out a solution. Thanks for fantastic vídeo

Looks like you were on the dev team that made Power Automate and Power Apps

you are great!! best part of this video was creating it from base level to final output, you were not running to finish it by showing few readymade steps. thanks a lot. I am really interested to learn this complete course steps by steps , do let me know if you have any course set.

Hello Reza. Thank you very much for your wonderful video lessons, they help a lot in learning the capabilities of Power Automate. Can you help me with creating reminders during the approval process? How to cancel the wait and continue executing the thread at the moment when the approval occurred without waiting for the end of a parallel thread with a wait?

Totally agree with the Gold Standard comment.

Genius...awesome...long awaited cds step. Thank you so much... Really saved my day

Reza I love you this videos are LIFE SAVING

Hello Reze, I really appreciate your work. This is very helpful and valuable. However, I have one important question for me. In the reminder process, I use the "Custom Reply - Wait for One Reply" option. I'm looking for a solution to implement a reminder for this type of approval, but to no avail. Do you have any recommendation on how to calculate this?

Really great article learn a lot from this video. thank you for uploading this video.

Happy Holidays Reza! I can't thank you enough for all the work you've done putting these fantastic videos together. I have learned so much about power automate from you in such a short period of time. Thank you! I know this video is a few years old, but I'm hoping you can help me with an issue. I'm using the all approvers must respond approval and pulling them from a SharePoint security group. Created the reminder branch using DataVerse List rows action so it only sends reminders to those that haven't responded. The problem is that I stop receiving reminders after I approve, but the other two approvers continue to receive reminders after approving. I checked the output of the list rows action and my Value is populated while the others are null even after they approve. Any idea why there is no value for them and there is for me?

Thanks for the video. It was great. How can this be achieved if we need to send approvals to multiple people one at a time? Also delay until will not stop as soon as the approval is done & we will not be able to use Termjnate inside a loop. Also what if we need to do some steps after approval process. Kindly provide your insights in this situation.

Reza, great video, I learned so much. Could you point me to a video or explain how I can use the Approval type "Approve/Reject - Everyone must approve"? Thank you for your time.

Thanks @Reza Dorrani for such a great video. It really gives much confidence for newbie in PowerAutomate.

Hi Reza again excellent contents. Is it possible to resend the original approval email again rather than sending a respond link? Also is there an option for auto approve?

Hi Reza , Very knowledgeable video . But I have situation , I am using state machine worklfow , Where I am trying to implement this logic . I am able to get approval email immediately and workflow changes state to another state when I set the reminder duration to 10 min , but when reminder duration is set to one day , State Change happens after one day ,even after approval is given at State 1 on the same day .

Thank you Thank You Thank You!!! One of the finest tutorials.

Hi Reza, I found this video, but I think CDS connector has changed. Could you tell me if the new one is Microsoft DataVers ( List Rows(legacy)) many thanks

Hi, this is an amazing tutorial. I was wondering if you have a video of sending reminders for multiple approvers when there isn't a set group. For instance, I have an approval process that starts with "For a selected file" where the user can input as many emails as they want. I was trying to use what you did here, but I get an error when running the flow. I believe it has to do with me not being able to do the "select" action.

Hi Reza, unfortunately I am not able to get the field owninguser/internalemailaddress. My flow throws an error. Are there any more requirements in the direction of CRM or is the field internalemailaddress not available anymore? Any other ways to figure out the affected user? Thank you for your help! { "status": 400, "message": "Could not find a property named 'internalemailaddress' on type 'Microsoft.Dynamics.CRM.principal'.", "error": { "message": "Could not find a property named 'internalemailaddress' on type 'Microsoft.Dynamics.CRM.principal'." }, ----------- Problem solved, I used the field owned/internalemailaddress

Hi Reza, great content once again! I am creating a scheduled workflow to send reminders a day before the due date. My flow ran fine for two days and stopped/did not notify me on the third day. Upon checking the flow, the 'Get Files' action is not returning any value. However, the DueDate column has items in there. I would greatly appreciate any help you could give me in understanding the issue. I would also be grateful if you could direct me to a resource that could help me with this issue.

Hey Reza, Love the content. I had a question if you possibly have the time. I used your methods with creating a Serial Approval process as you demonstrated a while back. I added reminders to that process and everything works awesome except for the last action in the flow which I can't figure out. Before I added the reminders to my serial approval flow, the Update Approval History action (Set Variable) worked as expected. Now after adding the reminders to the mix Update Approval History states "BadRequest: The variable 'varApprovalHistory' of type 'Array' cannot be initialized or updated with value of type 'String'. The variable only supports values of types 'Array'". Can't seem to understand why that isn't working anymore as everything else is working perfectly. Thank you so much!

Hi Reza, great video, i have followed a couple of steps and slotted them into a flow i am building. Now what i really want is that bell icon you have in your reminder, how do i get that in my reminder title?

I have followed a similar pattern for sending reminders using the send email with options. My problem is, even if there is a response after 5 minutes my Flow still waits 24 hours before checking the variable. This is too long for me. I need a way of forcing the Flow to proceed after a response without waiting for the reminder period.

Hi Rezza, Brilliant video. However owninguser in my environment doesn't capture anything. Do you know how I can change this?

Agreed fantastic video... As a newbie to Power automate this is so very user friendly. Thank you Reza, I have watched it multiple times to make sure my syntax is correct, and almost there in making my multi-approver workflow function as required. I was a bit stuck on the List records CDS action. In trying to troubleshoot this, when I checked my Approval Response entity data in PowerApps, the column for the "Owning User" is empty? Though I see it is also empty in your video, so I now realise that wasn't causing my problem. Similar to Alina's earlier post I am using a multi value people list from ShPt as my Approver array, which seemed to work on the Approval side of the workflow, it looked like it was causing problems on the Reminder side of the flow. So I have now been able to fix this by converting the ShPt people list into the Array variable using your suggested Select function. And hallelujah - it is now working... after 5 days of many iterations.... :-). Thanks again for providing a great resource, and I will work my way through your other videos.

Another awesome tutorial.

Hi Raza! This is very good, i like it but unfortunately it still send reminders to the users that already approve it. Any idea where the problem is?

Dear Reza, i have built a flow which uses your 'send a reminder' layout as in your video. I have built and rebuilt this flow a couple of times and the first time i used the information in your video regarding the 'respond link' dynamic information. i embedded it as you suggested and it worked beautifully. Now it does not want to work. i am not a coder, a colleague has suggested that the flow is overwriting my instructions automatically and getting it wrong. @{outputs('Create__-Supervisor_Approval_')?['body/respondLink']}">@{outputs('Create-__Supervisor_Approval_')?['body/title']} this is what is happening and the link does not work in the reminder email. is there a solution?

Rezza, I've implemented this flow and works very well. Although, I'm trying to expand this by adding any attachments that's in the SP List to append to an array into the Attachments of the Approval. Seems a lot of videos and blogs people have same issue as i do. The Flow errors on Create approval "The request content was invalid and could not be deserialized: 'Unexpected character encountered while parsing value: {. Path 'attachments[0].content'". Many hours and I'm going in circles.

Thank you Reza have a blissful day

Another awesome tutorial, thanks Reza. I have a question, how do you send the reminders to the person to whom the approval task has been reassigned to? In my workflow, once the approval task is reassigned, it still sends reminders to the original approver. I want the workflow to stop sending reminders to the original approver and start sending them instead to the new reassigned approver. Thanks again for any suggestions and for the videos.

Hi Reza, Thank you. The video is really helpful. Can you please help solving the problem.I am getting status code '200' as output of List rows even if apply the first filter(msdyn_flow_approvalresponseidx_approvalid eq '@{toUpper(body('Create_an_approval')?['name'])}')

Thank you Dorrani. Very Helpful. I am facing an issue. My "Approval Responses" table display only my approval response. If other approver response it not display in the "Approval Responses" table. For this when I pulling data from this table based on filter query other approvers record count is always 0 and reminder notification send to the approver, even if he approve the item. Please help.

This is good. I have one scenario that we have 4 serial approvals but if first is not approving in 3 days then should go for another approval, if that is not approving in 3 days then go to another approver and so on. How can we achieve this goal in Power Automate?

Hi Reza, I followed the steps and one issue is, the reminder email keeps coming even after a decision has been made. The variables are not updating to reflect that there is an outcome.

Great video Reza, would it be correct that the flow does not move on until the delay period has expired on the Do Until branch even though the variable is set to true?

Great video! I am trying to implement two levels of approval. The first level has two approvers and works great. I have created a second level of approval which does work, but only sends the reminder email once to the approver. I am using everyone must approve for both levels, however I currently only have one approver at the second level (I may need to add one more later on). Could having only one approver, (but using all the variables for multiple approvers) cause the reminder to only send one email even if the approver did not approve? Thanks for the help!

Hi, Reza Dorrani, Thank you so much for this! This really helped me in making my flow. However, I needed to send out approvals to 7 approvers. I stored the approvers in Sharepoint List, I followed your tutorial and created the create an approval but when an "approver" responded to the approval, other approvers who do not respond will not be able to respond. How can this flow work given that my goal is to send out all the approvals at the same time and will send out reminders to approvers who don't respond?

Thank you Reza

Hi Reza, Thank you for this video, I have a question, is there a reason that I don't see the approval-related triggers in the do-until branch?

HI, first of all thanks for this video but i have a question , Mr. Reza can we do a flow when the approver receive a reminder if the flow hasn't been approved or rejected after a certain period of time?

Hello Reza, I'm trying to replicate something very similar to the case you showed in the video. But I noticed something while working with Dataverse. Around minute 27, when you use the filter query expression, i noticed that in dataverse, the OwningUser Column is empty, and its the OwnerID column that is populated. Does that mean that i need to replace the owninguser by owningid ? and 2) can you please explain what the/internalemailaddress is because i cannot find any column with that name. Thanks!

Hi Reza, your videos are great help man.! I have a question though, I am creating a similar flow in my org, approval with a reminder. I am having issue when I run the flow twice for the same approver. As in, the flow gets lost after exiting the do until loop if it is run twice for the same approver. If i run a single flow, it works like a charm.

Hi Reza, Thank you for the great content as usual. I don't think the reminder part works as intended. If we set the reminder inside the do-until to be sent after 2 days but the approver approved it in a couple of hours, the do-until side will still keep running until the 2 days delay is over. This is especially a big problem if there are multiple serial approvers.

Awesome!! 👏👏👏

I really appreciate the video you put together. It's very informative and provides a lot of information in a short time. What I'm struggling with is the relationship between the "Do Until" and the "Delay" commands. I want to send a reminder if an approval hasn't been received in 3 days (72 hours). How would I want to setup the timers on each? Great appreciate any advice.

Man, you are the best!

Hi Reza, do you have a video to send reminders only to the approvers who havenot responded in a multi approver scenario?

Hi you! how to forward to a higher level if the direct manager does not approve after automatically prompting.

Hi Reza, Thanks a lot for your tutorials. It's amazing. Is there a chance to use and to put e-signature when you send pdf document as attachment?

30:45 could you explain how permissions work on the "approval responses" entity? I am a little bit surprised that you get access to all responses.

Another amazing, well structured and explained video. thanks Reza. If an approval is expected to take more than 30 days for a response, is that possible? If not would it be necessary to somehow get one flow to trigger a second flow to send out reminder emails after 30 days? do you have a video on this? Thanks again for your amazing work

Dear Reza: Can we migrate comments as well from one list to another using power automate, as normal power automate flow doesn't get the list item comments.

Wow, Reza this is very nice. Heads off to you :). My issue was the scenario where everyone must respond and have to sent 2 reminder e-mails on 3rd and 6th working day. But I dont have this Premium license of "List Records". Is there any other way to implement this functionality without this premium license and if not then Please tell :"What I should inform to customer or concerned team i.e. Name of the license which is required and the cost of this license" to fulfill this requirement. Eagerly waiting for your response.

Hi Reza, thanks for great video. Maybe I have a question. How to avoid sending email notification to list of approver after they submit the answer? Shall we somehow erase email adress from the varApprovers after Approval flow box had their response in do-until box? Thanks in advance for any response.

im doing this just now but now i cant find the list records command. can someone help me out?

Hi Reza, the join expression you provided, my automate throws out an error. I think I may have written the expression wrong. Error is "Required field 'assignedTo' contained no valid users in the organization" the assign to seems to throw out the result looking like this {"fakemail@ mail.com":""}; in the Azure ad group there should be 2 users but only shows one. Expression I used is join(body('Select'),';')

How send reminders email 3 times each mail has 10 dys gap once start an approval.

Reza, is this possible to do with "When an item is created or modified"? Or is it only possible with "when an item is created"?

Hi Raza, I am still waiting for your response since morning.My issue was the scenario where everyone must respond and have to sent 2 reminder e-mails on 3rd and 6th working day. But I dont have this Premium license of "List Records". Is there any other way to implement this functionality without this premium license and if not then Please tell :"What I should inform to customer or concerned team i.e. Name of the license which is required and the cost of this license" to fulfill this requirement. Please help. Eagerly waiting for your response.

thanks Reza for this video. I am seeking for "Respond Link" which you have shown on timeline 17:59. I am not getting it. I am using "Start and wait for an approval" action. I tried "Create approval" action also but no luck.

Question: How do you identify who hasnt approved the item if there are more than 3 approvers and the approval type is everyone must approve? Is there a way to monitor this?

Anyone else notice that CDS doesn't seem to show who has/hasn't approved anymore? I set this up in one of my flows and the reminders used to work the correct way. Now they go to everyone regardless of if they have approved or not. Did something change?

Excellent as always! Just one question- what is the reason for the condition under the delay action in the 'do until' loop. Shouldn't the variable being set to true at the beginning of the 'do until' loop prevent it from recurring? Why do you also need 'if the variable is set to false' then send the email?

I don't have dataverse because I'm on a government system. How can I tell who has already reviewed and who has not without that premium feature

Hi Reza, Even if approver approved the request in time he getting reminder email what is the issue?

Great job.

Is there away to separate requests for example I have an employee that manages a piece of the list and another employee that manages another piece of the list. So basically if a user selects a certain portion of the list I want it to go to a certain employee.

Thanks Reza, really useful. Quick question. Am trying to set up an approval process where I have the approvers listed on the same library as metadata for each file (timesheet) created. I would then like to run the approval process concurrently to all approvers for their respective timesheets to approve. At the moment, the flow stops until one approver has approved before it sends the next approval in the library which could create unnecessary delay in the process.

very helpful! than you so much

what if the approval action ActionTimedOut is reached? how to manage the failover on Do until action?

Hi the video is so useful, i would like to know how to add email reminder if the status is not changed for 14 days, can you pls guide.

Is there a way to add a column to show when the List item was approved?

Thank you Reza. If I want to send the mail reminder a day AFTER an expected outcome. (an expected date on the list), what do you advise? How do I get an increment that would be dependent on the date that would be available on the list in SharePoint. Thank you

how to create power automate, when the date is today, then the notification can do email to the user that assigned. ?? ideas ?

Hi Reza, I am trying to re-create your flow but my process stalls at create an approval, instead of continuing down both parallel paths to initiate the Do Until reminder. Is there anything you did not mention in the video that could be causing that? Thank you very much in advance

Reza, really good video. thanks

i think i found flaw in the reminder pattern... since we are telling the do until to wait for 1 day before our reminder check, my flow is stuck running for atleast 1 day before it will complete, even if my user has approved within 5 minutes. How would u terminate the do until early if the item was approved?

Hi Reza, I want to create a flow wherein I only want to send reminder emails to the approver whose approval is pending. After initialising string variable for approver list how can I initialise array where I don't want to use AD? I am using the same flow as you have explained except I dont want to use AD. Please suggest.

Hello sir Good afternoon Hope you are doing well 😊 Actually I created a power automated flow for approval and reminder by referring to your video On KZfaq but I want one extra activity in it. What I want to achieve ,if the form is rejected then the flow automatically needs to send an mail to resubmit the rejected form and if it's approved then also the submitter should get the mail as your application is approved successfully... Could you please guide me for achieving this scenario Or please make one video on this.

If I have only one license with Premium connectors which I use for development of flow and can users with E3 license can use that flow for approval process ???

I have Start and wait for approval, would I do my branch for the "Do Until" after I've set my Status variable? I had mine working even using the "start and wait for an approval", now it is not doing the reminders. I have my parallel branch after my "start and wait for an approval.

Hi Reza, I'm getting reminders to all approvers even when they have already approved, this happens until all approved, then the reminders stop, I followed your video and the only difference is that I am using the email ID from an approvers column in Sharepoint, is there something am I missing that is causing this? any help is appreciated, thanks

Great video. Unfortunately I´ve the problem that all the approver comments will be overwritten by the next comment. So at the end I´ve only the last comment. How can I avoid this. My column Approval text is single line of text. Thanks in advance and greetings from Munich.

Did you make a Help desk Ticketing list

👍👍👍🙏🙋‍♂️

How do you create the array for the "wait for all responses" solution if you are not using the CDS list? I'm just using a SharePoint People list. Thank you!