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

Community site session details

Session Id :
Power Automate - Building Flows
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.

 

I have the same question (0)
  • Verified answer
    ScottShearer Profile Picture
    25,268 Most Valuable Professional on at
    Re: Multilevel approval based on Sharepoint list Choice field

    @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
    Re: Multilevel approval based on Sharepoint list Choice field

    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
    Re: Multilevel approval based on Sharepoint list Choice field

     

    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

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 544 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 482 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 287

Last 30 days Overall leaderboard