Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

How to add condition for threshold in Start and wait for approval

(1) ShareShare
ReportReport
Posted on by 68

Hello everyone, 

 

Below are screens from my flow and now I need to add another condition, that if total cost is higher or equal to 50000 the flow should go to 4th approver, however if is less than 50000 should stop on 3rd approver. 

I tried several things, I added new condition but then I am exceeding max nest. I add new row for condition 2nd but then if 3rd approver approves and total amount is less then 50000 it goes to false. 

So I honestly dont know how to add this condition. Somebody help please! 

 

PolaCB_0-1720015401199.png

PolaCB_1-1720015453667.png

PolaCB_2-1720015486548.png

 

 

  • PolaCB Profile Picture
    PolaCB 68 on at
    Re: How to add condition for threshold in Start and wait for approval

    Thanks! I actually solved it with Switch option. 

     

     

  • David_MA Profile Picture
    David_MA 8,929 on at
    Re: How to add condition for threshold in Start and wait for approval

    I would take a different approach:

    • Create one workflow for each of your approvals.
    • The first workflow will be triggered when a new item is created and will go to your first approval.
    • The workflows for approvals 2 through 4 will be triggered using the When an HTTP request is received. Note, this is a premium action so you will need the appropriate licensing. 
    • In each of the workflows add a switch based on the outcome of the approval. If the request is approved, add a condition to check your dollar value to see if it needs to go to the next level. If it does, on the yes side of the condition use an HTTP request to call the next workflow. If not, do whatever you need to on the no side.

    It will look like this:

    David_MA_0-1720024401055.png

    For the HTTP request action, you will want to pass the ID from one flow to the next starting with the one that is triggered when the item is created. You would use this in the body of the HTTP request to send it along:

    {
     "ID": @{outputs('Get_item_Purchase_Request')?['body/ID']}
    }

    Then in the workflow that is called, you will use the following for the JSON schema to accept the ID value:

    {
     "type": "object",
     "properties": {
     "ID": {
     "type": "integer"
     }
     }
    }

    You will then use a Get item action with the value from this ID to get the corresponding item to process it through the next step.

     

    One big advantage with this method is that each workflow will have its own 30-day window to complete. With four approvals, you'll have 120 days for the process to complete. Putting everything in one flow will limit you to just 30 days.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard