Skip to main content

Notifications

Community site session details

Community site session details

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

 

 

 

  • Rookie_User Profile Picture
    10 on at
    Re: Issue With Flow Pulling Data From A List

    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

  • SudeepGhatakNZ Profile Picture
    14,303 Most Valuable Professional on at
    Re: Issue With Flow Pulling Data From A List

    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

     

     

     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,668 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow