cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Olwi21
Frequent Visitor

Filter a GalleryList

Hey there,

 

I am struggeling a bit with the following problem.

 

If got two list which are connected with an ID field (in this example serialnumber; lets just name them list 1 and list 2).

Now I want to display a gallery-list with the the content of list 1, but only the entries which serialnumber is not already in list 2.

 

So thats my main problem here. Do I need to put a filter, sort or something else on the gallery list ?

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

@Olwi21 
A basic example works like this.  It says, for Table 1 show me the SerialNumber values not in Table 2.

Filter(Table1, !(SerialNumber in Table2.SerialNumber))

 

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

2 REPLIES 2
mdevaney
Super User
Super User

@Olwi21 
A basic example works like this.  It says, for Table 1 show me the SerialNumber values not in Table 2.

Filter(Table1, !(SerialNumber in Table2.SerialNumber))

 

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

Pstork1
Dual Super User III
Dual Super User III

One thing to add to @mdevaney 's solution.  Since in is not delegable this will only work if List 1 does not exceed the Data row limit (500 by default 2000 max)



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,251)