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.

All responses (5)

Answers (0)

ShondaT 228 on at

Like (0)

Report

Re: Filtering a Gallery

I will give this a try! Thank you again!
BCBuizer 21,999 Super User 2025 Season 1 on at

Like (1)

Report
Re: Filtering a Gallery

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,
ShondaT 228 on at

Like (1)

Report

Re: Filtering a Gallery and also

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
)
ShondaT 228 on at

Like (0)

Report

Re: Filtering a Gallery

.
BCBuizer 21,999 Super User 2025 Season 1 on at

Like (2)

Report
Re: Filtering a Gallery and also

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 )