Power Platform Community Forum Thread Details

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

First Iteration (one record): John - 2 - April - 50000000
Second Iteration (two records): Jane - 3 - May - 6000000, Jane - 3 - August - 300
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