web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Multilevel approval ba...
Power Automate
Answered

Multilevel approval based on Sharepoint list Choice field

(0) ShareShare
ReportReport
Posted on by 6

I’m struggling with a flow that runs based on a new SharePoint list item trigger.

When a new item is created.

It sends an email to the creator

Starts the initial approval (sends to the unit approver email, which is a lookup field in the list)

If rejected, it updates the list and informs the creator and terminates

if approved it updates the list and informs the creator

*This is where it gets complicated

I start 3 parallel branches.

 

The first branch starts with a condition, the result of a dropdown "action field" is = to "office Lease".

If NO terminates (this may be my problem...).

If YES, it updates the list, sends and email to creator and starts approval to our Security manager.

If they approve, it starts another approval to our contracts department.

 

The second branch is like the first. It starts with a condition, the result of a dropdown "action field" is = to "Consultant".

If NO it terminates

if YES it updates the list, sends and email to creator and starts approval to our EVP/CFO.

if they approve, it starts another approval to our contracts department.

 

The Third branch is similar. It starts with a condition, the result of a dropdown "action field" is = to "Subaward" or “Procurement”.

If NO it terminates.

if YES it updates the list, sends and email to creator and starts approval to our EVP/CFO.

Again, if they approve, it starts another approval to our contracts department.

 

After the flow completes the first approval, it seems to recognize the conditions that are set for the dropdown, but they all terminate with a “fail”. The weird thing is even though the flow fails the email approvals continue, so I’m confusing the flow somewhere.

 

Categories:
I have the same question (0)
  • Verified answer
    ScottShearer Profile Picture
    25,290 Most Valuable Professional on at

    @bgardner2001 

    Please post a screen shot of your Flow.  That will make it much easier to assist.  That said, it sounds like you might be better off using a Switch action rather than a condition.  Here is a link to a blog post that discusses the switch action.

     

     

  • bgardner2001 Profile Picture
    6 on at

    I can try screen shots, but its such a beast im not sure if i can capture it all. I was just looking at switch and i think you might be correct. Let me mess with that and if it doewsnt work ill try to cature the flow.

  • bgardner2001 Profile Picture
    6 on at

     

    first approval

    1.png

     

    2.png3.png

    4.png5.png6.png7.png

     

     

     

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard