Power Automate Dynamic Conditional Approvals with SharePoint List | Select Approvers & Approval Type

[@MohammadAli-ts2ev]

Thank you Reza for covering many things in a 25 min video. I am working on an approval flow and your Approval flow CookBook series is of great help. I will copy the HTML part of creating a nicely formatted table from this video. Thank you for making our life easier

[@RezaDorrani]

Wonderful! Thank You!

[@Dje-ij5zg]

This literally saved my life. Thanks Man!

[@RezaDorrani]

You're most welcome!

[@anitabhanja7480]

Thank you, Reza. Your videos are amazing as always.

[@RezaDorrani]

Glad you like them!

[@dcpowered]

Another excellent video!! A reference for all of us!!

[@RezaDorrani]

Glad it was helpful!

[@cvkealey]

Amazing work, as usual! I'd never thought about making the type of approval or reminders dynamic...I'll have to remember that for future "approval" projects.

[@RezaDorrani]

Glad to hear that! I feel dynamic approval types have a lot of potential.

[@oluwatobiyusuf]

Thanks for sharing. Moving forward, I will try to make my flows dynamic

[@RezaDorrani]

You got this!

[@shashikanthduddukuri6228]

Thanks Reza , nice video on the approvals.

[@RezaDorrani]

You are most welcome!

[@gunasekaran4288]

Great Reza..you are all videos is wonderful topic and clear explanation

[@RezaDorrani]

Thank you so much 🙂

[@Michael9531]

Thank You Reza! Always something new and surprising! Hope I can use the dynamic approvals as soon as possible :-)

[@RezaDorrani]

Thanks Michael. I have another video coming next week which is even more dynamic :)

[@AshrafTheVoyager]

Great video. I have created some flows with help of your videos on Power Automate. Thank you.

[@RezaDorrani]

Most welcome

[@VakulMore]

Perfect !! Covered all the components of an approval workflow. If possible, please add a link/topic with a video on reminder workflow for any approval in the Description.

[@RezaDorrani]

Glad to hear that! Approval Reminders is covered here kzbin.info/www/bejne/kKbTgmN3l6mfZqs

[@corywarshaw4100]

Jeez Reza, you continue to do my job for me! Thank you!

[@RezaDorrani]

:) Il tell you something. My video on approvals next week is 1 better than this (as per me).

[@ChrisSimmsJr]

Great video! I'd love to see a video on how to log cycle times for how long it takes for approvers to approve requests.

[@RezaDorrani]

I have covered logging approval times in one of my approval videos. Check this video kzbin.info/www/bejne/ooqoaIGOiamDgLs

[@kishorekrishna83]

Great work Reza I am huge fan of your videos learning new things in sharepoint power automate. If possible can you make a video on sharepoint list with approval cards on teams.

[@RezaDorrani]

I have done videos on approvals in teams. Check the videos on my channel :)

[@manassehkisame6286]

Legendary Teaching!

[@RezaDorrani]

Thank You

[@arantxagonzalez1842]

Thanks ! Great video. Do you know if I can use the same condition for a approval when the user can select 1,2 , 3 or up to 5 approvers? How can I program this when the number of approves can change? Thanks!

[@RezaDorrani]

Check my video on multi step approvals.

[@necdetsaritas8722]

Great . Thanks for the presentation

[@RezaDorrani]

Thank You for watching

[@AlexJann23]

Hi Reza, I'm trying to create an approval using the "create an approval" and "wait for an approval" using dynamic approvers. If the 1st approver decides to re-assign the approval to a co-worker, is there a way to find out that the approval request was re-assigned? I'm trying to look out the output of the "Wait for an approval" but could not find anything there. Thanks and love your videos!

[@RezaDorrani]

Reassignment info is not provided as output by approval actions. One option would be to store the name of the original approver in a variable. Once the approval response is received, check the name of the approver against the variable. If different, then it means it was reassigned.

[@AlexJann23]

@@RezaDorrani Thanks Reza!

[@ghcstar88]

Thanks Reza. I am working on approval that have to select approver base on project name. There are several group of apprrover depending on project. Could you share how to do it?

[@RezaDorrani]

Check my latest video (might give some ideas) - kzbin.info/www/bejne/iGKbkKSPi7WKopY

[@aaaaa601]

👏👏👏🙋‍♂️🙋‍♂️🙋‍♂️ thks Reza

[@RezaDorrani]

👍 👍 👍

[@mojtabakhooshrou1904]

Thank You Reza for Teaching :)))))))))))))))))))))))))))

[@RezaDorrani]

Your most welcome

[@pepeto1975]

Thank you Reza for all your help. I've a question. Why does the reminder duration isn't in a loop in this flow? I want to explain. If I set the reminder duration as Minute and the unit as 5 I receive every 5 minutes a reminder until I approve. If I set reminder duration as hour and unit as 1 I receive a reminder just one time after one hour and after that the remainder flow stops. The flow is the same that you explain in your video. Many thanks for your advice

[@RezaDorrani]

Reminder logic is based on template. Reminder units - how many reminders to send. Duration - time of reminder. Im not sure why it would not work in your case.

[@sonechak]

Thank you Reza for another great video. Please can you share some light on how I can create conditional approval to specific approvers based on the amount i.e. up to 500 to the manager, 501-1000 head of the department, 1001-5000 director etc.? Thank you

[@RezaDorrani]

I have done many approval flows. They are in a playlist on my channel. Not sure if I have one specific to your scenario. I recommend checking the playlist or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@chadtaylor4539]

Thanks Reza!!! Your videos are always so easy to follow and understand. I’m curious if you know of any way to trigger a flow from a selected item using a flow not in the “default” environment?

[@RezaDorrani]

Yes there is. There are some things to consider prior to taking the step. blog.atwork.at/post/Power-Platform-Environments-and-Governance-Tips

[@RezaDorrani]

Also check twitter.com/rezadorrani/status/1509595696143511557?s=20&t=jxK0zb-rQ1W2af2ne8-sMw

[@chadtaylor4539]

This is both a nicer approach than the default trigger plus allows the flow to reside in other environments which I thought was a current limitation.

[@elishahollandbeck-waybrigh7160]

I lucked upon your site and am now taking a deep dive into all of your content. LOVE IT. I have a question regarding the update item trigger with a MAJORITY approval condition rather than first to respond or all. Can you set it so that if a majority of the approvers approve, the item/document is approved? Further, can you add a custom response in addition to Approve and Reject? I am thinking of creating a workflow for corporate compliance where the Board of Managers need to vote on an action that can proceed with a quorum. For example: there are 5 managers, and if at least 3 respond with approval or abstain, a quorum is present, and the action is approved if a majority of those present approve. That said, I would want ABSTAIN to be an option in addition to Approve or Reject. Is that possible?

[@RezaDorrani]

Thank You! Majority Wins - kzbin.info/www/bejne/mWXEZJKMiqmqoZI

[@cheriseroot2386]

Thank you so much for this video.

[@RezaDorrani]

You are so welcome!

[@simonbelieve]

Hi, thank you for your very valuable videos, they have been very useful in getting familiar and learning Power automate. There is one thing I've been trying to accomplish and was hoping you could do a video on, I would like to create an approval flow email that allows the approval of multiple items on the list based on a condition, for example if they have been approved in the first phase then all the rows on the list with a phase 1 approval status would go to second phase approval but all at ounce instead of an email for each one. Since the final approver is the same person and they want to received a consolidated approval list and then approve or reject from that list via email. Thanks

[@RezaDorrani]

Thanks for the topic suggestion. I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my KZbin channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.

[@nununu8]

Hi Reza, Firstly, that you for all your work and vids. they have been very helpful. I just have a question which i am hoping you can help with. I've customised one of these approval templates (wait for all responses). Currently i am able to cancel the request and also re-assign to new users, but there is a need for the requester to possibly remove a user from the approval list. I can't seem to get this to work. Do you have a solution? thank you. Canceling the request wont work as we may already have some responses from other approvers and we don't want to resubmit a new approval. i have played around and deleted the entry in the approvalrequest table and this has changed the status of the approval to complete, but i dont think this is the correct solution. This also didn't not allow the flow to progress to send the final email with all the tabled answers. I can see in the flow there is logic to check if 'ApprovalDone' is set to 'true' before email, but i'm not sure where i can set this in the tables? Thank you for your time. Regards

[@RezaDorrani]

Thanks for watching and liking the videos. I recommend not to update the standard Approval Tables in Dataverse (Reason: Microsoft owns the schema of those Tables and it could change). It is not recommended to make modifications to it. Currently, Only way to achieve your requirement would be to modify those tables (which is not recommended). I have not tried your scenario hence not sure what the best path would be. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@JohnBaron-o4m]

Hi Reza, Great videos! I was wondering if it was possible to create an automation for the following flow: - User request access to a specific folder X - Depending on the folder the approval request is sent out to certain Managers (different managers per folder) - Once Approved it will create a ticket in Jira saying that "User is approved to have access to folder X" Thanks!

[@RezaDorrani]

Possible but not something I have tried

[@robofski]

Never fail to learn something from one of your videos. Great content as always :-)

[@RezaDorrani]

Glad to hear it! Thanks Dan

[@julien8979]

Thank you for sharing Reza. Will it be possible in case of rejection to send the approval back to the requestor to amend some changes to the form and resubmitted it to their managers with the Dynamic conditional approval process instead of raising a new request? I noticed you already did that in a state machine workflow but wanted to see if it is possible in the dynamic approval process.

[@RezaDorrani]

It is possible here by including the state machine pattern in here as well. Just that the workflow will get complex.

[@julien8979]

We look forward to a video that can cover this dynamic approval concept by including the state machine.

[@RezaDorrani]

@@julien8979 I will need a lot more folks requesting this topic in order for me to add it to my backlog which is packed :)

[@gustavoribeiro1956]

Hello. Thanks for the video. Was any content created related to this question by Julien?

[@antonio01841]

Hi Reza, I like your videos. They have taught me a lot and helped me create new products for my job. I do have a question: How can I get the approval to happen straight from the email and the comments for the approval or rejection instead of going to the Power Automate approvals board? Everytime I get the email it sends me to the approval panel in power automate instead of giving me the submit button in the email. Hope I could get some help. Thank you for all the video. I hope to you keep doing videos for us to learn.

[@RezaDorrani]

Most welcome! Actionable approvals is an out of the box feature in emails. Check supported outlook versions in documentation.

[@antonio01841]

Thank you. I'll take a look@@RezaDorrani

[@Rinakor87]

Hi Reza, thanks so much for the video. Is there a way to send multiple approval requests creating just one form, but making a flow check multiple items requested and send approval requests? For example, I have a lab access request form that uses the approval matrix to send lab access requests to a corresponding approver based on the lab. However, a requester has to create multiple lab access requests for different labs instead of submitting one single request for multiple labs and having the lab owners only to approve the lab access to the labs they actually own. Is that a possible thing to do? Possibly, you already have a video on that? Thank you

[@RezaDorrani]

Multiple approval pattern is currently not an option with flow.

[@lindseyfreeland8742]

I am having an issue with a very similar approval flow. The key differences: - Trigger: When an item of file is modified with a conditional approval (based on another one of your videos) that the status must be pending so it only routes for approval once the creator hits "Submit for Approval" - I want approvers to be able to make changes to the file during the approval process without killing the flow My approval flow works perfectly when files are not modified, but when an approver tries to make an edit, the flow is killed / does not continue on to the next approver once the approver reviewing / editing approves. Is there a resource you can point me to that creates sequential approvals but allows for items to be edited? I originally tried to use the "When a file is created" trigger, but then it would fire before the files were ready for review. Appreciate your videos and help!

[@RezaDorrani]

I have not covered or showcased a scenario like this in any of my videos. I would have to recreate your scenario and then try and figure out a solution. I would recommend posting your query on forums. May be someone has done something similar. powerusers.microsoft.com

[@lindseyfreeland8742]

Posted last week, so fingers crossed an answer will come through!

[@RezaDorrani]

@@lindseyfreeland8742 Forums is a free platform. You may or may not get a response. If its urgent, then you would need to look into getting consulting help.

[@dominikpetri2120]

Great work! Thanks for sharing! Instead of using the variable, why didn't you use the terminate action to stop the flow in the no branch of the Manager Approval Condition?

[@RezaDorrani]

Thanks for pointing this out. Terminate is an option as well. I had that also as a pattern but I had to keep the video to a specific timeline. My videos end up with 1.5 hrs of recorded content. After editing it comes down to 25-35 mins. Sometimes some good info gets lost in editing.

[@kenm3528]

Hey Reza excellent video as always from. In the flow template generated later in the video, how can I put the approves that have been selected into update an item, so I can use your json formatting from another one of your videos?

[@RezaDorrani]

Thanks! I would have to try it out to know how :)

[@kenm3528]

@@RezaDorrani if you figure it out let me know. I love the format on one of your other videos which shows the approvers on the gallery tile and I’d love to be able to do that for these approvals.

[@RezaDorrani]

@@kenm3528 Thanks so much! I have no plans to figure this out as I am working on my next set of videos.

[@kenm3528]

@@RezaDorrani oh sorry. I misunderstood your reply. No worries. Looking forward to more 👍

[@pepeto1975]

Thank you Reza your tutorials are very useful. I've a question. May I see the approval status (who answered and who didn't?) directly from the list? In the second part of the video, I see this information only at the end of the flow

[@RezaDorrani]

I have done several videos on storing approval history in list. Check my playlist kzbin.info/aero/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe

[@clarissadeguzman902]

Hi Reza, your videos are a great help. Just one question, how could I display the names of the approvers in the record? I need to monitor who are the expected approvers to approve the request. Hope to receive your reply. Once again, many thanks!

[@RezaDorrani]

I have done 18 approval videos - listed in approvals playlist on my channel. I have shown how to save names of approvers. Il recommend to check those.

[@clarissadeguzman902]

@@RezaDorrani Thanks Reza. Will check :)

[@luizlima86]

Your videos are always really good! I need to create a flow, which according to the value and the company, it takes the approvers that are parameterized according to the company and value in a second list. Could you make a video teaching?

[@RezaDorrani]

I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my KZbin channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.

[@nissaaramworkouts8248]

Great video as always Reza! Would this flow suit for the OnSuccess of Power Apps for an approval type app?

[@RezaDorrani]

The flow can be called from Power Apps. The pattern would work there as well.

[@OyinOlapade-z7e]

Hi Reza, this was super helpful so thank you! I have 1 question, i am trying to set up a condition after an approval, i want it set different actions for when the request is approved and when it is rejected but there is no 'content' option, do you know if there's any other way i can do this?

[@RezaDorrani]

What is content option? Can you point the time in video where this was shown?

[@meinama]

Hi Reza, Great videos for people like me who are new to Power Automate and also the Power App topics. Definitely earned me as a sub! Would a dynamic conditional approval flow using a sharepoint list be suitable for the scenario of having multiple entries in a SPO list? Using Microsoft's invoice/finance scenario, instead of adding 1x invoice per line, can you have 5x invocies in one line for an approver to approve or deny? I imagine you then have the issue of if one invoice is denied, the whole flow would fail.

[@RezaDorrani]

Thanks for the sub! Approvals run per item. The response provided will be item centric. There is no option currently to approver/reject per line.

[@meinama]

@@RezaDorrani Appreciate the response, thanks.

[@NurfarhanaIzzatibintiAzizi]

Hi, a quick question from a newbie me. Can we schedule the power automate to run once daily and combine all of our items that need approval in one email. If possible, how do we approve the items.

[@RezaDorrani]

Probably possible but I do not have a video reference on this scenario. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@chandreshmehta2651]

Hi Reza, great video thank you for making this one...just wanted to ask is there a way to attach a document and send it on email for approval using power automate, dont want to link it to onedrive though

[@RezaDorrani]

I have done a video on approval attachments. Check that one.

[@mustafahussainmohsin320]

Great Video! If I have 10 approvers do I need to add them like that will it be a longer flow??

[@RezaDorrani]

Check kzbin.info/www/bejne/nZPCd4ibh8-anZY pattern Every video I make I try to show something different. Most of my concepts are across multiple videos.

[@nathankirui796]

Nice Content Reza, I have a question, been trying to look into your tutorials, supposed the manager approver doesn't want to reject or approve but instead asks the requester to provide more details, etc? What would that flow look like?

[@RezaDorrani]

Flow would be very different. Here is my approval playlist - kzbin.info/aero/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe I think I did a state machine approval workflow scenario that has a similar scenario.

[@moetoledo]

Thank you Reza, as usual It's another great work. My question is what if the request is multi level approval but it requires two people out of three to approve it, to make the request move to the next team of approvers? (2 approves & 1 reject = approved) (2 reject & one approved = reject)

[@RezaDorrani]

Check kzbin.info/www/bejne/nZPCd4ibh8-anZY

[@pratikpanjwani2774]

Hi Reza, Your videos are superb and simple to understand.. I would like to have condition in approval flow where 1st approver need to choose whether it should go for next approval or not … is it possible in power automate.

[@RezaDorrani]

Power Automate approval forms do not have am option for customization. Comments box and approval buttons are all we have for now.

[@pratikpanjwani2774]

@@RezaDorrani is there any work around .

[@RezaDorrani]

@@pratikpanjwani2774 Im not aware of any. Check on the forums.

[@josmas3]

Your videos are great. Ask. I want to make an approver from power apps. and that it is through power automation and when it is sent by mail or by teams. You can update these approvals also in power apps. Could you help me how to concatenate these approvals that are given in different ways.

[@RezaDorrani]

Check my playlists on approvals. I do not have a video on your exact scenario though and would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@josmas3]

Thanks. I'll check those forums and see if I can find anything. Because I follow your videos and I have seen almost all of poweapps. The flow of approvals that I have is born from a model of your initial application of ticket submissions. but now i want to unify all powerapps, outlook, teams. and can approve from anywhere. since users always want all the options.@@RezaDorrani

[@RezaDorrani]

@@josmas3 Users always want more.

[@josmas3]

@@RezaDorrani yes, that's true. Thank you for your contribution always.

[@YogendraSingh-eq6kt]

Hi Reza, This is a wonderful video. i have one question where I stuck in one of my power automate workflow. business doesn't want to receive email from Power Automate, they want to receive emails from a their own distribution list. Same time business also don't want to provide access to our workflow account. how can we solve this issue.

[@RezaDorrani]

Not sure about this scenario since I have not come across this scenario.

[@taylorwest6680]

I cant figure out a solution to this scenario... A manager starts an approval process, another manager might be on vacation or busy and doesn't have access to their emails for a period of time. I need to figure out a way for the manager that started the process to be able to approve the document for another user. Maybe the other manager can't directly approve it but has seen the document and verbally approves it. I need to give some sort of option for the manager to approve it for the other manager so the flow can continue.

[@RezaDorrani]

You could auto approve if not responded for a specific duration of time or escalate to a different user. I have a full playlist on approvals that covers a wide variety of scenarios. I will recommend checking it out.

[@NothinG21halo]

You are magnificent, thank you Reza

[@RezaDorrani]

Most welcome

[@markus3404]

Hi Reza, what if i wanted to add another level of manager to form a sequential approval? Im having issue of validation failed when i try to create a flow that have 2 different managers to approve

[@RezaDorrani]

Check my video on multi step approvals kzbin.info/www/bejne/nZPCd4ibh8-anZY

[@markus3404]

@@RezaDorrani Thanks Rezza!!

[@markus3404]

@@RezaDorrani Hi again, i have tried that guide and it worked nicely. And i managed to use Power Apps to create the List items to trigger the flow as well.... Thanks again Rezza!

[@RezaDorrani]

@@markus3404 Awesome 👏

[@dshepherd6085]

Is it possible to have manager approve, but if they do not approve after 1 day then it goes to the managers manager? This has me stuck. We can not manually plug in names since everyone has different management.

[@RezaDorrani]

Check kzbin.info/www/bejne/qGnNnGiunsyjh8k

[@abisheckdoss6373]

Thanks a lot, I am working on a flow where I am using an action called "when an http request is received" to trigger my flow from the html page, after doing all actions in my flow I am sending back response to my html page ,but when an execution time is more than 2 mins flow will through time out error . Is there any solution to showcase our response in webpage ? Hope you'll answer my doubts!!!!!

[@RezaDorrani]

Flow must respond in 2 mins. Not sure if there is a workaround for this. I will recommend checking on forums at powerusers.microsoft.com in case someone has done something similar

[@dazrellfleming6068]

Is there away to powerautomate from a sharepoint list to one drive. So users can sign documents in pdf. And then sync one drive back to sharepoint list,

[@RezaDorrani]

Not sure about that. I will recommend checking on forums at powerusers.microsoft.com in case someone has done something similar

[@_uky]

Is possible for approver to fill out several fields on the list item first before approve it?

[@RezaDorrani]

Approval form only has the approval options and comments. There is no option for custom form.

[@thewanderingcouple8378]

I did not understand the fast part when you have added initial variable for HR approval. 😢 How that worked I need to understand..

[@RezaDorrani]

Video description has link to download sample flow

[@wyattparsons9799]

I am having trouble having the approval comments show up in SharePoint. Is there any trouble shooting that I can perform?

[@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

[@amankhanal8047]

Hi Reza, is there a way to notify the requestor whether his or her approval has been approved or rejected "WITHOUT" using email ( outlook, mail) ? I am asking this because at my company for some reason our outlook does not work and manger is not doing anything about it :(

[@RezaDorrani]

Not sure I understand your question. You are free to use any technique to notify user. There are many other connectors available.

[@amankhanal8047]

@@RezaDorrani thanks for your quick reply. Yes, unfortunately since I don’t have access to mail, i think using teams mortification might be best option. Thanks again

[@sravanireddy573]

I am in confusion what is the use of HR approval variable in the flow? How can we come to know HR approval as true without mentioning the variable inside the Sharepoint columns dynamically? Can you please guide me?

[@RezaDorrani]

HR Approval is needed or not is set dynamically in SharePoint config list. The flow reads that information and accordingly sends it for HR approval if needed.

[@sscolimon]

How do I go about updating a sharepoint list to approved after ALL the approvers approve. The approvers are dynamic, it can be 5-18 approvers. Note: i'm using a custom start and wait and the users have the option to only "approve" (no "reject" option)

[@RezaDorrani]

I have done many approval videos where in at end of approval process I update status to approved irrespective of how many approvals. The type of approval does not matter. Check my approvals playlist.

[@musicmania9837]

Hi Reza, is it possible to create questions answers in between each approval workflow, like if we have 7 approvers to approve to the request but before approving or rejecting approver want to question for their doubt any of the approver can ask the questions from CCD emails and then after satisfied with the answer user will accept or reject, is it possible to do?

[@RezaDorrani]

Currently, approval forms cannot be customized. However, I have shown ways using power apps to build your own forms (does not use flow approvals though)

[@musicmania9837]

@@RezaDorrani okay ,Thanks.

[@musicmania9837]

@@RezaDorrani Any suggestions how we can achieve this using PA

[@RezaDorrani]

@@musicmania9837 I dont think there is an option

[@musicmania9837]

😮okok,gotitt. Thanks​@@RezaDorrani🙏

[@karamanipon8908]

I tried the Integrate PowerApps option but I got this statement "The power flow's logic app flow template was invalid. The 'type' property of template trigger 'manual' at line '1' and column '9494' has the value 'Manual' which is deprecated in schema version '2016-04-01-preview' and onwards" I wonder what went wrong

[@RezaDorrani]

That’s probably because template is old. You can ignore that error and try saving the flow.

[@karamanipon8908]

@@RezaDorrani Thank you so much, sir! Is there a way we can make this a serial approver process?

[@RezaDorrani]

@@karamanipon8908 I would have to try it out to know the steps. I have done 18 approval based videos. You can probably combine logic from multiple videos.

[@MajidKhan-rw6ee]

Hi Reza i need you help i have created a workflow by watching one of your videos, I want you to help me that the workflow should be routed to the only person whos name was selected in the ms form and updated on share point. means if person A is selected as program chair in the MS form the workflow should be routed only to that person

[@MajidKhan-rw6ee]

can you please let me know how can I connect with you :)

[@RezaDorrani]

I recommend posting issues/queries with screenshots on the forums at powerusers.microsoft.com

[@devagunalan1056]

Hi Reza This was very helpful but I guess this techniques does not apply to the current PowerAutomate version unfortunately. It throws an error using this technique. I thought I should let you know. Cheers

[@RezaDorrani]

As far as I know, 99.99% of the flows that work in old version is supported by new version. You can always swap to the earlier version.

[@nagarjun572]

Please do a video of SharePoint URL links and external links both url can validate or not using power automate flow...

[@RezaDorrani]

I will need a lot more folks requesting this topic (specific scenario) to add it to my backlog. This is the first on this topic. I will recommend checking the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@thotapriscill9536]

Hi Reza..I need solution for this!! I have a SharePoint list which consists of list items that expiry after sometime..I need to send mail via power automate before 120days of expire to the respective owner's Email ID .here 2or 3 times expire on the same day...but we need to send only 1 mail to the person..do you have any solution for this?

[@RezaDorrani]

This may help - kzbin.info/www/bejne/qqGTm3-korCWe9U

[@s.n.senthilnarayanan749]

Excellent.....need one suggestion Instead of reject how to change the request amount

[@RezaDorrani]

Approvals does not have a form option to make updates. User/approver would need to go to the item to make the changes.

[@s.n.senthilnarayanan749]

@@RezaDorrani Thanks for the reply... Agree....went inside and changed the amount.. But still card still opened.. how to deactivate approval button once the amount changed

[@RezaDorrani]

@@s.n.senthilnarayanan749 there is no deactivate action. Check if value has changed and if yes (event though approver responds), do not take an action. I recommend to post queries on forums with screenshots at powerusers.microsoft.com

[@s.n.senthilnarayanan749]

@@RezaDorrani Thanks.... Amount changed.....but the concern here is, after amount changed.....approver again going to approve button and approve the request... Once any action in the approve button, amount again changed as per initial request To avoid this confusion i need either of the following 1. Deactivate approve button 2. Need 3 button like approve, reject and modify Pls advise

[@RezaDorrani]

@@s.n.senthilnarayanan749 Plz post your query on forums. I do not have a video on your use case.

[@playoffice4310]

Can this be done when a form submitted!?

[@RezaDorrani]

Possible! I have done 18 videos on approvals. Check approvals playlist on my channel.

[@hussainrao15]

Hi Reza, i have a requirement , Requirement : i am having 5 approvers, need to send approval request to all these 5 members, i want to capture each person response irrespective of approve/reject immediately. Can you help me on this, i don't want parallel branch because no of approvers may dynamic

[@RezaDorrani]

I do not have a video reference for this scenario and would have to try it out to know the options. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@guojieyang497]

May you be able to publish a vedio to explain how to extract attachment from component "selected item" and "get item", and send email with that attachment after approver approves, please！！！❤❤❤

[@RezaDorrani]

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 topics get added to my backlog.

[@guojieyang497]

@@RezaDorrani thanks so much, can you give me a quick advice on how to extract attachment from get item, i am stuck in here several days, no more material to refer in Internet, if you feel comfortable, give me some quick guidance, if this burden you, just ignore me, thanks as still

[@RezaDorrani]

@@guojieyang497 I will recommend posting your query on forums powerusers.microsoft.com as I may have any video references on this.

[@sundrapillay6668]

Thanks Reza

[@RezaDorrani]

Thanks for watching Sundra

[@morevikin]

Hello Sir, big fan of you... I am having problem with power automate Whenever I tried to update the some fields in SharePoint list using ms flow, ms flow update the column 'Modified By' to flow creator. How can we avoid it?

[@RezaDorrani]

If item is being updated by flow which is running under creator account, the modified by will show their name. I believe there is a rest Api endpoint which allows writing modified by field. I do not have a video reference on it though and would have to try it out to provide the steps. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@morevikin]

@@RezaDorrani thank you so much sir

[@ronniem2628]

can i get the material ?

[@RezaDorrani]

Please check this full document thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=GVrSLBDk3Eg