Power Platform Community Forum Thread Details

I have 2 tables

CollectA

RefID-A	Date-A
13	07/29/2024
13	07/30/2024
13	07/31/2024
8	07/29/2024
8	07/30/2024
8	07/31/2024
3	07/29/2024
3	07/30/2024
3	07/31/2024

CollectB

RefID-B	Date-B
13	07/29/2024
8	07/30/2024

I want to remove all rows from CollectA that match CollectB and there isn't a matching ID or Key so i need to compare both RefID and Date. This is what I'd like Collect A to look like after:

CollectA

RefID-A	Date-A
13	07/30/2024
13	07/31/2024
8	07/29/2024
8	07/31/2024
3	07/29/2024
3	07/30/2024
3	07/31/2024

Here is what my RemoveIf statement looks like:

RemoveIf(CollectA, RefID-A = Lookup(CollectB,RefID-B = RefID-A).RefID-B, Date-A = Lookup(CollectB,Date-B = Date-A).Date-B)

This is what the CollectA table looks like this after:

CollectA

RefID-A	Date-A
13	07/31/2024
8	07/31/2024
3	07/29/2024
3	07/30/2024
3	07/31/2024

I've also tried RemoveIf(CollectA, RefID-A = Lookup(CollectB,RefID-B = RefID-A).RefID-B && Date-A = Lookup(CollectB,Date-B = Date-A).Date-B) but had the same results

Any ideas on how to re-write this?

Categories:

Building Power Apps