Dynamic Approvals in Power Automate | SharePoint List based Approval Tutorial
HTML-код
- Опубликовано: 30 май 2024
- In this step-by-step Power Automate tutorial video, we will explore creating a dynamic Power Automate Approval workflow process based on an Approval Matrix (SharePoint Configuration List).
The SharePoint list will drive the entire approval pattern.
List will track information like Approval required, Manager Approval needed, Approval Type (First to respond or Everyone must Approve) & the Approver list (multiple approvers).
Power Automate Dynamic Approvers: The entire Approval flow in Power Automate will be driven from the Approval Matrix. Updates to the configuration list will dynamically update the approval pattern.
Power Automate Dynamic Approval Type: We will also provide the user an option to select the Approval Type / Pattern - "First to respond" or "Everyone must Approve".
Topics covered:
✔️ Build an Approval Matrix
✔️ Dynamic approvers & approval type selection from Configuration List
✔️ Build Power Automate flow to drive the Approval Scenario
🔗 My Approvals Playlist - • Flow Approvals Cookbook
⬇️ Download sample Dynamic Approval workflow from Approval Matrix:
github.com/rdorrani/Microsoft...
Expression for Dynamic Approval Type
if(equals(outputs('ApprovalInfo')['ApprovalType/Value'],'Everyone must Approve'),'BasicAwaitAll','Basic')
Multi step serial approvals
🔗 • Power Automate Multi L...
#PowerAutomate #Approvals #SharePoint
Table of Contents:
00:00 - Introduction to Power Automate Approvals Video
00:38 - Power Automate SharePoint List Approvals
01:20 - Build SharePoint Approval Configuration List
03:25 - Build Approval flow pattern based on Configuration List
13:46 - Dynamic Approval flows in Action
18:38 - Subscribe to Reza Dorrani channel
🤝 Let’s connect on social:
🔗 LinkedIn: / rezadorrani
🐦 Twitter: / rezadorrani
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,
So happy to hear that! Thanks Steven
Reza, the speed of your tutorials are just excellent. Love the density of information and how you respect time of your viewers!
Glad to hear the feedback. Thank You so much.
Once again, you're the best out there. Thanks for this!
Wow, thanks!
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!!
Awesome! Thanks John.
Awesome! Thanks for the video Reza!!!
Thanks Will
This wasn’t exactly what I was looking for, but gave me a lightbulb moment with the issue I was stuck on. Thank you!!!!
Glad it helped!
Thanks for another video! your tutorials are excellent!
Most welcome
Another fabulous video. Your video shows how expressions are so important to Power Automate and minimize the API calls.
Thanks Aroh! Expressions are the 💓 of flows.
Brilliant! I'm learning so much!
Great to hear!
Thank you Reza! Finally got a a change to apply this to a problem at work today.
Great 👍
Wonderful!! Thanks for the clear explanation.
You are most welcome
Fantastic movie Reza. Much appreciated!
Most welcome
Saved to my Favorites videos, excellent source of information.
Glad it was helpful!
Awesome. Great idea on approval matrix.😀
The idea came about while working on last week’s approval video :)
@@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 😀
@@jaggyjut I have done around 17 videos now on approvals covering most bases. Time to take a break from approval videos.
Thanks Reza for the great video 👍🏻
Your most welcome! Thanks for watching.
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.
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
Thanks for another great video
Thanks for watching!
Thank you Reza, you just saved my £450. I can't thank you enough.
You are most welcome!
Thank you so much for this video!
You’re most welcome
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.
Let's count on each other and keep sharing knowledge :)
Amazing!!!
Thanks
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.
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/
Sometimes I want to hit the Like-Button more than once 👍
Thanks so much! I’ll take that as more than 1 like :)
Always good thks
Thank you
Reza you are the best
Thanks
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 ?
I do not have a similar video reference for Power Apps for Teams, but the same logic can easily be applied there as well.
Thanks Reza excellent
You are most welcome Sundra
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.
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.
hi reza nice video
Thanks!
You are awesome
Thanks :)
Power Packed.. with full of FUNtastic Demos..
👍
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?
Video allows a setting to turn off need for manager approval + video description has link to download entire flow.
This is exactly what I need
Great
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!
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
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?
Here is the video on reminders ruclips.net/video/ZupQ0AbDl0I/видео.html
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.
I did not understand the question.
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?
ruclips.net/video/gb_FUeRjgg4/видео.html
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!
Just set manager approval to No in SharePoint list.
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
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
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.
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.
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?
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.
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!
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
@@RezaDorrani I understand. I worked on this all night, just keep getting that error.
Thanks for replying. You are very appreciated sir!
@@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.
Very helpful! Thanks. I have a question??? HOw could I create a pin to allow certain users to see a view/list?
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.
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.
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.
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.
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
@@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.
@@playoffice4310 Thanks. I only go to forums in my free time (which is almost none these days).
Hi Reza, firstly, thank you so much for uploading this video, its really great! secondly - apologies in advance if this question already been asked, however, I would like to know if there is any way of getting this flow to trigger for items that already in the list? not just on creation? I've used this flow for a task list that needs approvals, however as the task list contains previously added tasks and the flow will only work for tasks that are newly added (it works great btw). Short of deleting the tasks and adding them back in again, can I get the flow to work for existing items? (there are 60+ tasks!).
You could create a copy of this flow and change trigger to when an item is selected in SharePoint list. Then call new flow for your 60 items by selecting them one by one and triggering the flow.
@@RezaDorrani Having trouble with this - If i select the trigger to be when an item is selected i don't get the option to add the column title to where you have put Title eq 'DynamicContent' in the filter query in the get items section. Also another thing I have noticed since adding this work flow, when a member of staff creates a new list item, the flow triggers however the email and approval are from me and not them.. is there any way to have the approval from the user stated in the 'created by' field?
@@gennaroacquaviva416 Things would change. Not everything will be the same. You will need to work through it one by one. Check my approval playlist. I have done a video on for a selected item.
@@RezaDorrani Thank you Reza, I'm currently watching through the playlist, can't seem to find one with that title, could you point me in the right direction? apologies for asking so many questions - I appreciate the help!
@@gennaroacquaviva416 It may not be in the title. You will need to check the content.
Note: Video will show for a selected item. It may not show your exact scenario.
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.
Video description has link to download flow.
@@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
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!
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.”
@@RezaDorrani Deal! 🤝
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?
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
@@RezaDorrani okay, I'll check out the email reminders, I think that should work. I'll update you, thanks so much.
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?
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.
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?
Approvals are per item.
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?
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
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
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
@@RezaDorrani thanks. Let me do that
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
Most welcome!
Currently, there is no such option to stop the approval.
@@RezaDorrani Ok got it, thanks for your response!
@Reza- Thanks for this video!! at 4:28 secs, I do not get the Request type Value in the dynamic content type!! Please help
Video description has link to download sample flow. Give that a try.
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.
Same response as your comment on another video
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?
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
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?
Looks like you are trying file property updates and not list item.
There is an update file properties action for that.
@@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.
@@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/
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?
Are you importing as a flow or solution?
I did this video long back. Best reference are the files shared.
I'm trying to copy the approval creation input in the "Create an approval" flow @@RezaDorrani
@@jagadeesanm7875 Im not sure what the issue is.
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?
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
@@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.
@@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.
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
@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.
ruclips.net/video/5Mypn4oCJdw/видео.html
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
Video description has link to download sample flows. You can check the code and logic in it.
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?
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.
@@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?
@@hydyusable Video description has link to download sample app.
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.
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.
@@RezaDorrani Thanks, I'm going to give it a try.
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!
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 ruclips.net/video/ZupQ0AbDl0I/видео.html
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?
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
@@RezaDorrani The order of names changes in the SharePoint list, in the approval matrix.
@@hannahmay3078 It cannot change on its own. Looks like a Sharepoint bug in your case.
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.
Possible. I have done 18 approval based videos covering various scenarios. They are all in the approvals playlist on my channel.
Hello Reza,
Welldone!
This video has been helpful
A quick question: How do you parse an attachment with JSON in the Create an Approval Card?
Hello Reza,
I thought i figured it out using peekcode by using "attachments":base64ToBinary(outputs('Compose_2')) where my Compose_2 is base64(outputs('Get_attachment_content')?['body']) but none of these worked. So at the end of the day, the peekcode in my create approval cad looked like this:
{
"title": "@{triggerOutputs()?['body/TitleofPolicy']}",
"assignedTo": "@{join(body('Select'),';')}",
"details":"Test"
"enableNotifications": true,
"enableReassignment": true,
"attachments": @{base64ToBinary(outputs('Compose_2'))}
}
Please any help on this would go along way.
Thanks!
Not sure about this. Have not tried it.
I will recommend checking on forums in case someone has done this powerusers.microsoft.com
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.
Approval action has a requested by property. I have done many approval videos covering various scenarios. Check the approval playlist on my channel.
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
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.
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.
SharePoint does not support column level permissions.
However, you could hide the approval status field from the SharePoint form.
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)
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
@@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
@@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.
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
I don’t have a video on this scenario.
Hi good language pronounciation. Ease to understand
Thanks
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_']} ",
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
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.
I think this video shows reading approvers from a list
@@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.
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
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
Hi Reza, Thank you for the powerful content. I tried to do the same steps and everything work correctly. But I have a problem when I start a request, everything in sharepoint work just fine but when the flow is start running the requestor change to my name not requestor name. supposedly requested by end user but in my case, the requester in approval apps changing to my name. Need your help and thank you in advance
Video description has link to download flow.
You can give that a try.
Alternatively, I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hello Reza hope you are doing well. Question: Can this concept be applied to a document library site as well? thank you
Yes, by replacing the list-based actions with library-based actions.
Thank you Reza
@Reza Dorrani Thank you for this video, I came across it while trying to figure out how to have approvers for different types documents. I plan to implement it this way. However I'm working with a document library and as per your response I was wondering if that means the Approval matrix list becomes an approval matrix library. Or there can be a link between the approval matrix list and my document library in sharepoint like you had.
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
Video has link to download sample flow. You can copy the JSON from there.
@@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
@@1974andyowe I recommend posting your issue with screenshots on forums at powerusers.microsoft.com/
i don't understand ApprovalCreationInput bit at 11:46, do i just type that out or is that something else i need to do?
You need to type that
Hi Reza, thank you very much for your useful video, but please can you tell me how to let people have the ability to choose their own Approvers after select a specific Request Type? It would litterally save my life :)
Check ruclips.net/video/5lZ3xdc8DiA/видео.html
Is there any way to embedd approvals into powerapp so that the user can click the approve or reject button inside the approval email OR within a custom button in a PowerApp? We can use approve and reject buttons in powerapp to modify sharepoint lists which we love, but also love the approvals workflow with the accept and reject button in the automated emails. Is there any way to embedd the approvals into a powerapp button?
Yes, checkout Shane Young video - 'Approvals Without Flow' I believe is the title of video.
Approvals in Power Apps Forms - ruclips.net/video/Om4beefKmV0/видео.html
Approval buttons in Apps - ruclips.net/video/d4e1whKVJU4/видео.html
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...
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/
I tried to import the flow I downlaoded from your GitHub, but the import fails with errors. Do you have any hints on how to resolve? - FYI Great video.
I have not come across any issue with importing and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com or try rebuilding the flow by looking at the video.
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)
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
@@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. :)
Great video. I want to do the same but in dataverse table, is it possible?
Possible. The configuration list can be any data source of your choice.
Having troubles with dollar limit conditions. For example, if the PowerApps requisition total cost is $2,400 and the user/requester approval limit is $2,500 I don't need manager approval. But, if it is over the $2,500 user limit, I then need manager approval. Also, if a specific purchase category, regardless of dollar limit, I want a separate approval to a specific approver/assigner. I have SharePoint list built, but can't quite put the final touches together in flow. Anyone have pointers. Thx
Check ruclips.net/video/5lZ3xdc8DiA/видео.html
I have an issue where my approval is not actionable in the e-mail, it re-directs to the Approval web page for approve/deny. My PoSH Exchange config [Get-OrganizationConfig | ft ConnectorsActionableMessagesEnabled,SmtpActionableMessagesEnabled] are both set to true. Any suggestions?
I have not come across this issue.
Check on the forums at powerusers.microsoft.com
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!
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.
Video description has link to download sample app
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?
I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani OK. Thanks
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.
1 - Video description has link to download the complete flow.
2 - I did not understand the question. Show all attachments for approval action?
@@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 ?
@@christianschumann6817 I have not tried investigating into how to add attachments. Hence, I am not aware of the steps.
How can we track users that haven't responded? I've created a SharePoint List with multiple people type that list all the approvers that need to respond and need to update that list by removing users that respond. You do amazing work. Thank you.
You would need to query Dataverse approval tables to get information of approvers who have not responded. That would require a premium license. 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.
@@RezaDorrani I created a people field in my list for waiting to approve and adapted your dynamic matrix list to look up members of group and populate field on creation. On approval of each user, members that approve are removed from field. This seems to be a viable solution since I don't have a premium license. Thank you for your valuable feedback and suggestions.
👍
@@RezaDorrani I'm stuck and really hoping you can explain how to accomplish this requirement to track users that haven't approved approvals when all must approve. I'm not sure how to remove users that have approved from my people list. I think using a variable with all of the approvers and tracking as they are removed might work, but I can't figure out how to change the values of the array when response received. This seems like a common request and I can't find a solution.
I have not done any video on this scenario and would have to try it out to know the steps. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
Hi Reza, could you know why the approval would not send an email notification but only sends it on Teams? Is it a setting?
Should not be the case. Is allow notifications setting turned on for the approval action?
@@RezaDorrani Yes it's turned on.
@@DidiKashemwa Weird.
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.
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.
@@RezaDorrani Thanks Reza.
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.
@@Finix.W Thanks for explaining. I'll keep trying.
@@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.
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?
One more Thing, in the condition of the Manager Approval, how did it change from "outputs" to "Manager.." ??
Like in 7:56
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.
Hi reza from this is it possible to have a dropdown to select which approver i want given the type of form i am submitting
Where would the user pick the approver?
Hello Sir
This is regarding SharePoint list.
How can we show actual file names instead of paperclip icon in modern SharePoint list. Thanks ☺️
List item attachments are shown as paper clip icon in list view. I don't think there is a way in SharePoint to show the actual files in list view.
what is process to add your sample workflow into my sharepoint/powerautomate tenant?
I dont have a step by step guide on how to import and setup. Idea of video is to show how dynamic approvals can be achieved. I have shared entire flow in video description.
Hi Reza,
I am currently using this to build a flow but I am stuck at Approval Creation input under the Create an approval, Please can you help to copy and paste the object used. The four parameters. I just need them in text format. thanks
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@RezaDorrani
Thank you for the super fast response.
I do not know what to input in the approval creation input box.
I only saw you had 4 objects.
@@bisolaadeyemi9087 Video description has link to download the sample flows. You can check all the logic in it.
@@RezaDorrani
{
"title": "@{triggerOutputs()?['body/Requesttype/Value']} Approval"
"assignedTo":"@{join(body('Select'),';')}"
}
this is showing enter a valid json
@@bisolaadeyemi9087 I cannot know here on chat + the sample flows are the best reference I have.
I recommend posting your issue on forums at powerusers.microsoft.com in case someone has experienced something similar