Filtering

Like (0) Share

Report

Posted on 29 Jan 2019 09:02:42 by BenGillard

120

I am currently Filtering my gallery as follows:

Filter(TestDominic2,Lower('Created By'.Email)=Lower(User().Email))

I would like to also now filter further based on the choice from a drop down control i have created from a SP choice column: Choices(TestDominic2.'Review Status')

Thanks in advance

Categories:

General Questions

All responses (2)

Answers (1)

v-xida-msft on 30 Jan 2019 at 08:34:10

Like (1)

Report
Re: Filtering

Hi @BenGillard,

Based on the needs that you mentioned, I have made a test on my side, please take a try with the following workaround:

Set the Items property of the Gallery to following:

Filter(
TestDominic2,
Lower('Created By'.Email) = Lower(User().Email),
'Review Status'.Value = Dropdown1.Selected.Value /* <-- Dropdown1 represents the Dropdown control that you mentioned*/
)

Or

Filter(
TestDominic2,
Lower('Created By'.Email) = Lower(User().Email) && 'Review Status'.Value = Dropdown1.Selected.Value /* <-- Dropdown1 represents the Dropdown control that you mentioned*/
)

More details about Filter function, please check the following article:

Filter function

Best regards,
Verified answer

timl 35,437 Super User 2025 Season 2 on 29 Jan 2019 at 10:42:25

Like (1)

Report
Re: Filtering

Hi @BenGillard

You can filter your data like so:

Filter(TestDominic2, Lower('Created By'.Email)=Lower(User().Email) && 'Review Status'.Value = Dropdown1.Selected.Value)
)

Dropdown1 would refer to the name of your dropdown.

Due to the delegation limitations of SharePoint, note that this would not be delegable and the filter would only operate on a maximum of the first 2000 records in your list.