Answered

Filter table where value is not in another table

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a table that contains a list of locations 'TableStockLocation', this is being used to populate a gallery, I have another table which contains a list of locations that have had usernames assigned to the locations 'TableUserAssigned'. In my gallery, I only want to see the locations from the TableStockLocation table that do not appear in the TableUserAssigned table, so basically it needs to do the opposite of this formula Filter(TableStockLocation, Location in TableUserAssigned.Location)

Table: TableStockLocation

Column: Location

Table: TableUserAssigned

Column: Location

Thanks in advance!

Categories:

Building Power Apps

I have the same question (1)

All responses (3)

Answers (1)

Verified answer

timl 36,774 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!
Hi @Anonymous

You should hopefully be able to do this with the Not function.

Filter(TableStockLocation, Not(Location in TableUserAssigned.Location) )

3 people found this reply helpful.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you @timl that has worked perfectly!

Was this reply helpful? Yes No
calvinck00 43 on at

Like (0)

Report
Copy link

Link copied!

Hi, this code is not work for me. I have 2 tables (Dataverse)

First Table is "Fixed Assets", Second Table is "Opname".

I want to display fixed assets data (from the first table) that did not in the second table.
Additional information is:
Table Fixed Assets coloumns:
Name, fixed assets number (primary)

Table Opname coloumns:
Fixed assets (lookup), ID_Opname (primary)

Was this reply helpful? Yes No