You’re offline. This is a read only version of the page.
229
Hi,
As the subject says I'm trying to create a flow to filter a sharepoint list based on the values from a table. That is, given Table [T1] and SharePoint List [SP 2] below, I would like to filter SP2 to get only the rows in green.
Name - Code (T1)
John - 2
Jane - 3
Name - Code - Month - Total (SP2)
John - 2 - April - 50000000
Jane - 3 - May - 6000000
Jake - 4 - June - 333333333
Jill - 1 - October - 25000
Jane - 4 - Feb - 100
Jane - 3 - August - 300
I am trying to put an APPLY TO EACH row in T1 (2 iterations) and then FILTER SP2 so I will get the following
Next step would be to join the records from Iteration 1 and 2 but I'm failing in join them (using Append to Array but it is not working). Screenshot below
Can anyone help me out with
1) If there is a better way of doing this
2) How can I merge the records got in Iteration 1 and 2.
Kind Regards
Hi @Sam4 ,
I think you have adopted a very appropriate plan to deal with your needs.
We often use Apply to each to deal with collections. You even use the Filter array to process the data.
But I don't seem to understand your second question, could you provide more explanation?
If you want to group items, you can refer to the following article:
Do Group By in Microsoft Flow with two simple elegant loops — John Liu .NET
Best Regards,
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
