Filter the Gallery based on Multiple Controls

[TomLu1231]

Dear experts, 

I have a shrepoint list which has following fields:

• Item ID: this is text type filed.
• Request Type: this is a choice type filed (A, B, C)
• Workflow Status: this is a choice type field (New, In Progress, Implemented)
• Assigned to: this is a choice type field (Sandy,Tom, Simith)

Please find following as example:

Item ID	Request Type	Workflow Status	Assigned to
RT222114	A	New	Sandy
RT223311	B	In Progress	Tom
RT312233	C	Implemented	Tom

I created a gallery to dispaly the list itmes. I wish to eanble the user to filter the gallery based on the intersection of these three fields by using a drop donw control. (E.g. if the user choose Request Type =B and Workflow = In Progress, the gallery should show RT223311)

Is it possible to achieve that?

Many thanks!

[v-sheyu-msft · Accepted solution]

Hi @TomLu1231,

Do you want to filter the gallery based on the selected values of any two dropdowns ?

I made a test.

I created a SharePoint list named ‘test2’.

Set Items property of the gallery to :

Filter(test2,If(IsBlank(Dropdown1.Selected.Value),true,Dropdown1.Selected.Value in 'Request Type'.Value) && If(IsBlank(Dropdown2.Selected.Value),true,Dropdown2.Selected.Value in 'Workflow Status'.Value) && If(IsBlank(Dropdown3.Selected.Value),true,Dropdown3.Selected.Value in 'Assigned to'.Value))

Regards,

Eason

[JLbeaches]

Thanks - this was very helpful!