Filtering a Gallery

(0) Share

Report

Posted on by ShondaT

228

I have a gallery that was filtering based on a selection from a drop down box with this code:

If(Dropdown1.Selected.Result = "All", 'NEST Intake System', Filter('NEST Intake System', Status.Value = Dropdown1.Selected.Result))

I need the gallery to initially only show items that were created by the current user and that also contains the current user's name in the Return to field which is a people/group column that allows for more than one name to be entered. I changed the code to below:

Filter('NEST Intake System', 'Created By'.DisplayName = varUserEmail & Status.Value = Dropdown1.Selected.Result);

The varUserEmail is established on the StartUp property of the app but it's not working.

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

BCBuizer 22,844 Super User 2026 Season 2 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @ShondaT ,

With the below changes this should work as described:

Filter( 'NEST Intake System', 'Created By'.Email = varUserEmail, varUserEmail in Return, Dropdown1.Selected.Result = "All" || Status.Value = Dropdown1.Selected.Result )

Was this reply helpful? Yes No
ShondaT 228 on at

Like
a
(0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No
ShondaT 228 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you so much for responding so quickly BCBuizer! This forum has some awesome folks!

The "Return To" reference is rendering an error that reads "Invalid Schema. Expecting a one-column table" when I hover over the reference. There is also a delegation warning:

Filter(
'NEST Intake System',
'Created By'.Email = varUserEmail,
varUserEmail in 'Return To',
Dropdown1.Selected.Result = "All" || Status.Value = Dropdown1.Selected.Result
)

Was this reply helpful? Yes No
BCBuizer 22,844 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
I assume the 'Return To' column is a person/group type? In that case .Email needs to be added.

The "in" operator is causing the delegation warning. What you can do to not have this be an issue is pre-filtering: As long as the number of pre-filtered items, using a delegable filter, does not exceed the Data Row Limit (typically 500, but can be raised to 2000), you can ignore the warning.

Below is what those two changes look like:

With({ _preFilter: Filter( 'NEST Intake System', 'Created By'.Email = varUserEmail, Dropdown1.Selected.Result = "All" || Status.Value = Dropdown1.Selected.Result )}, Filter( _preFilter, varUserEmail in 'Return To'.Email, ) )

HI @ShondaT,

Was this reply helpful? Yes No
ShondaT 228 on at

Like
a
(0)

Report
Copy link

Link copied!

I will give this a try! Thank you again!

Was this reply helpful? Yes No