Dynamic Approvals in Power Automate | SharePoint List based Approval Tutorial

[@MrClux4]

Reza, your videos keep getting better and better! I will be adding this to my faculty appointment flow first thing tomorrow!! Thanks for another great video. Cheers,

[@RezaDorrani]

So happy to hear that! Thanks Steven

[@joeycummins6983]

This wasn’t exactly what I was looking for, but gave me a lightbulb moment with the issue I was stuck on. Thank you!!!!

[@RezaDorrani]

Glad it helped!

[@johnscraper6312]

I have been looking for something like that for over a year now! My Power Automate confidence increased all of a sudden. Thank you, Reza!!

[@RezaDorrani]

Awesome! Thanks John.

[@Artiqx]

Reza, the speed of your tutorials are just excellent. Love the density of information and how you respect time of your viewers!

[@RezaDorrani]

Glad to hear the feedback. Thank You so much.

[@ActionHero29]

yeah but its way too fast for a beginner...

[@TheHub047]

@@ActionHero29 I was watching with speed 0.25 and still got lost 😆

[@imran002ali]

Hi Reza, not sure how I've missed this video, but, I am speechless, very detailed oriented and one of the complex but efficient Flow, always, appreciate your work 👍

[@RezaDorrani]

Many thanks!

[@imran002ali]

@@RezaDorrani , you are welcome!!

[@merristenzel7711]

This is Perfect! I've been searching through your videos for this solution! THANK YOU!!

[@RezaDorrani]

You're most welcome!

[@TheEdmundNetwork]

Thank you Reza, you just saved my £450. I can't thank you enough.

[@RezaDorrani]

You are most welcome!

[@ArohShukla]

Another fabulous video. Your video shows how expressions are so important to Power Automate and minimize the API calls.

[@RezaDorrani]

Thanks Aroh! Expressions are the 💓 of flows.

[@meaganwest6732]

Once again, you're the best out there. Thanks for this!

[@RezaDorrani]

Wow, thanks!

[@miguelchaves2065]

Thanks for another video! your tutorials are excellent!

[@RezaDorrani]

Most welcome

[@william2053]

Awesome! Thanks for the video Reza!!!

[@RezaDorrani]

Thanks Will

[@mdhidayat5706]

Thank you Reza! Finally got a a change to apply this to a problem at work today.

[@RezaDorrani]

Great 👍

[@clabpr79]

Saved to my Favorites videos, excellent source of information.

[@RezaDorrani]

Glad it was helpful!

[@ChuckHolland-i4b]

Brilliant! I'm learning so much!

[@RezaDorrani]

Great to hear!

[@Przemanos]

Fantastic movie Reza. Much appreciated!

[@RezaDorrani]

Most welcome

[@ramonillarramendi3191]

Wonderful!! Thanks for the clear explanation.

[@RezaDorrani]

You are most welcome

[@jaggyjut]

Awesome. Great idea on approval matrix.😀

[@RezaDorrani]

The idea came about while working on last week’s approval video :)

[@jaggyjut]

@@RezaDorrani hope we can add require more info option and close the loop please. That will be great help. Thank you again for the tutorials 😀

[@RezaDorrani]

@@jaggyjut I have done around 17 videos now on approvals covering most bases. Time to take a break from approval videos.

[@dingersu]

Sometimes I want to hit the Like-Button more than once 👍

[@RezaDorrani]

Thanks so much! I’ll take that as more than 1 like :)

[@karun036]

Thank you video was very helpful. Although I am a first-time creater so had to switch to a .50 spread. But overall it was very informative.

[@RezaDorrani]

Thanks Arun. This video is definitely more advanced. I have an approvals playlist that has many videos which begin with basics and have more advanced scenarios

[@cmacdhon]

How on earth did you figure this out? I wouldn't have been able to get past the first step 😒. Thank you so much Reza. I can always count you to get me over any hurdle I am faced with.

[@RezaDorrani]

Let's count on each other and keep sharing knowledge :)

[@hermansonon7776]

THANK YOU for your tutorials

[@RezaDorrani]

Glad you like them!

[@subuser2901]

At around 5:00 minutes in, when creating the ApprovalInfo Compose, I do not have "value" available as a Dynamic Expression. What am I missing?

[@RezaDorrani]

I'm not sure why that would be the case.

[@deanbowen658]

At 3:33, I can add the Site Address but when I try to select the List Name, only the Matrix is available, no other lists appear in the dropdown menu. It looks like you skipped the part on how you added the Service Desk list.

[@RezaDorrani]

I picked my site and then the list within it. I skipped through because that is a standard technique to connect to a list that I have shown in most of my other videos. Check if your site has any lists. It will only show the ones available on your site.

[@deanbowen658]

@@RezaDorrani Thanks Reza.

[@Finix.W]

That was the point I stucked at. You need to copy the list that Reza shows in this video and customised it to fit your need. He didn't put the tutorial video link that includes the list making in the description. So this tutorial will never be 100% fit for newbies. Experienced people usually "think" that you should know how to do it, but they ignore the amount of debugging time you have to do to get to the same point as them. Sometimes a difference in one property can cause the whole programme to crash, but that's not something they need to think about. When you have a problem they usually don't waste their time answering it, but instead send you to the official channels to ask questions, because they are just throwing in the towel. This is one of the reasons why this video gets lots of views but so few likes.

[@deanbowen658]

@@Finix.W Thanks for explaining. I'll keep trying.

[@RezaDorrani]

@@Finix.W Thank You for categorizing as they and them. Video has few likes? Are you sure? Does video title state this is for beginners? Video description has link to download entire flow. I think you are highly mistaken of my motives as a creator. If you feel this video is for driving views then please dislike it and do not watch my videos. You have a choice and no one is forcing you.

[@e-k9174]

what happened exactly at 9:07, where did you open the condition? and why are you skipping steps? like the ID and Title, we have many IDs and many Title, which one to choose?

[@e-k9174]

One more Thing, in the condition of the Manager Approval, how did it change from "outputs" to "Manager.." ??

[@e-k9174]

Like in 7:56

[@RezaDorrani]

Prior to 9:07 - every step in flow is built out. Skipping which steps? I did not want to keep showing the same action of updating the item over and over again. Video description has link to download the entire workflow.

[@oluwatobiyusuf]

Thanks for another great video

[@RezaDorrani]

Thanks for watching!

[@vinayayinapurapu]

Power Packed.. with full of FUNtastic Demos..

[@RezaDorrani]

👍

[@hansschiettekat2501]

Hi Reza, also my gratitude for your compressed to the point video. Only I can't get this working as instructed I used the compose action to get the first() records from the approvers list filtered result. After this step I do the select to extract the email addresses but here I get an BadRequest error The 'from' property value in the 'select' action inputs is of type 'Object', The value must be an array. I reviewed your video several times but I can't see the difference between your instructions and my implementation.

[@RezaDorrani]

Video description has link to download flow.

[@RezaDorrani]

@@hansschiettekat2501 No idea since Ive shared the entire flow that works for me. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@dlhvid9072]

Terrific walk-thru. I do have a question on Notification Details. Manager Approvals are all set to No. Unfortunately, the Main Approvers aren't receiving any details regarding the approval. How would you suggest we add details when using Create an Approval, and Wait for an Approval? Thanks again for a terrific example!

[@RezaDorrani]

Video description has link to download sample flows. I have not come across the mentioned issue and hence not sure what’s the reason for your issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@DGriffy0400]

Hi Reza, fantastic video. I am stuck on 12:02. I am trying to add more details to the Create a request task that the Main approvers will see. However my JSON skills are not great. Is there a way to add multiple lines of details? Thanks for all the support you have given so far "requestor": "@{outputs('Update_item_5')?['body/Author/Email']}", "details": " Name of staff: @{outputs('Update_item_5')?['body/NameofTraveller']} ", "details": " Destination: @{outputs('Update_item_5')?['body/Destination']} ", "details": " Departure date: @{outputs('Update_item_5')?['body/TravelDate_x0028_Departure_x0029']} ", "details": " Return date: @{outputs('Update_item_5')?['body/TravelDate_x0028_Return_x0029_']} ",

[@RezaDorrani]

Debugging formulas here on chat is not a good option. I believe approval details supports markdown language. Check documentation on approval markdown. Alternatively, I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@shashikanthduddukuri6228]

Thanks Reza for the great video 👍🏻

[@RezaDorrani]

Your most welcome! Thanks for watching.

[@akshayasreedhar]

@Reza- Thanks for this video!! at 4:28 secs, I do not get the Request type Value in the dynamic content type!! Please help

[@RezaDorrani]

Video description has link to download sample flow. Give that a try.

[@lindseyfreeland8742]

Very helpful -- only additional step I need for my purposes is to make the dynamic approvers also sequential. So for example: at 16:00 for Computer Issue -- is there a way to make the approval flow send to the first approver in the array first and then, only once approved by the first, to the second for approval?

[@RezaDorrani]

kzbin.info/www/bejne/nZPCd4ibh8-anZY

[@nicoleq146]

Hi Reza, I made it all the way to the part where the outcome of final approval does not contain reject > If yes (13:20). The issue I am having is the Documents folder where my SOPs are housed is not available to choose. Only "lists" are. Where it usually says "List or Library Name" it just says "List Name" and I cannot see/select the "Documents" folder at all. Am I not able to view both the documents and lists under the drive at the same time?

[@RezaDorrani]

Looks like you are trying file property updates and not list item. There is an update file properties action for that.

[@nicoleq146]

@@RezaDorrani Thanks Reza. When I select “Update file properties” instead, I am able to select the file, however it also asks me for the id. Do I need to add a step to pull this info? Or just select Id from the dynamic content menu? Also, the approval status is not an option to update.

[@RezaDorrani]

@@nicoleq146 I will have to look at your flow in action or try it out to provide guidance. I will recommend posting your query with screenshots on the forums at powerusers.microsoft.com/

[@tayongshakes8396]

Reza you are the best

[@RezaDorrani]

Thanks

[@richardmccoy580]

Hi Reza, thank you, your videos are very clear! I am working with document library rather than a list and it seems to work well. One thing however - for documents that do not require approval, I would like to set the content approval status to approved instead of leaving them in draft status. I've tried doing this by setting content approval status to 'Submit', immediately followed by 'Approve', and it does change the status to submit, but will not change to approve. When I test the flow, I get a bad gateway error for the final step to change to approve. Any help would be really appreciated? Thanks

[@RezaDorrani]

Welcome! I’m not sure how to do that as I would have to try it out to know the options. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@coursesdekho5702]

Thank you so much for this video!

[@RezaDorrani]

You’re most welcome

[@juliaborgespereira2424]

Amazing!!!

[@RezaDorrani]

Thanks

[@Matt-pt3vq]

i don't understand ApprovalCreationInput bit at 11:46, do i just type that out or is that something else i need to do?

[@RezaDorrani]

You need to type that

[@meaganwest6732]

Reza-- thank you for this video. I have a flow set up just like this, but in the scenario where you submitted for 'Computer Issue' and the approval request was sent to James and Sara simultaneously, I need to record James’ response inside the matrix list right when he selects ‘Approve’ or ‘Reject’… because Sara (and several others) may take several days to respond & my customer needs to be able to see 'live' who has responded to determine bottle necks in the approval process. I can't get this to work, do you have any suggestions?

[@RezaDorrani]

For that you would have to query Dataverse approval tables which would require premium licensing and you would need to understand how the tables maintain approval data. I do not have any video references on this hence providing options.

[@AndrewNumptyPants]

@3:38 you have an approval status column, that doesn't seem to be available to me?

[@RezaDorrani]

Thats a column of type Choice. You would need to create that.

[@AndrewNumptyPants]

@@RezaDorrani yeah that's what I ended up doing - Google was saying something about one being available by default -__-

[@RezaDorrani]

@@AndrewNumptyPants That is if you turn on content approval. Thats a different concept.

[@AndrewNumptyPants]

@@RezaDorrani yeah I couldn't find it so just made choices. I'm 13mins in now but I'm wondering how easy this would be to implement a group form instead

[@RezaDorrani]

@@AndrewNumptyPants Sorry but what’s a group form?

[@shaikhsameer8141]

hi reza nice video

[@RezaDorrani]

Thanks!

[@chinweonwuemeli5273]

Thanks Reza. Is it possible to create an approval notification that would be timed based on certain dynamic responses, probably from previous processes in the flow?

[@RezaDorrani]

You can always check outcome of approval action and accordingly send notifications. I have done a video on sending email reminders for approvers. Check that video. It may give some ideas

[@chinweonwuemeli5273]

@@RezaDorrani okay, I'll check out the email reminders, I think that should work. I'll update you, thanks so much.

[@FabianoSchimidt]

Thanks Reza, this is amazing! I was wondering if it is possible to create an approval matrix with additional columns representing instances of extra approvals depending on a criterion such as cost, for example. In my scenario, I have a list of requests and a local area approver who will always approve everything. The requester's immediate supervisor must also approve if the cost is more than USD 3,000. In addition, I need to add the area director as an approver if the cost is more than USD 5,000 OR the area VP if the cost is more than USD 10,000. What do you think, Reza? It's a good suggestion for an upcoming video!

[@RezaDorrani]

Possible it is. My rule to making videos is set - “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.”

[@FabianoSchimidt]

@@RezaDorrani Deal! 🤝

[@srikandanarthanari5667]

Hi good language pronounciation. Ease to understand

[@RezaDorrani]

Thanks

[@willtee3640]

Do you have a tutorial for different user request will get different PIC to approve? For example, 1. User from HR have a request, and the request will sent to the HR manager for approval. 2. User from account department have a request, and the request will sent to the account manager for approval. Can the above request be done in 1 sharepoint form? Where I don't have to create a sharepoint for HR or account.

[@RezaDorrani]

Possible. I have done 18 approval based videos covering various scenarios. They are all in the approvals playlist on my channel.

[@jesgardel]

Good job Reza!!! I'm very happy to find your videos. It will help me a lot. I have a problem with this flow (and others) because I want to use sharepoint as document library, but the flow fails in the step at 6:30. I can not find the option of Approval Statul Value on UPDATE ITEM step. I guess there's something with library definition that it's different than lists.

[@RezaDorrani]

Should not be the case. Try creating a column with different name like "Approval Status Info" and check if that shows up. I will also recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/

[@sundrapillay6668]

Thanks Reza excellent

[@RezaDorrani]

You are most welcome Sundra

[@ChelsInNicosWorld]

Hi Reza. Thank you so much for this. I've recreated this flow, but my company does not have managers listed in the system, so the Get Manager step failed. I attempted to add another column to my matrix with the manager's names and added another Select step in the Get Manager place. But, my flow is failing there stating it is pulling back an object and not an array. My From: is outputs('ApprovalInfo')['Manager'] - and my Map is item()?['Email']. Any thoughts?

[@RezaDorrani]

Looks fine to me. Difficult to catch the issue here on chat. I would recommend posting your issue with screenshots on the forums powerusers.microsoft.com

[@samanthahamilton9305]

@@RezaDorrani mine is doing this too - it says The 'from' property value in the 'select' action inputs is of type 'Object'. The value must be an array.

[@RezaDorrani]

@@samanthahamilton9305 I have not come across this issue hence difficult to guess what the fix is. Best to post on forums. Video description has link to download sample app as well.

[@Borokan]

Hi Chelsea, I had this issue and was able to get it working by removing the expression: outputs('ApprovalInfo')['Manager'] > Then typing in the expression box to keep it on screen, then selecting dynamic content and selecting outputs ApprovalInfo > Outputs from dynamic content instead. make sure to remove the character you typed previously This appears to be exactly the same expression, however caused me to get past this error when I ran the flow Clearly some bug in power automate

[@aaaaa601]

Always good thks

[@RezaDorrani]

Thank you

[@lorizambos7579]

Hi Reza. Thank you so much. This video is great. I followed the video to time stamp 6:44, The question I have is where would I skip to in the video if I do not need managers approval?

[@RezaDorrani]

Video allows a setting to turn off need for manager approval + video description has link to download entire flow.

[@KayeMercene]

Hi Reza, This is close to what I'm looking for! Is there a way to remove the "Approve" and "Reject" buttons from the email to encourage the approver to view the document directly in the library instead?

[@RezaDorrani]

You can turn off notifications from approval action and send your own notification.

[@KayeMercene]

@@RezaDorrani Thanks Reza for the prompt response, I appreciate it. How about if the Approval Type in the list is sequential. Will I have to create another condition and create an action which separates the join?

[@RezaDorrani]

@KayeMercene Probably yes. Not something I have tried though.

[@haikel173]

Hi Raza, your videos help us a lot, thank you. I have one question how to create single approval for multiple SharePoint List items? If there are multiple items added to SharePoint List, so it trigger only one approval?

[@RezaDorrani]

Approvals are per item.

[@kumarvelu2920]

Thank you Reza. I have a question if the person could not edit with security condition update through list settings permission. It works only for edit item doesn't update or change. But if the selected the edit grid view they have option to edit. Kindly suggest how it can security

[@RezaDorrani]

I did not understand the question, but I am guessing you are asking about item security. I have done a video on setting item permissions for SharePoint which may help.

[@stevemcc7208]

Very helpful! Thanks. I have a question??? HOw could I create a pin to allow certain users to see a view/list?

[@RezaDorrani]

The question is more specific to SharePoint. I don't believe there is any pinning concept. You can always create public views which users can select in the view selector.

[@1974andyowe]

Hi Reza, thank you very much for this however I need help regarding the ApprovalCreationInput on Create an Approval. I'm getting a json error asking me to to enter a valid json. I have copied as per your video however having this error. Please help...I'm so close!!! Cheers, Andrew

[@RezaDorrani]

Video has link to download sample flow. You can copy the JSON from there.

[@1974andyowe]

@@RezaDorrani Hi Raz, got it thanks. Another error...I'm getting 4 Errors all pretty much the same on Approval Required, Main Approval, Condition 3 & Create an Approval. These are "fix unsupported parameter function expressions(s) for the input parameters(s) of operation 'Approval_Required'. Only string literals are supported. I know this was be something simple but I'm learning all things Power at the moment. Also happy to donate with you supporting. Cheers, Andrew

[@RezaDorrani]

@@1974andyowe I recommend posting your issue with screenshots on forums at powerusers.microsoft.com/

[@evangelostsantilas9]

Hi Reza..Cngrats for the perfect Video...I d like to ask if its possible to add a link to the item at the Approval Message? I saw that in your presentation the link exist but in my flow does no appear

[@RezaDorrani]

Video description has link to download sample flows. You can check the code and logic in it.

[@calebessilva]

You are awesome

[@RezaDorrani]

Thanks :)

[@alfredmuzindemcclevers5279]

Hi Reza, Thank you for the powerful content. I tried to do the same steps. However the flow is failing to pick the yes/no columns as enabled , its giving a false output. May you please assist

[@RezaDorrani]

Video description has link to download the sample flow. As for your issue, 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

[@alfredmuzindemcclevers5279]

@@RezaDorrani thanks. Let me do that

[@emiparanoid]

Hi Reza! this video is amazing, is helping me a lot with a approval flow I need to implement, my only question would be, if I have let's say, 8 approvers in the list and I want to finish the flow when I have 5 approvals or 5 rejects without the need of go to the rest of them, how can that be implemented? or is not possible and need to go through all the approvers? thanks in advance

[@RezaDorrani]

Most welcome! Currently, there is no such option to stop the approval.

[@emiparanoid]

@@RezaDorrani Ok got it, thanks for your response!

[@cvkealey]

Fantastic! Is the schema for the "Create an approval" input defined somewhere, or did you reverse engineer it by looking at flow run data? I checked the documentation for the Approvals connector, but it's not terribly helpful for these more advanced situations.

[@RezaDorrani]

Reverse engineered (Peek code). I wish there was better documentation on this. I feel this is an extremely powerful feature since it makes the approval pattern dynamic. I'm sure this can be done for the custom approval types as well.

[@xw9279]

Hi Reza, is it possible we use this Approval Matrix to process the "News Page Approval"? Pages are in a library, not a list so I'm not sure if they are the same as your tutorial.

[@RezaDorrani]

Possible. Same concept can be applied to any other scenario. There is a trigger for when a file is added in a library and you could point to the Pages library.

[@xw9279]

@@RezaDorrani Thanks, I'm going to give it a try.

[@juandavila4035]

Great video. I want to do the same but in dataverse table, is it possible?

[@RezaDorrani]

Possible. The configuration list can be any data source of your choice.

[@wademiller3103]

Hey Reza. Could you please provide a video of using a dynamic approval from a SharePoint list. I simply need to know how to have the flow look up a value in one column and return an email to use for the approval. The video is overly complicated and difficult to break down for the simple approval task. Thanks!

[@RezaDorrani]

This is a complex video. Check my playlist on approvals - I have several approvals videos.

[@NeerajKumar-ss7ks]

Reza, your videos always teach something new. However I have a question, lets suppose if manager reject the request in that case flow will be completed. But if someone needs to send the same request for approval, how flow will be started?

[@RezaDorrani]

I have done multiple approval videos all placed in a playlist. Restarting approvals upon rejection is complex. I have done a state machine approval workflow video. Check that one.

[@alqurandunya]

Is this possible if the First Assigned approval value is empty and the flow skip this step and goes to the second assigned approval without any error?

[@RezaDorrani]

Assigned to is a required field. I would have to try out your scenario to know the options.

[@wilmert2011]

Hi Reza, new to power automate and thank you for this wonderful video. My issue is the manager approval email is always taking the flow owner. Hence all email approvals are going to the flow owner's manager not the manager of the person who created the list item. In you demo, it works fine but I can't get mine to work. Any tips?

[@RezaDorrani]

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

[@gavinsmith5738]

Hi Reza, question. I'm trying to build a dynamic approval in PA using a matrix like yours. However the qualifying criteria is a float value (it's so that invoices of a certain amount ranges are approved by specific persons) any assistance on how the matrix or the flow should be altered too account for that?

[@RezaDorrani]

I do not have a video reference on float scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@maca072]

Is there a way to create a approval flow if all values in a column meets a criteria? For example, I have a list with a column 'status', I would like to send an approval request as soon as all items in the list contains "completed' in this column

[@RezaDorrani]

You could trigger your flow based on the condition and then start approvals in flow. I have a playlist in trigger conditions which may help.

[@violetlim6785]

This is exactly what I need

[@RezaDorrani]

Great

[@jaimearar]

Reza, thanks a lot for your videos, i have been watching a lot of them to solve my needs and it has been really useful. I have a question i don't know how hard is it or if you can guide me on a reply or recomend a video. if you can't i will understand. I would like to make a list with to columns Rol (Position) & mail (person), in order to reference the rol in my flows (power automate) and not the person. so if the person leaves or is replaced not to change mail in every single flow. thanks a lot.

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@abyal3kod201]

Hi Reza, How would you create a flow that is able to randomise pairs from 2 lists and the pairs can not be the same for the next 5 rounds. I`m really stuck on this one, if you cold offer any help I`l greatly appreciate it. Here are some details about it: 1. A meeting will consist in a Pair, that`s a 1 Specialist and 1 Team Member 2. There is a 40 nr of Specialists and 400 TM, that means a round will consist of 40 pairs 3. There is only one topic chosen per round for all pairs (2 rounds per week) 4. There is a sharepoint list of topics to be chosen from 5. All 40 Specialists are available no matter the topic. 6. Database used: Sharepoint - I was thinking the flow could start manually by selecting one of the topics from the sharepoint list. - after selecting the topic, the flow starts and pairs the teams - then the pairs with the topic get saved into the PA_Pairs sharepoint list (not sure how, I guess a row for each pair?) - then each pair gets notified about the pairing and the topic (but that`s for another flow)

[@RezaDorrani]

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

[@abyal3kod201]

@@RezaDorrani This is how I was supposed to do them, but being so new to this, it`s kinda hard to follow these steps. So if it happens that you may have the time to try doing this, I`ll leave the steps here just in case. As for the powerapps, I`ve posted twice, with no luck unfortunately. - I was thinking the flow could start manually by selecting one of the topics from the sharepoint list. Yes, the trigger of the flow can be manual or scheduled flow - after selecting the topic, the flow starts and pairs the teams You can choose a topic for pairing teams you can do the following: 1. get items for all specialists 2. get items for all team members 3. determine the length of all team members (ex. 400) 4. for each specialist (apply to each) 4.1. randomize a number between 1 and length of team members (400) 4.2. get items from the pairs, use a filter so that (Specialist ID eq current specialist ID and TeamMember ID eq randomizedID and round number larger than roundNumber-5). 4.3 if items retrieved from 4.2 do not exists proceed, otherwise randomize again (step 4.1), This guarantees that the pairing is not repeated in the last 5 rounds Note: you can have an additional list for Rounds, so that everytime this flow runs you can add a new row to the round table, this will iterate the ID so that you can find repetitions in Pairs for the past 5 rounds - then the pairs with the topic get saved into the PA_Pairs sharepoint list (not sure how, I guess a row for each pair?) 4.4. Save the pair in the Pair list (save Team Member ID and Team, you can also send additional info such as email and Name, and the topic and round number) - then each pair gets notified about the pairing and the topic (but that`s for another flow) For this other flow the trigger can be: when a new item/row is added to the Pair table... then send the email to specialist and team member notifying about the meeting

[@RezaDorrani]

@@abyal3kod201 Your use case is very specific. I don’t think I will come across a scenario where I would try this for a project. Most of my video ideas come from project work. You can try and post your query on forums at powerusers.microsoft.com You may get assistance.

[@Homero_arras]

Hey Reza, fantastic video! This process has been working great for my team, the only thing I've noticed that I can't seem to find a fix for is store in multiple approvers comments in the "Approval Comments" column. Using "response summary" doesn't give out the comment information and only spits out the latest approver. If I attempt to use "Responders comments" in the final yes box the managers comment will be overridden by the latest approver. Is there something I missed?

[@RezaDorrani]

I have done many videos on approvals and storing approval comments for multiple users. Check my approvals playlist kzbin.info/aero/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe

[@Homero_arras]

@@RezaDorrani Thanks Reza!

[@Michael-lo3ht]

Is there a way to read a list of approvers from a list? The team I'm working with to create their workflow changes. So I wanted their manager to be able to manage the list of approvers. The flow has to go through 2 different approval steps. If the originator of the request leaves they have to create a new approval request.

[@RezaDorrani]

I think this video shows reading approvers from a list

[@Michael-lo3ht]

@@RezaDorrani Thanks. Sorry. My head has been spinning lately. You have helped me a ton. I think exact scenario will work great. Thanks a million.

[@humanizamuddin692]

Hi Reza- thanks for this video. Unfortunately when Creating an Approval for the second step the ApprovalCreationInput option does not autopopulate. DO you know why this would be the case?

[@RezaDorrani]

Did you use the action "Create an Approval"? It will not show up for "Start and wait for an approval". I did mention this in the video.

[@hydyusable]

@@RezaDorrani here I'm facing the challenge that in Create an approval, it does not populate ApprovalCreationInput instead it appears all the time *Body, any hint to fix this?

[@RezaDorrani]

@@hydyusable Video description has link to download sample app.

[@salutj]

Thanks for your video, so how do you capture individual responses as they happen so the creator of the approval request knows who is not responding.

[@RezaDorrani]

Same response as your comment on another video

[@gztraveler692]

@Reza . Good morning. after i completed learning many vdo on your page. I have question. Have you vdo learning about multistep workflow?. such as when the Requestor send request to Reviewer and Reviewer is apporved and then send to Approver1 and the Approver1 need to reject and back to Rquester or Reviewer. I was not found that vdo. sorry for bother you. I'm beginner in Power app and Power automate. thank you so much.

[@RezaDorrani]

kzbin.info/www/bejne/a37coaFqpKh9mtk

[@tszhuenbai6462]

Hi Reza, thanks for the video, which is very informative and helpful. I am just wondering why we need "Get manager" when we already have the approval matrix, and in my understanding, the approval matrix will help to pick the approver as you choose the request type. Thank you.

[@RezaDorrani]

Get manager is dynamic. It will pick the users manager from Active Directory. It was given as an option. You can simply remove it from flow if that is not needed as part of your scenario.

[@Tehral]

I need a way to have multiple items (AD requests) that have the email of a manager as a manager column inside one mail and it should be possible to choose which ones to approve and reject the others

[@RezaDorrani]

I did not understand the ask. You can check my Playlist on approvals and see if it matches your scenario.

[@Tehral]

@RezaDorrani sadly couldnt find it I have a list with Id request manager What I need is send the manager 1 mail with all his requests and he can choose in the mail which one should be approved

[@RezaDorrani]

@@Tehral then I would suggest checking or posting your query on forums in case someone has done something similar

[@davidm5732]

Hello Reza, I have a similar project and I have a question. In a Flow where everyone must accept, is it possible to collect the response of those accepted before everyone answers? In your example the comments appear once everyone answers but I would like to add the comments as they accept to know who is still to be approved. In a start and wait it is not possible so I don't know how I can do it. Thank you very much!

[@RezaDorrani]

Everyone must approve action will cause flow to wait for everyone to respond. To get details of users who responded, you would need to query Dataverse Approval Tables (which would make your flow a premium licensed flow). I think I did a video a while ago where I check in Dataverse as to who did not respond to send approval reminder. Check kzbin.info/www/bejne/kKbTgmN3l6mfZqs

[@kevkeisha]

This is an INCREDIBLE! Thank you! However, I don't know how to modify the flow if I don't need a manager's approval!

[@RezaDorrani]

Just set manager approval to No in SharePoint list.

[@hannahmay3078]

Hi Reza, many thanks for this video. It has helped me a lot in my work. I am having an issue with the Approval Matrix. The order in which the names appear keeps changing. I am not sure why this keeps happening?

[@RezaDorrani]

Where does the order change? flow or sharepoint? I do not see any such issue at my end and 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

[@hannahmay3078]

@@RezaDorrani The order of names changes in the SharePoint list, in the approval matrix.

[@RezaDorrani]

@@hannahmay3078 It cannot change on its own. Looks like a Sharepoint bug in your case.

[@Dje-ij5zg]

Quick question! I set an approval reminder duration, and my flow is still running even tho the request is approved, is that right? How can I get it to stop if the request is approved before the reminder time?

[@RezaDorrani]

I dont remember running into this issue. Prior to sending reminder, you can always check if approval is completed and only then send the reminder.

[@jagadeesanm7875]

Hello Reza, Lovely video. I've downloaded the approval flow from the description however I'm unable to view it and use it in my flow. Downloaded zip folder 'Microsoft flow' folder and a 'manifest' JSON file. Could you please recommend how to use the dynamic flow?

[@RezaDorrani]

Are you importing as a flow or solution? I did this video long back. Best reference are the files shared.

[@jagadeesanm7875]

I'm trying to copy the approval creation input in the "Create an approval" flow @@RezaDorrani

[@RezaDorrani]

@@jagadeesanm7875 Im not sure what the issue is.

[@tejaskapadia5505]

Hey Reza, this is great! I wanted to ask if we could incorporate reminders in this dynamic approval flow, I'd love to make an addition like that to dynamic approver workflow? For example, say the first person approved it within a 5 minute time frame, then the next is taking longer than 5 minutes. After 5 minutes it sends a reminder to approve. Any tips?

[@RezaDorrani]

Here is the video on reminders kzbin.info/www/bejne/kKbTgmN3l6mfZqs

[@BumbleBeeBabi]

Hi Reza, What if we only need the manager to approve? How do get the "Requested by" to change if another user is submitting the request. I noticed when folks tried to add an item, the "requested by" is under my name.

[@RezaDorrani]

Approval action has a requested by property. I have done many approval videos covering various scenarios. Check the approval playlist on my channel.

[@Tony-mo9ev]

Awesome as always, Reza ! Helping me to have a better understanding and create a better app. Do you have any similar but with PowerApp for Teams ?

[@RezaDorrani]

I do not have a similar video reference for Power Apps for Teams, but the same logic can easily be applied there as well.

[@mohdnoraminbinkasmuri9234]

Hi, Do you have a video of Approval required, Supervisor approval and Manager Approval. Supervisor Approval list 1 (multiple approver) Manager Approval list 2 (multiple approver)

[@RezaDorrani]

This is the most dynamic approval video I have. You can look into the patterns showcased in video and try and change it to match your scenario. I would also recommend checking on forums in case someone has done something similar powerusers.microsoft.com

[@mohdnoraminbinkasmuri9234]

@@RezaDorrani thanks for sharing. Will try to match the patterns showcased in your video. Dynamic approval + Multi Level Approval workflow. Will try that first. Thanks for the quick reply. :)

[@fournier.benoit1993]

Is there a way to lock the approval status field so only the flow can change the value? Since users have edit permissions, they could change the approval status.

[@RezaDorrani]

SharePoint does not support column level permissions. However, you could hide the approval status field from the SharePoint form.

[@playoffice4310]

Hi Reza, your videos are great. I am still unable to correlate the two lists at the beginning of the videos the Approval Matrix & Service Desk.

[@RezaDorrani]

Matrix is a list where the Title column values match the choice column values in service desk. You could even use lookup. I cannot provide much guidance here on chat. If you are running into issues then I will recommend to post it on forums at powerusers.microsoft.com

[@playoffice4310]

@@RezaDorrani Hi! I am still watching the video until now! lol, Your videos are very informative. I'll be happy communicating with you on forums.

[@RezaDorrani]

@@playoffice4310 Thanks. I only go to forums in my free time (which is almost none these days).

[@jakepribble338]

Thanks so much for all your time and help to the community! I hate to ask as I know you put this together long ago - I get errors every time I try to grab the first approval condition if the approval is required at all. I can only find clues about this being a challenge because it is a yes/no field. I am using same expression you have in the example download package. Do you have any ideas on my problem? Thanks very much!

[@RezaDorrani]

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

[@jakepribble338]

@@RezaDorrani I understand. I worked on this all night, just keep getting that error. Thanks for replying. You are very appreciated sir!

[@RezaDorrani]

@@jakepribble338 Forums is the best place to post issues. Many are there to help. I also go to forums to assist but only in my free time.

[@christianschumann6817]

Hello Reza, i have two Questions. The First, the Step with the If for the ApprovalType does not work for me. if(equals(outputs('Genehmigungsinfo')['GenehmigungTyp/Value'],'Mehrere muessen genehmigen'),'BasicAwaitAll','Basic') switch all the Time to the Option "First to Respond". All Fieldnames in the if Step are correct for my Lists. Where is the Error ? The second Question ist for the Create Approval. How can i insert in the ApprovalCreationInput the Value for show all Attachments ? i have this Informations in a Variable {"name": DisplayName, "content": body} and all is fine in the normal Start and Wait for Approval if i insert my Variable in the Field Attachments. But i don´t know how i can show that Variable Content in ApprovalCreationInput.

[@RezaDorrani]

1 - Video description has link to download the complete flow. 2 - I did not understand the question. Show all attachments for approval action?

[@christianschumann6817]

​@@RezaDorrani Question 2: I mean in your Video at 11:40 Create a Approval. How can i insert Links to Attachments in this Step ? I the normal Start and Wait for a Approval i can do this in the Section Attachments, but in your Video i can only insert JSON Settings but i don´t know the Variable to do that. Can you give me a Link where i can read which JSON Variables i can use in Power Automate ?

[@RezaDorrani]

@@christianschumann6817 I have not tried investigating into how to add attachments. Hence, I am not aware of the steps.

[@hydyusable]

Hi Reza, I'm trying to create an approval and found ApprovalCreationInput option does not auto-populate instead it shows * Body. I tried many times of creating an approval action using "Create an approval" but doesn't work. I'm missing the control here!

[@hydyusable]

I try to "create an approval" from the scratch flow which is done and I paste the control using copy from My clipboard and am done, Thanks for your valuable videos.

[@RezaDorrani]

Video description has link to download sample app

[@santiago46]

Hi Reza hope all is well. I’m working on a share point site a document library where users upload emails so we are trying to detect that once the email goes into the SharePoint site we parse the email Contant and then populate the SharePoint site with the content that we parse out of the email do you have a video with this type of scenario? So we have PDF documents as well that are being uploaded to the SharePoint site plus the emails that are being uploaded into the same site as well. Thank you

[@RezaDorrani]

I don’t have a video on this scenario.

[@nagarjun572]

Always ur doing amazing contents.. learnt a lot from your videos ❤️ and could please do a video or tel me SharePoint URL links / external links can be validated using Power automate...? Please 🙏 response to this sir...

[@RezaDorrani]

Thank You so much! Link validation with flows, I am not sure about this. Never tried it. I will recommend checking on the forums at powerusers.microsoft.com/

[@RanjithKrishnan99]

Hi Reza, how can i change the response summary timezone format

[@RezaDorrani]

kzbin.info/www/bejne/rIKycmV7ecZ6iZosi=bKz2p6gUElXoSFOq

[@stephaniedessalins9194]

Hello Thank you for your video i 'haven't yet arrive to the final step and i had an error in Approval Info (Correct to include a valid reference to 'get items" for the input parametres of action 'ApprovalInfo' Where is the problem ? Thank you for your help

[@RezaDorrani]

Video description has link to download sample flow. As for your issue, 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

[@DidiKashemwa]

Hi Reza, could you know why the approval would not send an email notification but only sends it on Teams? Is it a setting?

[@RezaDorrani]

Should not be the case. Is allow notifications setting turned on for the approval action?

[@DidiKashemwa]

@@RezaDorrani Yes it's turned on.

[@RezaDorrani]

@@DidiKashemwa Weird.

[@gauravgoyal5]

I am using Create Item Action. I am creating a Claim variable with if condition, if user name is there then I am setting up variable with claim value else leaving it blank. now if I run the flow it works well when have value in variable but gives me error when its blank. Can you please let me know how to set up blank value in single person picker column with a variable?

[@RezaDorrani]

I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@gauravgoyal5]

@@RezaDorrani OK. Thanks

[@Bak2Basikz]

Hello Reza. I love watching your videos! Question…,When using this SP Approver route, how do you get a flow to work when the Approvers are in any order and are assigned and in order during the initial SP form request phase? The sharepoint groups list also has a column with M365 groups instead of individuals. Thank you.

[@RezaDorrani]

I did not understand the question.

[@ghcstar88]

it is able to add another dynamic where there is different approval route?

[@RezaDorrani]

I did not understand the question

[@ghcstar88]

@@RezaDorrani I have 2 lists involve in approval. 1 list is for approval matrix (approver name). Another list is to fill in necessary information for approval request. But there is 3 type of approval which the approval route and number of approval is different but approver is same according to matrix. I have do power automate where approval route is defined in the power automate flow. But the challenge is when there is request to change approval route, it require to edit in power automate. Is there any solution that the approval route can be define in a list and power automate will route the approval according to the route defined from the list. And changes can made anytime just update the list.

[@RezaDorrani]

@@ghcstar88 Probably possible, but something I would have to try to know the options. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com