Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Approval flow off a string variable built from sharepoint list

Hi Flow community,


I am having some trouble with a Flow that I've built and i'm looking for any guidance


I have a Sharepoint list that contains some deployment wave data:




The goal here is to send out an approval email to each employee (1 email per employee) containing all of their deployment schedule and times. Additionally we only want to send out lines that contain 'Wave3'.


Essentially, based on the data above, there should be two approval emails sent out, one to John Doe and one to Shay. John Doe's email should contain two lines of data (because the one of his lines is Wave2), and Shay should receive two lines.


While i am able to pick off only lines with Wave3 , i am experiencing some anomalies while running the flow. Here is the email that gets sent to each user:



As you can see, it does indeed pick off only wave 3, however, i am receiving emails for both users John and Shay whereas it should just be John. Additionally, it seems to completely ignoring the first line in the sharepoint list. 


Here is the flow that I've built:





I would also like to take any approved lines and change the value of a cell in the sharepoint list from 'No' to 'Yes' for each confirmation. in the above example, if John approves the email, i'd want it to change the value in the "Confirmed" sharepoint list column to 'Yes' for both of his rows of data.

Any help would be greatly appreciated!


thank you,




Frequent Visitor


Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,737)