Find Unmatched Data Across 2 SharePoint lists

(0) Share

Report

Posted on by Trevasta

Hi!

My data is set up as below:

Source1

Site	Class	Name
SITE A	CLASS A	PERSON A
SITE A	CLASS B	PERSON B
SITE B	CLASS A	PERSON C
SITE B	CLASS B	PERSON D

Source2

Site	Class
SITE A	CLASS A
SITE A	CLASS B
SITE B	CLASS A

I am trying to create a gallery that shows me a list from Source1 where a Class is NOT found in within its Site in Source2. In the example above it should return the data which includes PERSON D, since Source2 does not contain a SITE B CLASS B.

Any help would be appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Trevasta ,

This should be close

With( {wList2:Source2}, Filter( Source1, Site = wList2.Site && !(Class in wList2.Class) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Trevasta 6 on at

Like (0)

Report
Copy link

Link copied!

Awesome! That worked!

Was this reply helpful? Yes No