Power Automate Multi Level Approval Workflow | Serial Approval | Multiple Approvers

Подписаться 128 тыс.

Просмотров 280 тыс.

50% 1

In this tutorial video, I will show how to build Multi-Step Approvals in Power Automate.
We will build a multi-level / serial approval workflow using the Approvals action & add approvers dynamically based on various use cases (type of data, value greater than, etc.).
We will leverage SharePoint Lists & an approval workflow along with SharePoint column formatting. We will showcase an Approval timeline which will include a progress / status indicator for showcasing the current state of the approval process related to the SharePoint list item + Approval history which includes all details of the approval action (approver name, approval date, time taken to respond, comments), highlight the serial list of approvers, show status of each approver & calculate the time taken for the approval.
We will define our approvers dynamically based on metadata & log the approval history to SharePoint list item (best practice since flow approval history is only available for 28 days).
Scenario in video is an Expense Report application in SharePoint where users log expense details & we have a multi stage / level approval process.
Topics covered:
✔️ Multi Level Approval Workflow using Power Automate
✔️ Dynamic approvers selection for serial approvals
✔️ SharePoint Column Formatting
✔️ Approval Status Indicator
🔗 Expense Report Approval Flow + JSON Column Formatting - github.com/rdorrani/SharePoin...
🔗 My Approvals Playlist - • Flow Approvals Cookbook
🔗 My SharePoint Formatting Playlist - • SharePoint List Format...
#SharePoint #PowerAutomate #Approvals #ListFormatting
Table of Contents:
00:00 - Introduction
00:30 - SharePoint List Walkthrough
00:58 - Standard Pattern for Multi-Step Approvals
02:47 - Dynamic Multi-Step Approval flow pattern
09:03 - Update multiple approvers and test
10:27 - Add Manager Approval if Expense Amount is greater than $500
13:16- Expense Reporting Dynamic Multi Stage Approval Workflow
17:42 - Subscribe to Reza Dorrani channel

Опубликовано:

5 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 952

@TheAsterii 2 года назад

Thanks for the inspiration Reza. Leveraging the Apply to each control and and applying the counter variable to dynamically determine the final approval responsible is quite brilliant :)

@chadalthaus3866 2 года назад

This is brilliant, Reza. I'd never think to use an "Apply to each" on an array variable and start and wait for approvals within each. As always, man, this is so good! This is such a helpful way to improve a clunky and hard to maintain flow.

@RezaDorrani 2 года назад

Glad it was helpful! Thank You Chad.

@getakter 2 года назад

This is absolutely brilliant. I never thought of the approval workflow in this way. Thanks, Reza for your great efforts.

@RezaDorrani 2 года назад

You are most welcome

@warrengibbs2181 2 года назад

Great video Reza! Last week I was working on exactly same requirement. I used a Switch to control flow sequence based on the status of the approval. Your approach is much more elegant. Thanks for sharing your talents!

@RezaDorrani 2 года назад

Thank you for sharing your scenario. There are always multiple ways to achieve a desired outcome.

@FranciscoCamacho_fjcamachoj 2 года назад

Hi Reza, very useful in many scenarios, thanks for sharing. Something that can be challenging in Lists is validation between columns. For example, depending on the "Expense Type" the "Amount Value" allowed may vary and making a "Comments" column required. If Expense Type = Travel the Max Amount Allowed = 5.000 and you must fill de comments column.

@RezaDorrani 2 года назад

There is a validation settings option in SharePoint. Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-fb0ePBrifP0.html

@FranciscoCamacho_fjcamachoj 2 года назад

Thanks Reza, something that I forgot to include in my previous message was that if the validation works for Lookup columns?

@RezaDorrani 2 года назад

@@FranciscoCamacho_fjcamachoj It does not.

@Markfx_w 2 года назад

Great video! Very clear and easy to follow. Do you have any tutorials on how you customised the list view to show as cards such as what you had in this tutorial

@RezaDorrani 2 года назад

Thanks. Check ru-vid.com/group/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf

@gauravnema4072 2 года назад

You have simplified the complex flow, just Wow. Keep sharing.

@RezaDorrani 2 года назад

Thanks a ton

@stevenhampson8657 2 года назад

Well presented and really like the building of the complexity for the use cases and solutions. Very professional.

@RezaDorrani 2 года назад

Thank You Steven

@williamhill9217 2 года назад

Sharing for beginners, when creating approvals, if you don't hit the "show advanced options" all approvals will come from you the creator of the flow. You'll end up getting alot of emails/questions of why they are coming from you vs the person who created the approval. Question for Reza, since power automate doesn't provide a great audit trail, I know in a previous video you created a separate list for that, if we took those steps and put it in here, would the outcome be the same? Also could you show a dynamic approval flow leveraging users in AD groups and distribution gorups vs names stored in a sharepoint list?

@RezaDorrani 2 года назад

Thanks for sharing the tip on setting the requestor option in approvals. Audit trail - Outcome would be the same. In fact in the last part of the video where I showcase the complete flow, I have reused the logic from my previous video. Group Approvals is supported in approval action. Names stored in SharePoint list can be replaced by AD Mail enabled Security Group Names.

@matthewryan5505 4 месяца назад

@@RezaDorrani- would you be willing to create a tutorial on how to accomplish this? This flow is great and would love to see this built into it.

@RezaDorrani 4 месяца назад

@@matthewryan5505 I do not have plans to work on an updated video on this topic. I have 10-12 video ideas planned that Im working on.

@linsss13 2 года назад

Thank you, Reza! Amazing content as always! I am wondering if this can be applied to a more complicated approval process, where we have approval stages based on Expense Amount (ex.: Amount < 1K -> 1 level Approval, if >1k -> 2nd level, if >3K 3rd Level etc.), combined with dynamic approvers based on Expense Type. I also need to record the approval history on item level: I have columns for all approval stages: Approval L1 Responce, Approval L2 responce, etc. where I capture Response Summary from the Approval action. Basically I need to capture Approvers first, based on Expense type, then based on Amount to start approvals for each level, until Final Approval or the condition for the amount is no longer met. Is this possible with this method, or becomes too complex? Thank you!

@RezaDorrani 2 года назад

It is possible but the code would be complex.

@anjaliojha8426 2 года назад

Any chance this request was implemented from your end? I have same requirement to be deployed

@abdouramaneyoussoufou8789 2 года назад

Hello Lin, Were you able to realize this? I want to do the same

@abdouramaneyoussoufou8789 2 года назад

@@RezaDorrani Is it possible that you give us an example: each approver has his ceiling amount and the approvers also depend on the type of expense?

@RezaDorrani 2 года назад

@@abdouramaneyoussoufou8789 An example would have to be through a video. I have 10-20 video ideas lined up and I would need a lot more folks requesting this scenario for me to give it a higher priority.

@MindfulLivingSpace 6 месяцев назад

Thank you, Reza! Amazing content as always!

@RezaDorrani 6 месяцев назад

Most welcome

@pawanmishra6549 2 года назад

Extremely helpful and as usual thanks for sharing a very practical use case. LOVE IT❤❤

@RezaDorrani 2 года назад

Thank You

@evolutionofj5443 9 месяцев назад

I am actually using this for project management and technical approvals, this will work, I'll have to build a little more but this is exactly what I needed! Thank you so much

@RezaDorrani 9 месяцев назад

Glad to hear that! Thanks for watching

@tetsuyakawahara4150 2 года назад

So amazing!!! I love this formatting!

@RezaDorrani 2 года назад

Thank you Testuya. I made the extra effort here since this would be my presentation on the PnP Call :)

@kashiyamwape943 Год назад

Amazing presentation, clear and straight to the point ..Thank you !

@RezaDorrani Год назад

Thanks so much!

@Dany-ns6hg 2 года назад

You are genius Reza as your knowledge around these power platform tools are commendable, God bless you and give more knowledge and wisdom to share such useful video with us. I am learning a lot of new things through your amazing videos.

@RezaDorrani 2 года назад

Thank you so much 🙏

@HammadJagirdar 6 месяцев назад

amazing content, specially the dynamic approvers from the sharepoint list and then approving it.

@RezaDorrani 6 месяцев назад

Awesome! Thanks so much

@user-jw9sj8ku5d Месяц назад

Such a great instructional! Thank you!

@RezaDorrani Месяц назад

You are most welcome!

@5394prashant 2 года назад

Thanks for sharing this. I have built something very similar for my Organization too, which takes care of multiple Business Processes for Approval as i tried to create as generic as possible. There are two more rules i added…. Configuration can decide weather the Approval behaviour would be “First to Respond” or “Everyone must Approve”. it can also decide that weather the Approvers would be predefined in a List or it can dynamically pick the Approver based on the transaction. I am currently working on something similar for Document Library Approval. I really loved the Card Presentation of Approval status. I would definitely try this JSON Format.

@RezaDorrani 2 года назад

Thanks for sharing your scenario as well. I was planning to add the approval behavior but wanted to keep the video simple.

@danielmartins5327 2 года назад

You're very good Reza. Thanks a lot for sharing.

@RezaDorrani 2 года назад

Thanks Daniel

@DidiKashemwa 2 года назад

I was the 500th person to like this, thank you Reza

@RezaDorrani 2 года назад

Thank You so much. Wow! This video has done well. I did not expect this response :)

@shaiksamad1562 2 года назад

Reza... You are just amazing. I remember Daniel used to say he is your big Fan. He is wrong I am your big Fan and as always you are my superhero..🦸

@RezaDorrani 2 года назад

Thank You 🙏

@FarhanKhan-lr4tv 2 года назад

Your vedio is amazing and helpful for our knowledge and career. thank you ❤️😊

@RezaDorrani 2 года назад

My pleasure 😊

@ramonillarramendi3191 2 года назад

Amazing! Thank you very much.

@RezaDorrani 2 года назад

Thanks for watching.

@MrSumblaambreen Год назад

it's really helpful, to look for a flow solution for 2 SharePoint lists (request & approvers) request needs to be approved by multiple departments and each department has multiple approvers.

@RezaDorrani Год назад

If this video does not meet your scenario and if you need assistance with a specific use case, then I will recommend posting your query on the forums at powerusers.microsoft.com/

@sundrapillay6668 2 года назад

Thanks Reza excellent as always

@RezaDorrani 2 года назад

My pleasure!

@insafaccounts5605 2 года назад

Superb explanation on all your videos

@RezaDorrani 2 года назад

Thank you so much 🙂

@amandat6849 2 года назад

Reza! This is amazing and such a great video. I have one question, I have 3 approvers and everything works beautifully but it's changing the status to approved after the 2nd approver. Do I need to change the increment variable/varcounter after start/wait for approval to "2" instead of 1?

@RezaDorrani 2 года назад

It should work as demonstrated in the video. Video description has link to download the sample flow.

@Michael-ir7cn 2 года назад

Thank you so much Reza for sharing your ideas and knowledge! By the way, one can refresh your knowledge about arrays at the same time! How about extending this workflow template to include reminders, escalations and a time-out, for example? ;-)

@RezaDorrani 2 года назад

I have a full playlist on approvals that includes reminders, escalations, time-out & more. Check it out here - ru-vid.com/group/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe

@amywoodfin6195 Год назад

Reza - You are my go-to source for learning about Power Automate! Thank you for all of the time and effort you put in to your video tutorials. They are very helpful. I do have one question. I have multiple approvers in a document library, but the approvers are different for each document and vary in number from one to four, depending on the document and department. I need the documents approved serially, as this video shows. Because I don't have a static group of approvers, I'm wondering if it is possible to use the flow described and use input fields in the 'For a selected file" trigger in place of the varApprovers? Right now I have different flows for 1 approver, 2 approvers, 3 approvers, and 4 approvers and enter the names in when I start the approval flow. Would be great to have just one flow to select from.

@RezaDorrani Год назад

Thanks so much for watching and learning from the videos! For a selected item trigger is limited to certain features. You cannot dynamically define approvers with this trigger. You may want to start your flow automatically on item created and assign your approvers based on metadata. I have done 18 approval-based videos covering various scenario. They are all on the Approvals playlist on my channel.

@big1975E 2 года назад

Awesome video! I’m new to using SharePoint and writing flows. Do you have videos that show how to create the form that you were using for the expense report and how to set up the tiles with report details and timeline?!

@RezaDorrani 2 года назад

Playlist on SharePoint list and form formatting - ru-vid.com/group/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf Video description contains links to my GitHub repo where you can download the JSON schema for the List form.

@nontleemtetwa7769 2 года назад

Wow this is so information thank you Reza

@RezaDorrani 2 года назад

Your most welcome!

@SecureLogic 9 месяцев назад

Hey Reza, love your content! If you wanted each approver to see the previous approvers comments in the approval notification they receive, how would you go about implementing that? Thanks again for all of your awesome videos, it has given me so much!

@RezaDorrani 9 месяцев назад

Maintain an approval history variable (I have shown this in some of my approval videos). Whenever an approval task is assigned, you can add the approval history info to the approval task description.

@amiralira6943 2 года назад

Hi Reza, Thank you for the perfect tutorial. Perfect as always. I have one question though, Is it possible to have the option to restart the flow once it is rejected? I am trying this option and my initial step is "When an item is created or modified", but it will cause an infinite loop. (That makes sense because in each step we modify the list item). Thank you.

@RezaDorrani 2 года назад

Better option would be to switch flow to "for a selected item". You can use column formatting to start a flow directly from SharePoint. Once item is rejected, you can show the start flow option again.

@jmp2214 2 года назад

Thank you, Reza! Very helpful! I do have one question - My approvals are different with each submission - How would I capture this using "initialize variable". I tried dynamically adding in the email address categories from the list but that is not working. Do you have any suggestions? Thank you!

@RezaDorrani 2 года назад

I will have to look at your flow and scenario in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com I have an approvals playlist that has quite a few scenarios. May be it helps - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4ZnI0_atYUo.html

@mardithpascua8112 Год назад

This is so good! Thank you for sharing this one! I noticed that there was a capability in your approval notification to enter a comment, however, when I tried mine, I do not have that.

@RezaDorrani Год назад

Most welcome! At what time in video do I show adding comment?

@adamshrinah2075 Год назад

Thank you !

@RezaDorrani Год назад

Welcome

@preyedavis2586 11 месяцев назад

Thank you so much Reza!! This was very helpful. I tried to recreate this flow but I couldn't figure out how you got it to show what the status of each approver was. Thanks in advance.

@RezaDorrani 11 месяцев назад

Video description has link to download sample flow. You can give that a try. Alternatively, I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@saniarao7250 2 года назад

Favorite channel

@RezaDorrani 2 года назад

Thanks Sania

@PrashantGijare 2 года назад

Hi Reza, as usual a very insightful and easy to follow tutorial. I have a question - I've built a similar flow for 3 static approvers and I record action of each approver in a sharepoint list item with attributes like approver name, time, comments and decision. For each document, I also create a approvral-id which is a running number that is applied to each approver action. What I'm looking for is to create a PDF document of the approval items under a approval-id and store in a sharepoint directory. Is there a easy way to create PDF from sharepoint? Whatever I've researched so far is telling me to create Word templates with fields and then use to first create a MS word doc and then convert it to PDF.

@RezaDorrani 2 года назад

I have a video on exporting to PDF. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Da4do2DxmJE.html Technique can be applied to any use case.

@jeanettegonzalez8876 2 года назад

Thanks for all your videos! It has helped me a lot with my work. You have amazing tutorials! I've been trying to explore ways to skip approvers if fields are left blank. For example on my multilevel approval I have Approver 1, Approver 2, and Approver 3. But when only Approver 1 and Approver 3 are assigned, the flow does not continue because Approver 2 is missing. I tried the "null" function but it doesn't seem to work for me. Do you have any suggestions for this? Thanks! Jeanette

@RezaDorrani 2 года назад

Null approver? Assigned to needs to be email addresses semicolon separated. I would also recommend posting your query with screenshots on the forums at powerusers.microsoft.com

@vinayayinapurapu 2 года назад

Awesome video. Learned something new this morning. Why I could not stop the video in middle once started? 😊

@RezaDorrani 2 года назад

Glad to hear the video is helpful. Keep watching:)

@kenm3528 11 месяцев назад

Consider me a new subscriber Reza. I’m just starting out in these flows and approvals. I’m loving it so far. Two questions if I may and I hope you will answer them for me. 1. You have approval history time being converted to Pacific Standard Time, what expression do I need to have my own time (UK)? 2. I also noticed that if approved don’t have pictures on their profiles, the order changes to those with pictures first then those without. I’ve changed the column settings accordingly but in the formatting json it still shows the pictures in Gallery view. Can you help?

@RezaDorrani 11 месяцев назад

Thanks. 1 - Check expressions documentation for that expression. It has all time zones listed. I also did a dedicated video on flow expressions which may help. 2 - Has nothing to do with profile pictures. I have seen a few sites where it does not respect the order. Not sure why. I have not experienced that issue.

@ruxxel 3 месяца назад

Great content!

@RezaDorrani 3 месяца назад

Thanks so much

@samanthasalazar9221 Год назад

Thank you for all of your wonderful videos Reza! I do have one question, is it possible to update a column (Completion Status) after each approver approves their task and to have their name displayed in an assigned to field if it is pending their approval? Any help is much appreciated!

@RezaDorrani Год назад

Possible. I have a playlist on approvals covering a lot of scenarios. Not sure if I have covered this scenario though.

@mohamedyusuf9446 3 месяца назад

Exceptional Solution! I would like to know more about how you did the list card formatting to display real time status. Appreciate the sharing of your knowledge.

@RezaDorrani 3 месяца назад

Video description has link to download the full solution

@2210duynn Год назад

Excellent

@RezaDorrani Год назад

Thanks

@carmelomessina1910 2 года назад

Thanks for the good work as always. One little flaw that bugs me in many of these cases is that the approval is requested by Sarah, in the e-mail the requestor is given as "Reza Dorrani". Is there any way to change that? Obviously the system takes the flow creator as a default. I couldn't find a solution other than building the approval process in Power Apps. Thx

@RezaDorrani 2 года назад

Approval action has a property called requested by. You can put in the email of the person making the approval request in there. Customizing approval form emails is coming soon.

@amir_aslam07 Год назад

Thank you , its very useful.

@RezaDorrani Год назад

Welcome

@amir_aslam07 Год назад

@@RezaDorrani Hi Raza, I am currently creating a flow, but stuck on some points, i need your help with that, how it's possible to reach out to you and have a conversion.

@RezaDorrani Год назад

@@amir_aslam07 I recommend posting issues/queries on forums. I go to forums to assist as well but only in my free time powerusers.microsoft.com

@shawnnabennett4423 2 года назад

This is great! Thank you for providing this solution. I have added dynamic emails (3) into the approver array. When there are only two approvers so one of the dynamic approvers is listed as "null" How would I make the flow set to approve if the last approver is null?

@RezaDorrani 2 года назад

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

@s.b.9037 2 года назад

Many thanks for the tutorial! Great as always! :) May I ask, if it is possible to use the organization details (visible within outlook, teams, sharepoint) and automatically add the person one reports to as approver (line manager)? Alternatively, (and maybe the option with less errors) I could also think of a form where the line manager needs to be added by the applicant and the request is automatically sent to the person added.

@RezaDorrani 2 года назад

Possible. You could provide a person type column where user can select the approver.

@s.b.9037 2 года назад

@@RezaDorrani Many thanks Reza - gonna try that out! :)

@mw011i Год назад

Reza, thank you for what you do - I've been following your videos for the past several months and you are an inspiration. I love this flow, but I have a question. I'd like to try to apply this to a vacation travel request for my organization. When I follow the standard pattern that you outline at 0:58, I have 4 pre-approvers before reaching the final approver. If I follow the 'yes' branch with that many levels, by the end I cannot create the last condition control to complete the approval (not sure if this is a Power Automate limitation). My question is this: is it possible allow the flow continue to the final approver if any of the pre-approvers reject the request?

@RezaDorrani Год назад

That would require re-design of the logic. 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

@mw011i Год назад

Ok, I will try that. Thank you very much for the reply!

@niemazmartwienia2332 Год назад

Hi Reza, thank you for great video! Question if I may. Each item from my SharePoint list has various approvers. What expression I need to use instead of manually typing the approver's e-mail address in first Initialize variable? Look forward to your reposonse!

@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

@derrickmurasa9918 Год назад

Hi Reza, Thank you so much for this. Though, when I reach the last section of the demo where there is the Select Data Operation, I'm not getting the 'Claims' option for sharepoint content as you are. Instead I only get 'Created by Claims' and 'Modified by Claims'. Could you kindly elaborate on that for me. Thank you!

@RezaDorrani Год назад

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

@user-fe8bk3ne3z 9 месяцев назад

This is awesome @Reza Question: My group wants a history of approvals. Do I need a separate list of Approvals per request? I see towards the end of the video that 17:35 that there is some history. Is that designed in your list? If I have say 6 approvers and they want to see the history, how do i design my list?

@RezaDorrani 9 месяцев назад

Most welcome. Check approvals playlist on my channel. I have done multiple videos where I have shown saving approval history + video description has links to download the sample flow wherein you can see all the logic.

@ExeterTrees 8 месяцев назад

Thanks for the detailed video - this is just what I was looking for to help a friend out. They work in an office and deal with cover requests which are multi level. So some people only have 1 approver and there are a few that have as many as 5! I've duplicated your power automate and followed the guide and although there are no errors it doesn't email or show the progress in the approvals section. I really can't see what I've done wrong but am sure it will be something minor. The first part of the flow works as the status changes from new to pending - but that is all that seems to happen. I'll see about getting this on a forum later on. Hopefully once I can get your original one working correctly I can adjust it suit my friends setup.

@RezaDorrani 8 месяцев назад

Most welcome! I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

@ExeterTrees 8 месяцев назад

@@RezaDorrani Thanks for the quick response. I'll do that on the forum shortly. I've managed to get a bit further with it so that the approvers are now getting the emails as well as seeing the approval status update. In the flow on step 4 called 'get approvers' there is custom filter: Title eq' @{triggerOutputs()?['body/Expense_x0020_Type/Value']}' With this as above - the flow will run and complete with no errors - but then none of the emails / approval works. If I delete this then I am getting the first part to work - but then get errors on the very last part of the 'Yes' flow. For the moment I have set this up exactly as per your guide so I'm stumped at what I've done wrong. Thanks again for such great resources.

@RezaDorrani 8 месяцев назад

@@ExeterTrees Hey, same response as before. I have not come across any issues hence not sure. Best to try on the forums.

@ExeterTrees 8 месяцев назад

@@RezaDorrani Hopefully I will get some feedback on the forum shortly. One thing I was curious about was the filter you put in the 'get approvers' part of the flow: Title eq' @{triggerOutputs()?['body/Expense_x0020_Type/Value']}' How does the above filter the users selection of the type of approvers? I can't see the reference to the _x0020_ Sorry - my knowlege of Power Automate as you can see is not great - just so close to getting this work and I am confident it is related to this custom filter Thanks again creating these guides and resources.

@RezaDorrani 8 месяцев назад

@@ExeterTrees Video description has link to all details. List, flows etc. I would recommend checking that.

@julien8979 2 года назад

Thank you for sharing Reza. Will it be possible to set a reminder duration for each level dynamically? Example: one the first loop for the 1st approval, if the user did not make a decision within 2 days -> send 1st reminder. After 3 days if also no decision has been taken it should go to the second approval. The number (2 days) will be dynamic as the user can change it from an SP list anytime when needed.

@RezaDorrani 2 года назад

Possible! I did a video on reminders which may help - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ZupQ0AbDl0I.html

@HinaGeo Год назад

Thank you so much for another great lesson. Can you please guide me when I unselect the approval comments column from the view then why do approval comments not show on the timelines? It's showing properly on the timelines in your video even though the comments column is not part of the view.

@RezaDorrani Год назад

The JSON code needs the column in the view. This is by design. Comments is part of my view (it is just moved to corner)

@colinjamieson6065 2 года назад

Thanks Reza, what if I was working with a specific memorandum as an attachment (as opposed to the expense report that seems to be an embedded list)? Action, I upload it to a sharepoint folder, that then kicks off the serial multiple approval, (I would actually prefer to label all other participants in the workflow as "Recommenders" and only the final email address is the approver. I would like this flow to be selectable from Teams (as a Teams approval). If the recommender or approver is reassigned, I would like a comment field for the recommender / approver to comment on the reason. I am battling to figure out how to get past your Update item stage though because Im working with a pdf file rather than an list.

@RezaDorrani 2 года назад

I do not have a video on this use case. Possible for sure. But I would have to try it out myself to provide any guidance. I will recommend you check on the forums at powerusers.microsoft.com/ in case someone has done something similar.

@Sileky 8 месяцев назад

Hi Reza, thanks for the great video! I have one more question. If I want to put approved/rejected date on each approvers in multi-approver system, is there ways to get those? Thanks !

@RezaDorrani 8 месяцев назад

Possible by maintaining a variable. You can append the responses and comments as they come in to it.

@rcbruce841 Год назад

Thanks!

@RezaDorrani Год назад

Thank You

@Justin-oi8bu 7 месяцев назад

Thanks for the great video Reza! I have had a bit of trouble importing the example flow however. It doesn't import so I try to save as new but that throws an error that there are some invalid characters. I have tried a few things but without success. If you have any suggestions that would be great 👍🏼

@RezaDorrani 7 месяцев назад

I have not come across an issues hence not sure. I recommend posting your issue on forums at powerusers.microsoft.com

@sarahc0816 Год назад

Reza your tutorial is the best!!! I have been working on a power app that requires multi level approval, I don't know how to connect an array of approvers to power app startscreen, I have watched the other video you have about text input approver, but as soon as I change the column type to choice column I will get an incompatibility in the logic test. I am quit new to the power app, It will be great if you could give me some hint on this. Also, I will need to figure out how to make them into a parallel approval process...

@RezaDorrani Год назад

I dont know if I have that specific use case. Best thing would be to post your issue with screenshots on the forums at powerusers.microsoft.com since here on chat it is not easy to debug or resolve issues.

@guillirivers9492 2 года назад

Great video Reza, I've a question, is it possible to get the comments from the approval in the Sharepoint Item comments?

@RezaDorrani 2 года назад

I guess you mean the new comments feature in SharePoint. I believe Yes using APIs but I have not tried it.

@blink182joel 2 года назад

Superb!

@RezaDorrani 2 года назад

Thank you! Cheers!

@akmamardzuan3655 2 года назад

thank you for the great help on multiple approval. I want to ask, the approver need to be static which mean insert the email? or it can be dynamic content? as my flow need to check first whether second or third approver exist

@RezaDorrani 2 года назад

Approver can be dynamic. I have done multiple approval videos showcasing dynamic approvals. Check this playlist - ru-vid.com/group/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe

@pierobusci2105 2 года назад

The flow you created is beautiful and very useful, I would need something similar but I would also need to send the attachment for approval. Unfortunately I have never "programmed" in Power Automate and therefore some steps are not very understandable, is there any documentation that you can study to learn how to create flows? is it possible to receive your stream and do a "copy and paste" and then edit it? Thank you

@RezaDorrani 2 года назад

Thanks. Video description has link to download sample App & has the JSON formatting provided. Flow approval attachments - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ShNhn-jSBC0.html

@IdeazSuper Год назад

Hi Sir, Thanks for the great content. I have a question. Is there a way to update status of a document (in document library) after approval is submitted? I tried many videos but usually those are about lists. Status can be changed from pending to approved or rejected.

@RezaDorrani Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NZeJB4dGCq0.html

@wernermarinus1174 2 года назад

Helo Reza, Thanks for the very handy and useful videos you provide. A little side question: in this video you show "card like" badges (see around minute 16'39", with the "Sponsorship for event" item). Is that a special lay out or does this require specific settings in the view of the screen. I like this lay out because is visuales information in a quick and easy fashion.

@RezaDorrani 2 года назад

The card like format uses JSON View Formatting in SharePoint. Video description includes links to download sample flow and JSON schema for card like formatting.

@wernermarinus1174 2 года назад

@@RezaDorrani In the meantime I've found your other great video's on the JSON-stuff for alternative lay outs and screen presentations! Thanks Thanks Thanks, again !

@jasimkhumi Год назад

Thanks a lot for the in detail video Reza, helps a lot. I have a scenario and I would require your suggestions on it, upon approval of the document I would like the approver to attach a document to it eg a pdf file. Is that possible?

@RezaDorrani Год назад

You cannot attach docs in approval flow. You would need to give link to here the approver can upload doc.

@gretchenleighliter9558 2 года назад

Hi Reza! This is a huge help for the project I'm working on. I am new to creating workflows, but I think I can do this. I'm still a little confused about the tiles. Can they be built without SharePoint designer? Or is SharePoint designer where the code is added? Are new tiles automatically generated every time a new expense report is generated? Do you have a video for building a page with the tiles? Sorry for all the questions.

@RezaDorrani 2 года назад

Thanks. The tiles look is built using JSON formatting. Video description has link to the JSON code. I have a playlist on Sharepoint list formatting using JSON on my channel. Check that one. SharePoint designer is not required.

@gretchenleighliter9558 2 года назад

@@RezaDorrani thank you!

@anerdoodai1099 Год назад

Thank you excellent tutorial.I have one question. I am trying to capture the approval comments and names but it only captures the last approver. any insights on that?

@RezaDorrani Год назад

Video description has link to download sample flow. You can check the logic in it. I have not faced the issue of only last approver comments being captured hence not sure.

@bobbyw1074 9 месяцев назад

Thank you for this! If I have a multi level approval that is dynamic where the requester selects the first level approver and so on, would it be ok to create multiple flows where each flow takes care of each approval level?

@RezaDorrani 9 месяцев назад

I am not a fan of multiple flows but it could/should be ok depending on how many levels deep your scenario can go to.

@akshay._.solanki Год назад

Hi Reza, amazing video as always Just curios, what if the last approval is a rejection, because in your demo we are only checking if the its a last approval or not in approve side right? How do we handle if the last approval is a rejection? as I am looking to update the status at the end of all the responses and then check if any one of them rejected, set the record status from pending to rejected.

@RezaDorrani Год назад

You are right! On the left side, you can add a condition to check if response is rejected and take the same steps as right hand side

@kumnegerholdings Год назад

Thank you so much for this awesome tutorial Reza. Is it possible to change the approvers mid flow (if someone didn't respond in a timely manner ) without having to cancel/resubmit and also keep the previous approvers outcome? Assume at the time of submission, only one person is identified as an approver. Is it possible to grab the newly delegated person from the updated SP list and apply it to the running flow?

@RezaDorrani Год назад

Currently there is no cancel approval action. So not sure if there is a way in which this can be achieved. May be check on forums in case someone has a workaround powerusers.microsoft.com

@kumnegerholdings Год назад

@@RezaDorrani Will do. Thank you Reza!

@jeanpaulmartinez4545 2 года назад

thank you very much Reza. I was wondering how i can create an email reminder if request has not been actioned "approve or reject".

@RezaDorrani 2 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ZupQ0AbDl0I.html may help.

@amgtdxb 2 года назад

Absolutely Brilliant, you've made it look so simple. Wonder how one can embed this into a broader solution where approval workflows are part of the larger solution (in a nutshell, how one can avoid reinventing the wheel)

@RezaDorrani 2 года назад

SharePoint lists and flows can be templatized.

@hannawg7747 2 года назад

Thank you Reza. Question:- is there a way to track if an approval workflow has been reassigned to another user and then to write that information back to their approval workflow log.

@RezaDorrani 2 года назад

You would have to query Dataverse Approvals based tables (premium feature) to know if approval was reassigned.

@HabtamuEndalamaw Год назад

Thank you for this. I'm pretty new to power automate and I can't find the email item from the approvers' array on the "Assigned to field "

@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

@jesgardel Год назад

Fantastic as usual Reza!! I've seen a lot of your videos about approvals. But I have one problem when I tried to apply. I'm constructing a document library with approval circle and I used as a base 2 of your videos, paralel approval and serial approval but in both I have infinite loop problem. I think this is normal because I use "when a file is created or modified (properties only)" and in last step I modify properties. The problem starts when I want to avoid infinite looping. I used most of ideas I've seen in internet. Like using flag column or multiline column with null value (I can't use service email) and partially works. It works when I upload a new file, but when I overwrite a file, I can't get flow to start. Reason is that columns used as flag are not returning to default value when I overwrite a file. I've created a column called MultiLineFlag and the library doesn't allow to select "APPEND CHANGES TO EXISTING TEXT", so I've created at Site and the adquire it on library. The column was defined as "Hidden", but anyway it doesn't reset value to NULL when I overwrite a file. I have same problem using other kind of columns like YES/NO. Could you help me to arrive to a solution? Thanks a lot for your videos, they are inspirating!

@RezaDorrani Год назад

Thanks for watching and liking the videos. Your scenario is not something I have tried with files. Overwriting files I believe creates a new file and then you can set its properties. This might be how doc libs work. I would recommend checking on forums or posting your scenario on forums to see if anyone has a workaround for this powerusers.microsoft.com

@jesgardel Год назад

@@RezaDorrani Thanks!! I'll try!

@susana_ellen Год назад

very good 👍👍

@RezaDorrani Год назад

Thanks

@amandaharvey-smith9483 Год назад

Hi Reza, great videos and very informative. I am really stuck with a flow that I am trying to create where I have created a sharepoint access request form and I have an Approvers Matrix List. I need to create a flow that is based on the responses of the form as to which library the requester requires access too as each library has a different approver. I have tried following your other tutorial for dynamic approvals etc but it does not quite get me to sort this out. I am new to automations but I wondered if you could help at all and advise the best and quickest way of achieving the get form responses to look up the list of approvers and based on the department requested it sends an approval request to that approver by email. many thanks Amanda

@RezaDorrani Год назад

It would be best to post your issue with screenshots on the forums at powerusers.microsoft.com It is not possible to provide detailed support on chat.

@mohanadalhiti4300 2 года назад

Mr Reza, Thank you very much for your tutorials, I loved them. please I need to know how we can calculate the total number of days taken/left ? can you help me

@RezaDorrani 2 года назад

Thanks for watching. Calculating total number of days left depends upon where your days left info is stored. You can use Power Automate to connect to any system of record. To provide guidance, I would need to look at your scenario in action. I would recommend to post your query with screenshots on the forums at powerusers.microsoft.com

@sreejarathish 9 месяцев назад

Hi Reza thanks for the explanation... brilliantly done. However may I know how you used the key process indicator and status of the flow moving with each approval done? I couldn't relate to that however it gives a nice and easy view..for Better understanding.

@RezaDorrani 9 месяцев назад

Welcome! The video description has link to download sample flow. You can check the entire logic in it.

@hafizsham1942 6 месяцев назад

Hi Reza. Thanks very much for the informative video! Using this at my current work and your videos have been a lifesaver for me. Am wondering what will happen if at any level of the multi level approval workflow if someone clicks reassign to someone else? Will the flow still work?

@RezaDorrani 6 месяцев назад

Glad to hear that! Yes it will work with reassign. Easiest way to check it out is by testing it.

@achimstrobel3060 Год назад

Many thanks Reza, could you explain the expression in the Initialize Variable "Approvers" works? I can't get the appovers Emails into the variable. How did you filter the array there? (min. 14:49 )

@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

@matthewryan5505 4 месяца назад

Just a general question to the group and @RezaDorrani- Any idea why the approval history only shows one approver even if there are multiple? I checked all actions and everything works correctly. For audit purposes i need to see each approver in the history.

@RezaDorrani 4 месяца назад

The approval history should show all as demonstrated in video. I have not come across this issue and hence not sure what is the cause for your issue. Video description has links to download sample flow. May be you can check the logic in it.

@tomekliebert9282 Год назад

Thank you for useful materials :) Everything is clearly explained, but even though I watched the videos several times and downloaded your flow, I have a problem with downloading from the list of two approvers? Do you have any more explanations for that or do you use this variable in other videos?

@RezaDorrani Год назад

I have a full playlist on approvals which covers a wide range of scenarios: ru-vid.com/group/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe 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

@tomekliebert9282 Год назад

@@RezaDorrani Thank You very much :) I found answer in your movie ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5Mypn4oCJdw.html

@rhumeetsinus 2 года назад

Thanks. Just curious, what happens if the 2nd step user reassigns the approval using the approvals tab in Teams to a previous approver & the previous user then approves? Would the approval go back to the 2nd step user? Can the flow essentially loop? Thanks!

@RezaDorrani 2 года назад

It will not go back to previous approver. Reassign basically means someone else takes ownership of that task.

@omermirza5994 2 года назад

Thanks Reza for your amazing content. I cannot lookup the Approvers as a Person or Group column type the way you have done here. I just do not get the option. I can only pull the ApproversText column. I googled it and found that you can't look up person types. Has that changed recently?

@RezaDorrani 2 года назад

Video description has links to download flow. This works with person type columns and nothing has changed.

@omermirza5994 2 года назад

@@RezaDorrani yes it's working now. I was doing something wrong. Thanks Reza!

@ameensajid9857 2 года назад

Thank you, Reza! Very helpful. On adding the list of approvers as arrays.. Is there a way link this to MS Forms directly rather than maintain this each time there is a change in the response submitted via MS forms?

@RezaDorrani 2 года назад

Sorry, but I did not understand your question

@ameensajid9857 2 года назад

@@RezaDorrani Sorry for the confusion. I am trying to create a process workflow linking Forms and Power Automate. One person will fill out the form and then it should trigger an approval workflow process via Power automate.

@RezaDorrani 2 года назад

@@ameensajid9857 I do not have a video on this use case. I do have loads of videos on approvals and independent videos on forms. You can combine those concepts and get it to work. Alternatively, I would also recommend to check on the forums at powerusers.microsoft.com

@anjlopez4147 Год назад

Hi Reza. Thank you for your informative videos. :) I just have a question, what if my values in the approvers are not solely array-type data instead one of the approvers is based on the sharepoint list?

@RezaDorrani Год назад

I have done many approval videos where approvers are set from array, sharepoint list etc. I would recommend checking approvals playlist on my channel.

@anjlopez4147 Год назад

@@RezaDorrani Thank you. Yup, I'm running through all other videos. However, I always get this error: BadRequest. The variable 'varArrApprover1st' of type 'Array' cannot be initialized or updated with value of type 'String'. The variable 'varArrApprover1st' only supports values of types 'Array'.

@RezaDorrani Год назад

@@anjlopez4147 I would recommend posting your issue with screenshots on the forums powerusers.microsoft.com

@lindatran4195 4 месяца назад

Hi Reza, thank you for sharing this. I am trying to build this into my current flow for leave request. I got everything to work. The only issue I am facing is that the approver sequence in list does not change even though I delete the first user and add them again after. Do you know how to fix this?

@RezaDorrani 4 месяца назад

Most welcome! I have not come across that issue hence not sure

@MTriegs Год назад

Have you seen the behavior in a Persons Type column where it changes the order of your assignees based on an 'internal id'? My set order of approvers is displayed incorrectly in the field when it gets populated from my flow. (The flow still runs in the correct order). Any changes to my approver order has to be done in the Sharepoint Classic View to take effect.

@RezaDorrani Год назад

Some folks have experienced this issue. It probably has to be a bug in SharePoint sites. Some sites have it some dont.

@KimHongTan 2 года назад

Hi Reza, do you have a tutorial video that check the budget first before it triggers the approval ?

@RezaDorrani 2 года назад

I do not. All you would need to add to your flow is a condition action to check the budget amount and accordingly start the approval process.

@valedrink4984 8 месяцев назад

Hola, apenas descubro tu canal, hice algo similar pero usando switch case, no sé si hice lo correcto porque si bien los casos tenían que cumplir con ciertas condiciones, el código que llevan en el cuerpo cada cada caso era el mismo y no siento que sea práctico repetir código entonces ahora estoy pensando implementar algo como lo de tu ejemplo, voy a realizar la práctica y evaluar la mejor opción. Gracias por compartir. Saludos y éxitos.

@RezaDorrani 8 месяцев назад

Better late than never 😊 Welcome to the channel

@agameruputra1553 2 года назад

Hey Reza thanks for the great explanation! I do have one question regarding this approval process. In my case, the approval is already exceeded 30 days and the status indicator is not moving to the next approver even though the approval process is already done to the last approver. How do I solve this issue? Thanks again Reza!

@RezaDorrani 2 года назад

Flows have a limit of 30 days. Handling 30 days approval requires additional logic. An example is here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-h6Eb-F0P6Hs.html

@agameruputra1553 2 года назад

@@RezaDorrani Thanks!

@rahulhadapad5036 2 месяца назад

HI Reza, thanks for the amazing video, just a quick one. What if there is an invoice which needs to be attached in the email how do you do it? thanks again for the amazing videos

@RezaDorrani 2 месяца назад

Most welcome! Check my playlist on approvals. I have shown how to attach files to approval action.

@andjelamihajlovic5614 2 года назад

Hi Reza. At 13:23 of this video you said that the expense type column is a lookup column. To what should it be connected? When i want to create a lookup column one of the fields says 'get information from' and it gives me all the lists within that site. What should i put? Thanks

@RezaDorrani 2 года назад

A lookup column is one that lookups to a different list. You can change that to any other column type of your choice.

@brodyjoebeaver 8 месяцев назад

Thank you Reza. I am trying to duplicate your expression for the final approval status, but I don't know what I am doing wrong. This is what I am using: if(equals(length(variables('varApprovers'('varCounter')),'Approved','Pending') can you help me? I want the final approver in the sequential array of varApprovers to change the status to approved once they have actually approved it.

@RezaDorrani 8 месяцев назад

Video description has link to download sample flow. You can check the logic in it. As for the issue, 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