You’re offline. This is a read only version of the page.
345
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"?
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.
yes, but when we use filter we just need to pass the name of the column, so you function will be something like this:
Share
Report
All responses (
Answers (
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
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"
)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"
)
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
