Power Platform Community Forum Thread Details

Hi,

I have a business requirement where I have SharePoint list of approvers with two category Domestic and International. When user raises a Domestic or International travel request it first goes to the manager of the requestor for approval. If the request is approved by manager the requirement is to verify if the manager is present in the Domestic or International approvers list based on the value selected.

If yes, the status of the request gets changed to Approved

If no, then it should check the manager's manager and send email to him. After approving it should again check if this new manager is present in the approver list and the cycle goes on until the manager is part of the Approvers list.

Is there any way to implement this a single flow. As a beginner in power automate I have the below idea which I dont think is a viable solution so I may need any of yours expert opinion to handle this requirement.

Create separate flows for creation and modified, the creation flow will send email to immediate manager and after approval it will check the list and set another field in SharePoint called Present to Yes or No. The modify flow will check if the Present condition is no and then get the manager of the manager and check in approver list and update accordingly. I will put a trigger on the modified workflow to run only when the Present value is No.

Thank you,

Categories:

Building flows