Filtering a gallery to only those records that exist in a second table

(0) Share

Report

Posted on by EpicTriffid

364

Hi all,

I have a gallery with about 800 records in. I would like this to be filtered to only show those records that exist in another table. If I do it as a label on each row of the gallery, I can get it to say "Present" or "not Present", depending on whether it exists or not, but I would like this to happen in the Items property, so the gallery just shows those are are "Not Present"?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

victorcp 2,350 Moderator on at

Like (0)

Report
Hi,
You can add a column to the source of the gallery to check if it exists or not and then filter, like this:
Filter( AddColumns( Source, "NewColumnName", If( Condition to check if exist in the other table, "Present", "Not Present" ) ), NewColumnName = "Not Present" )

Was this reply helpful? Yes No
EpicTriffid 364 on at

Like (0)

Report
Hi @victorcp , thank you, but I need to know how to then check the condition. I can't use ThisItem as i did in the gallery, I need it to essentially be EachItem, if that makes sense?

Filter( AddColumns( '[dbo].[Support]', "Check", If( Not(Each Item in Support).Entry_ID in '[dbo].[StaffTotals]'[@Entry_ID], "Present", "Not Present" ) ), Check = "Not Present" )

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like (0)

Report
yes, but when we use filter we just need to pass the name of the column, so you function will be something like this:
Filter( AddColumns( '[dbo].[Support]', "Check", If( Entry_ID in '[dbo].[StaffTotals]'[@Entry_ID], "Present", "Not Present" ) ), Check = "Not Present" )
Let me know if it worked

Was this reply helpful? Yes No
EpicTriffid 364 on at

Like (0)

Report

Hi @victorcp

Unfortunately, it still doesn't work. Not only does it not return results, but it seems to freeze frequently, as if it is trying to pull back too much data or something. I can clearly see in my DB that there are only about 85 records that should appear though.

Was this reply helpful? Yes No