web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps Filter table based on ...

Power Apps

Unanswered

Filter table based on another table lookup column

(1) Share

Report

Report

Posted on by CU12011912-0

Hi!

Consider the following scenario:

TABLE_A
Unique_A	Info_A
A1	Peter
A2	Mary
A3	John
A4	Louis

TABLE_B
Unique_B	Info_B	LookUp_Unique_A
B1	345	A1
B2	789	A4

TABLES_B's 'LookUp_Unique_A' is a lookup column linked to TABLE_A

Is it possible to filter TABLE_A row's that are not linked in TABLE_B's 'LookUp_Unique_A'?

In the provided scenario the filter result should be

FILTERED TABLE_A
Unique_A	Info_A
A2	Mary
A3	John

Tried

Filter(TABLE_A; Not( Unique_A in AddColumns( TABLE_B; NewColumn; LookUp_Unique_A.Unique_A).NewColumn))

with no success

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Ytalo Silva 181 Moderator on at

Like (0)

Report
Copy link

Link copied!
@CU12011912-0

Hello, my suggestion was to create a collection containing the requested information like this:

ClearCollect( Table_A, { Unique_A: "A1", Info_A: "Peter" }, { Unique_A: "A2", Info_A: "Mary" }, { Unique_A: "A3", Info_A: "John" }, { Unique_A: "A4", Info_A: "Louis" } ); ClearCollect( Table_B, { Unique_B: "B1", Info_B: 345, LookUp_Unique_A: "A1" }, { Unique_B: "B2", Info_B: 789, LookUp_Unique_A: "A4" } ); ClearCollect( Table_C, Blank() ); ForAll( Table_B, Collect( Table_C; LookUp( Table_A, Unique_A <> LookUp_Unique_A ) ) )

I hope this helps!

Was this reply helpful? Yes No
WarrenBelz 153,737 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @CU12011912-0,

The filter should be
Filter( TableA, !(UniqueA in TableB.Lookup_Unique_A) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No

Join the conversation