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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Issue With Flow Pullin...
Power Automate
Unanswered

Issue With Flow Pulling Data From A List

(0) ShareShare
ReportReport
Posted on by 10

I have set up a sequential approval flow that is triggered by right-clicking on any file and selecting to run the flow. The flow then proceeds to file properties to populate the approval card, and to get approver items from a sharepoint list I've created. This list has 3 entries, each of which are assigned a level to allow the flow decide at what step each approver gets brought into the process (so if user is assigned level 1, they get the first approval request, user who is assigned level 2 won't receive an approval request until level 1 user approves and so on).

My issue is that the list of approvers is dynamic, so for example I changed the level 2 approver to someone else. I re-ran the flow with this new approver but it continues to send the approval request to the old approver. If I look into the outputs of the flow results for the Get Items - Approvers step, it looks like it's pulling the correct data from the list. However, when it gets to the Apply to Each Approver Stage, it still seems to be using the old data for the second approval.

Any ideas why this might be, it's important that I can change approvers or the order their approval is sought, hence why I used the list in the first place e.g. I wanted to be able to easily change approvers as necessary?

Attached Powerpoint has 2 screenshots below of the flow process, let me know if there's something specific you need to look at.

All suggestions greatly appreciated.

 

 

 

Categories:
I have the same question (0)
  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    Having approval action in a loop is not going to work.

    What I suggest you do is:

    1) Loop through the list of approvers and create a concatenated string like (a@abc.com;b@abc.com;c@abc.com)

    2) Add a single approval action assigned to this concatenated string

     

     

     

  • Rookie_User Profile Picture
    10 on at

    Sudeep, first off, thanks for replying, all assistance is greatly appreciated. As it turns out, I went back over my build from scratch yesterday, and found the issue which it was pulling from the wrong list, hence it was sending all approvals to the wrong user. Therefore, can't verify if what you suggested above worked. However, what I can say is that the loop is working for me, I have a condition in that it won't move to the next approver unless the outcome for the previous approver is an Approval. The build I'm using is broadly based on the approach suggested in this Mark Weston video.

    (1657) FlowBites: Creation sequential approval processes in Power Automate - YouTube

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

Forum hierarchy changes are complete!

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

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard