web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Display records that N...

Power Apps

Answered

Display records that NOT EXISTS in another table

(0) Share

Report

Report

Posted on by Samuel Rollón

122

Hi.

I need to display in a gallery only the records that do not exists in another table. These are the tables:

test_origin	test_lookup
line	l_linea (lookup column from test_origin.line and UNIQUE)
	user

And this is the current data stored in the tables:

test_origin	test_lookup
111	111, user1
222	222, user2
333

What I want is to display only the records from test_origin that not exists in test_lookup, in that case, only display the 333 record.

I have tried this solution from another post but doesn't work for me.

Filter(test_origin, !(line in test_lookup[@l_linea]))

Any ideas about other ways to filter?

Thank you in advance!

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Expolio ,

If look up column is single select, please try this.

Filter(test_origin,Not(line in AddColumns(l_linea,"test",test_lookup.Value).test))

If look up column is multiple select, please try this.

Filter(test_origin,Not(line in AddColumns(test_lookup,"test",Concat(l_linea,Value,",")).test))

Best regards,

Rimmon
Samuel Rollón 122 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much!

After a little change, this worked for me.

Join the conversation