Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Filter a 2nd SP List based on the 1st List

Hello, I have a rather complex flow in which it will send out a reoccurring emails to teams in the company on open items that they have.. The table inside the email looks like this:

2020-06-24 10_29_31-Window.png


What it is currently missing is the team member's updates that are being collected on another table. I need some help on doing that. 


The 2nd SP list where it collects the updates/notes are down below:

2020-06-24 09_28_10-Window.png


 I will try to explain the current set up, as best as I can the current process down below

2020-06-24 08_34_02-Window.png

2020-06-24 08_37_28-Window.png

2020-06-24 08_39_42-Window.png

see below for all the steps inside of "Apply to each 4"

2020-06-24 08_41_45-Window.png2020-06-24 08_44_36-Window.png

2020-06-24 08_52_06-Window.png


So if I want to get the last update of the RAIL item, it seems like I would need to:

  1. Get SharePoint items (RAIL List - Comments) in the "Apply to each Step"
  2. Somehow filter the new SP list with the body ID (RAIL List) to the RAILID (RAIL List - Comments)
  3. Filter for the last item in the list
  4. Join the data of the last item into the array variable "Append to array variable 2"

I just dont know how I do this though, and some help would be greatly appreciated.






It does appear that this is a complex flow.  I'll try help you to the best of my abilities with the information you have provided.  What I would do is start off with a new simplified Flow so that we can eliminate all the other noise.  In the Flow I would try to get the data from both SP lists and combine the data that you want and write it to your table.  If you are looking to only have the latest note since the last time the flow ran, you can use the timestamp on the flow run to do that.  Once you have that figured out, you can implement that into your existing Flow.   I can try test that part in my environment and get back to you, but that's where I'd start.

Hello @RossB , 

Thank you for your response and your support!

Yes, it is rather complex; If it ain't complex, you ain't doing flows right! 😉

Gotchya, let me see if I can run a simpler flow, and try to combine the data together. 

Helpful resources

Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (31,031)