Just been following the steps to use the people picker column (21:46), but adding the Approvers Email is throwing in another Apply to Each. I tried following the rest of the step anyway but the flow failed and gave me this error message: "The execution of template action 'Apply_to_each_8' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_7')' is of type 'Object'. The result must be a valid array." Am I doing something wrong or does the video need an update?

You just have a really great way of teaching so that people just get it. And the little suggestions that show attention to detail are so useful and make it easy for anyone to find a way to make the outputs of their flows so intuitive and user friendly. More power to you 🙂✨

Reza, you're a great teacher - I'm so glad I found your videos. Best stuff I've found after weeks of trying to learn how to set up Approvals in Power Automate

Thank you for just keeping it to the steps! Some "how to" videos are so hard to watch because they go on and on and on about nothing.. You are like do this do that do this do that and voila! I appreciate that so greatly!

What an outstanding tutorial! Thank you Reza for putting this video out there for Power Automate learners!

SInce long I was just thinking to develope this in my project, we had no clue of it and we kept this kind of things to be in the last bucket. Now this video has really helpful to me and we have develope the big componet on your idea. You are awsome. I am thankful to you and looking for such good videos on power apps which are not avaiable or people seeking for it.

Just completed my multiple approvals. Works great. Thank you!

Thank you Thank you Thank you Reza for each minute and sec you invest in the preparation of these vidoes and trying your best to make it simple for us to understand and going back and forth to diff tabs just in effort to making it easy for us to understand.

Thank you so much Reza, this video is just what I needed to implement an approval process in my app. Love the cookbook series!

Great video, as always the idea of the Audit Trail and the emojis very clever. Thanks

Again Very well explained. I liked the 'Approver comment' concept which is helpful to understand to an end user in real case business scenario. Thanks for sharing.

Thank you so much for making this video! It was so helpful,. I have watched your expressions 101 and 201 and still learning, Thank you for providing examples of the tools and a way to understand them. Having a hard time converting UTC time but working on what i may have done incorrectly. Thanks!

Just incorporating your approval steps here into my flow and gotten an error at the "approval" step. Error message of "BadRequest. The request failed. Error code: 'InvalidApprovalCreateRequestAssignedToMissing'. Error Message: 'Required field 'assignedTo' is missing or empty.'." My assigned to field is using the varApproved variable according to your video. Not sure where it went wrong. Also would like to add that you've been my Power Automate savior. Especially to those without much IT/coding knowledge, your video has been super helpful so far.... Cheers mate!

Great work raza bhai. waiting for more videos on dataverse.

Always w/ great videos! Thanks Reza!

Great teaching skills, Reza!

Great video. Especially Data Operations one was awesome...Thank you

Hi Reza, thank you for this very helpful video. What I liked a lot: 1. I was looking for a solution to send emails to users within a "multiple user" column. Thanks for your awesome explanation of how doing so. 2. Including the in depth view on the JSON queries is awesome. This helped me tremendously to understand and use this to my advantage 3. Potential Video Idea: What are the options we flow creators have, to ensure data protection of the users of the flow? This is the final thing I'm struggling with in my workflow: In the very last step, my workflow grabs a file from a SharePoint library. The file got uploaded by a random user, initially triggering the workflow. Once all approvals are in, the file is sent automatically via a Send an Email (V2) action to a person in HR. Unfortunately, this email appears in my outlook mailbox within "sent items" including the attachment. --> question is: what are my options to keep the file secure and hidden from myself? Using service accounts? Deleting the email from my sent items folder? Or can the flow be initialized under another user in the first place? I fear that this will be the end of my otherwise very helpful workflow :(

Wow, that is very comprehensive, thank you!

Can I just say, this is an excellent tutorial!

Just an Amazing Video! Thank you!

May you share me the study part from Beginner to Pro Power Apps ? source and material please. All your video is amazing and clear.

I started watching all your videos…it really helped me so much in learning power apps and flows…I would like to request you to show how can we log history for multiple approves…I mean like parallel approvera

Is there a way to do an Approval flow where the person who creates the item can select the approves who need to review. We have a scenario where a user has to submit a User Access Request (UAR). The UAR needs to be approved by his/her/their supervisor and possibly their Unit Chief and possibly up to 1 or more additional Unit Chiefs. Some users need to get access to a different unit's laboratory space and that required separate approvals for each. We are looking for a way to automate this process and NOT have to get wet signatures on a form. The issue I am having with the process you show here is sometimes there are alternate people who ACT as Unit Chiefs, temporarily but only for a week or two and I don't want to have to constantly update names in the list. Is there a way using Power Automate to allow the user to edit the flow in process and SELCT the name of the approver. .This was possible in SharePoint 2010 and 2013 Approval flows.

Nice video Reza. Thanks 😊

Reza, as others have said your videos are great. You are direct and straight to the point. Very easy to follow. Quick question, could you share how you inserted emojis in the flow? I would like to learn how to do this. Thanks.

Hello Reza, Thank you for all you do ❤ I'm trying to build a Dynamic Approval flow, Similar to the one you've shown here. However, My flow filter in Get items has 3 filters" (Department eq 'DEPARTMENT VALUE') and (Country eq 'COUNTRY VALUE') and (RiskLevel eq 'RISK LEVEL VALUE') ". When i test the flow, the slow doesnt get inside the "Apply to each" action and gives an error at "Start and wait for approval"(There's an error in your flow preventing the creation of Approvals. Use the link below to learn more about the errors with your flow and/or environment configuration.) I'm unsure what I'm doing wrong. (I'm trying Build an approval flow based on 3 filters criteria, The approval goes to a person based on what country, Department and Risk level the user chooses) Please advise 😅

Thank you for sharing this; it is quite helpful.

Hi Reza, thank you for all your videos - they are a guiding light to get going. I've tried copying this approval flow using the current Power Automate and it keeps inserting for each loops everywhere (when in your video they do not appear). The nested loops keep complaining and failing when I try to implement the dynamic people picker, towards the end of the video (the Select, Join and Set functions). Any advice on how to stop these loops?

Very good explanation. thank you so much.

This helps me a lot. Next is how to log each approval. Let's say I have only one approval step. But, 'all must approve'. I need to log each approval date for each approver. It will go into a note column in my SP list. How do I do this? Or can you recommend a different solution? Basically, I'm building an approval process. Multi step. Your solution here works if each step has one approver. But I don't think it works if a step has more than one. TIA Reza

@Reza - Thanks again for another great video! I had one question regarding the dynamic approvers using the 'get department' approver list with the people picker column. On the step where you use the 'select' operator and do the 'map' to the approvers email - when I try this, it adds another apply to each loop. In your video it did not. I continue with your steps but then i get an error "the result of the evaluation of 'for each' expression'@items('Apply_to_each')' is a type of 'Object'. The result must be a valid array." Any thoughts on what could be causing this?

Amazing! As always! Thanks

Hi Reza, Thank you for this video. This scenario shows only one approval (first to respond). In the department share point list, how do I put in 2 or 3 email addresses. The first approval needs to be approved before it moves to the second approval and then the third.

Woww!! Incredible Reza!!

Dear Reza, many thanks for your fantastic approvals cookbook serie! I have a question on the dynamic approvers... taking your SharePoint list as example, is it possible to select both Marketing and Finance as department. I have enabled multiple choices on the list, but I am not succesful in creating the Power Automate approval. thanks for your help as always! :)

Great series Reza, thanks so much for taking the time to prepare these very useful videos. I am trying to replicate the dynamic approvers scenario in my own environment but every time I try to insert the Select action on the Approver Email entity the step is wrapped in a second "Apply to Each" loop. This fails when run because the output from the select is an object and it needs to be an array. I've followed your steps a dozen times and checked that the output from "Get Items" has the expected values (the Approvers are in an array, and each one has a single Email entity), but I'm at a loss why the flow editor keeps putting an Apply to Each loop around the Select action. I've searched online for several hours and I'm about to give up on Power Automate altogether. Any pointers?

Hi Reza, Thank you for creating this tutorial. It really helped me understand the concepts and build an automated flow. I would like to ask you: What is the type of "Approval Comments" Column in your SharePoint List. I enabled versioning on my SharePoint list, created a Column of type: "Multiple lines of text" and checked "Append changes to existing text" to ensure the history is logged correctly. All comments are logged correctly EXCEPT that there is my name and date appearing before each comment automatcially. Also, I can see "View Entries" link to see the history instead of the comments directly in SharePoint. Can you kindly advice: 1. How did you setup your "Approval Comments" column in SharePoint List 2. How can I make sure that the comments are directly displayed in "Approval Comments" column, instead of "View Entries" hyperlink Thank you for your extended support.

very well explained - thank you Reza

Thank you Reza! Your videos are very helpful. I have looked through the approval videos and I cannot seem to find out how to prevent the "pending" status from updating to "approved" until all approvers have responded... I am working from a document library approval flow.

I followed the steps to pull data from the Approver list using the people-picker column. I even tried replacing the item()?['Email'] in the Select Variable. The flow runs fine up until the Start and Wait for an Approval. I left the "varApprovers" variable in the Assigned to field, but it the error message I'm getting is "BadRequest. The request failed. Error code: 'InvalidApprovalCreateRequestAssignedToMissing'. Error Message: 'Required field 'assignedTo' is missing or empty.'." What am I missing?

Great video Reza, so helpful - however I have a question that was not answered here, maybe you have in another video? How can we configure the approvers from the SharePoint Site owners group?

Reza instead of sending all tasks to everyone at a time, how do we send a task to the first person in the approval and if he approves then the second and so as to the last in the approval column. Then I will update the outcome and decide if the workflow should continue or not.

Hi Reza, thank you so much for this video, what do I need to do if I want to the form to automatically send to the email that the user entered in the list for approval? (In my list, I setup a column for the user to input their manager's email). I appreciate your help.

Thank you! This is more closer to my requirement..Just guide me on how to allow approver to add data in that form(edit access for few extra fields) currently it is only view access..when he got link of form by email along with approve & reject button..

thank you for your effort , what if I need to select more than one category (multi-select )

Thoroughly enjoyed your videos @Reza--very informative and well-presented. Following the steps for the people picker (also on 21:45), and not erroring out (yay!), but somehow only getting the first person in the people picker column. Wondering what I'm doing wrong and if anyone else has run into this behavior.

Thx Raza for you continuous great effort but I have a question if you could explain for us how you create the assigned to column in the Help disk list.

Hi Reza, I have a question for you. Is there a way to retrieve a people picker column value after it was entered by a pre-approval person. So the login I have in mind is like this - Request is created in the Microsoft list > A Pre-Approver (Always remains the same) will receive an email, after his/her review they go into the list and assign it to his team members by picking from the people picker column inside the same list > The Pre-Approver Approves the request > Then the flow retrieves the people picker person's email address and send it for his approval> and so and so forth. No second list used in this process. How would the flow look like? do I need to the get items card and filter query ? Sorry if its too long of a request. Thank you for reading.

Now that we have dynamic approvers, how do we add sequential worflow. Lets say when the first approver rejects, the next approver should not get an approval request. I created one flow but it brings this error: The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@variables('varDepartmentalApprovers')' is of type 'String'. The result must be a valid array.

Thanks, Very professional.

Good & Easily understandable

This is Awsome and great learning, please let me know where I have to begin with for mastering power Automation

Hi, Reza! This is a great video. The approval process demonstrated in the video is exactly what I’m look for! I followed all your steps to create a glow but having an error in testing. The ‘Start and wait for an approval’ step has an error message: BadRequest. The request failed. Error code: ‘InvalidApprpvalCreateRequestAssignedToMissing’. Error Message: ‘Required field ‘assignedTo’ is missing or empty’. Could you please help figure out this problem? Thank you so much!

Amazing video thank you. What about creating this flow for a document library? AUtomate asks to select a List (*), but what if I want to set it up for the library and not the list?

Hi Reza, Thank you so much for the great video!! However, im not sure why when the 2nd approver responded, it doesnt reflect the name of both approver on the sharepoint list. When the first approval approves, it will reflect nicely onto sharepoint list. But when the 2nd approver approves, it becomes "Approved By: Approve" Please kindly advice. Thank you!!

Great video! You mention that Approvers (multi-person) vs Approvers Text is easier to maintain but you reference 'Approvers Text' in the Flow. Why? I ask because I get a 'GraphLookUpRequestFailedError' in my Start and wait for approval when I attempt to reference the Approvers (multi-person) column instead.

Hi Reza, When I'm trying to use the people column. My apply to each(Select+Join+Set Variable) is working completely fine if my SL cell has 1 person mentioned. However, when i allow multiple people(Lets say 2), The apply to each starts getting Null values in Select, Join and set variable actions and gives me an error: BadRequest. The request failed. Error code: 'InvalidApprovalCreateRequestAssignedToMissing'. Error Message: 'Required field 'assignedTo' is missing or empty.'. Any idea why is this happening?

Hi Reza. First of all, thank you very much for your videos, I have never seen such detailed intricacy in any tutorial I have encountered. I praise your great work and clear explanation throughout all your videos and tutorials. Simply wonderful! I have been able to create the same concept in your video, but through a document library to have dynamically grabbed approvers from a list I created in my SharePoint site. I have tested the workflow and it triggers correctly, with the status (Draft, Approved, Rejected) correctly marking, and the flow is running successfully when tested. However, I have noticed that the approval request notification reaches the approver multiple times, even after the approval or rejection is completed. Also, I noticed that, after the document is approved or rejected, its status returns to "Draft" in the sharepoint library to which this workflow is connected. Any idea on why this is the case? I see check marks (marking that the work ran successfully) as well. Your advice would be greatly supported.

Thanks a lot. Is there anyway to reassign the approbation if the person receving is not the appropriate one ? I've seen a "Follow up" Button. but it does nothing. Do you know its purpose ?

Great tutorial!I have a question, why does the assigned to column in the sharepoint list stay blank?

Hi, first of all: great content in your cookbook, it's been a great help for me! I still have this question: do you have an example of dynamic approvers in this situation: Approver 1 approves, Approver 2 approvers, Approver 3 rejects => creator gets notification of rejection of Approver 3 and modifies the file => After reactivating the flow, Approver 1 and 2 does NOT get notification, only Approver 3... Txs for the reaction(s)

Hi, Rena! I have a question regarding the dynamic approves. How to get the approves emails from the Department approver list when a user picked multiple departments, especially more than five departments are selected ? The ‘Filter Query’ only has ‘Equal’ and ‘Start with’ foyers, it doesn’t have a ‘Contain’ filter. Thank you in advance!

Hi Reza.. thank you for this wonderful series on approvals.. am just stuck on how to add emoji while updating comments back to list 😒😒

Thank you so much for making this video. How can we handle the scenario that the flow has been running halfway, waiting for approver to approve but we changed the approver from A to B?

Is it possible to have approval matrix (Departments list) with 3 columns that will determine the approver? For example: 1. Department 2. Request type 3. Urgency - and have the approver assigned in column 4 so correct person will determined based on the combination of those 3 first columns?

Dear Reza, I have built my process exactly as yours, except that I had to put between [ ] brackets to solve the error 'is of type 'Object'. The result must be a valid array.' The variable can find the 3 approvers I have in a list, but the approval is only sent to one of them. And it is sent always for the approver I inserted later in the list. What am I doing wrong? Thanks for your attention, you are the best teacher.

How do you add Emoji ? just copy paste . .where do get all the emoji.

hi sir , first of all such a great video. i have an question , my select trigger applying two arrays one on From :Approvers and second on Map: Approvers Email could you please help me why is taking it.

Hey Reza, how do you determine whether using a list or document library? I want to set up dynamic approval workflows for construction submittals but am unsure where to start from a list/library perspective.

Hi Reza, I'm not sure why category value doesn't exist on my dynamic values... Is there another name that it could be captured on?

Hello Reza, great video. My flow gets stock on the approval process. My parent share point list was created with power apps. And my child list has two columns (section,approvers emails) each column has 5 entries. But when I create the lookup column into my parent list it only shows the column names and not the 5 entries I have for the sections and approvers email. I’m not sure if it has to do with the fact that my parent list is a powerapps form. When I run the flow it gets stock on the approval process (assigned to) field. Power automate says the assigned to field is empty although I add the Varapprovers link. I think the issue has to do with the fact that the parent list is not receiving the emails I have in the child list approvers email column . Please let me know if you have any recommendations. Thank you.

Hi Tried to follow your step by step instructions but the flow is running in loop n time how should i stop that and make it run only once?

What if you needed to lookup approves based on more than one value in the title column? Let's say the user is allowed to choose any combination of departments so that it may be Marketing and IT. So, you would have to return all emails from both departments. How would that change the flow?

Great tutorial! Thank you for this. I just have some questions regarding a scenario where there were multiple departments that needs to address the ticket and needs approval of each department. How is that possible?

Thank you, definitely your videos save a lot of time! I am working on my version of these ideas and have a doubt: In a two parallel approval process flow in TEAMS, if one branch reject the document, left some comments or suggestions in the document assessed. Once rejected, I would like to edit the document that triggered the flow when it was moved into Files tab in TEAMS. When edition is completed in TEAMS, how can I restart the approval flow but only with the person/branch, that initially rejected it? Thank you for your ideas! Greetings from Argentina!

Great video, simple and very clear explain, how do you use emoji? What’s keys to input emoji?

Hi Reza. I have a question. On 6mins 41s of your video, how did you add multiple names under the Approvers column? I have been trying to add under this column using “person or group” type and it could only allow me to add 1 name. Would really appreciate your help 🙏🏻 You’ve helped me alot for the rest of your vid’s man.

Hi Reza, In 21:34, after switch to text mode, 1. I insert dynamic content "email", 2. and it auto add another apply to each. Doesnt seem work as what you did. Is this trick still applicable?

Thanks a lot Reza for such a nice video.Could you let us know what would be the best approach for approval if we need to create purchase order requests in Bulk? Like, all purchase order details are in a file and all purchase orders listed in a file should go for approval one by one.

Thanks for this helpful video! how would one go about grabbing the approvers from the department list if they selected multiple departments? I have a form with multiple-choice options for affected departments and was wondering if it's a way to query the department list for multiple selections.

Reza, side question. My approval action sometimes doesn't capture the SharePoint form trigger Person field's email address. Have you ever encountered this? I went to review the flow the approval "assigned to" output was empty: "[]". Once I restart the flow, the issue fix. This is bugging me as I have to go and restart the flow every time. I have posted this issue in the community forum but no one can answer this :(.

Hi Reza, Thank you for this very helpful video. I have a question. Is it possible to let the approvers to approve one by one? once the first approver approved, then go to the second approver

Amazing video Raza! Thank you! A bit off-topic but is there a way an approver can recall/cancel their approval after approving the item, let’s say within 1 hour (let’s suppose in case something changes)?

Hi Reza, i like the last part on "select" is there a way how to get the UPN from a people picker... keep in mind that not all users have emails

Hi Reza, i follow ovreall the step but when try the flow error always occur on the get items parts, as I mention the category as "gate 1", the eror mention "The expression "Title eq "Gate1" is not valid. Creating query failed." Has checked the on the list as well it exactly same name ("Gate1) both on the approval list and the form list, any idea why? Great video afterall!

Great video! Very clear explanation! Question for you, what if all the approvers must approve the item?

Thanks

Hi Reza : Thank you for the great video - I am following your example but I am stuck @ 8:30 , I don't see anything start with "Category" on Dynamic content to select. Can you guess what could be the reason.

Hi Reza, Really Great tutorial. Thanks. is it possible to update item (approver comments, assigned to .etc ) without changing version of a document in Dynamic sequential document approval process in SharePoint library.

when i go for "Select" action and choose approver email flow creates another ApplytoEach section...why is it so ?

Hi Reza, QUESTION: Where can I find the link for your video on how to create a Dynamic Approvers Sharepoint Group list that you mention in your Custom Approvals Power Automate (Library) video. Could you send me the link please?

Thanks for all of your videos. Request your help to resolve the issue: In case of dynamic approvers, my flow requires any one approval, but I want to notify the other approvers that the task is picked up and its in progress. Any directions, will be of great help.

Amazing video as always :) Is there any tutorial for creating the Sharepoint list as you have created, as I am new to the Sharepoint ?

Hi Reza, my flow has multi-line column 'with append text to the exist text' all works fine , but when I try to copy the items of my list to anothers list just one line is copied , do you know why is hapenning?

thank you, you're a master!

Hi Reza. I was trying to add dynamic approvers to document approval process using process from your other video "Power Automate Document Approval workflow for SharePoint". I'm referring to 22:00 of this video. When I select Select feature and put Approvers into From field it creates a loop, just as in your vide. But, when then I put Approvers email into Map field it creates another sub loop for some reason. Any ideas why this can happen?

Thanks, Reza. I'm having an issue with the select operation when getting the email from the array. It's outputting null even though the input information looks correct. The flow runs without error but doesn't finish down the pipe due to the missing email I'm trying to retrieve.

Hi, Your videos are really good and are helping me quite a lot. However I'm facing an issue with the persons column. The sharepoint keeps ordering the names by ID rather than keep the order I enter the users. Have you come across this issue? Do you have sugestion/work around? thanks,

Thanks, Reza.