Answered

Multiple filters for sharepoint list

(0) Share

Report

Posted on by bmcnal

Morning,

I am looking for a good way to apply multiple filter criteria to a power app gallery. Data is coming from a Microsoft list. The columns in question are choice columns with "yes" as the only value (empty otherwise).

I am looking for a way to have the gallery display only rows where each criteria is met. Similar to the filter function in excel or lists, only displaying the results from each column that have a "yes". In the picture above, if I wanted to show results that had a "yes" in column one, all results would display. Add to that results those rows that also have a "yes" in column 2, and so on, and so on. I have about 10 columns I would want to apply this too.

If toggle1 is for column1, toggle2 for column2, toggle3 for column3. Then if toggle1 is engaged, the gallery would display all rows that have "yes" in column1. If toggle1 and toggle2 are engaged, the galley would display all rows that have "yes" in column1 AND column2. If toggle 1 and toggle 2 and toggle 3 are engaged, that gallery would display all rows that have "yes" in column 1, column 2, AND column 3. With each additional toggle, the galley gets more and more refined.

I currently use one toggle to filter the entire list by a date column.

Current code in the items section of the gallery -

With({_items:
Filter('Master Database V.2',
StartsWith(Title, TextSearchBox1.Text))
},
SortByColumns(
Filter(_items, (InactiveToggle.Value || IsBlank('Last Date'))),
varColumnSort,
varColumnDir
)
)

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @bmcnal ,

I have made a test for your reference.
1. Here is my SharePoint list.
2. Select the Gallery and apply the following formula on its items property as:
If( Toggle1.Value = true && Toggle2.Value=false && Toggle3.Value=false, Filter(ToggleTest,'Pod A,B,C'.Value = "Yes"), Toggle1.Value = true && Toggle2.Value=true && Toggle3.Value=false, Filter(ToggleTest,'Pod A,B,C'.Value = "Yes" && 'Pod TL'.Value = "Yes"), Toggle1.Value = true && Toggle2.Value=true && Toggle3.Value=true, Filter(ToggleTest,'Pod A,B,C'.Value = "Yes" && 'Pod TL'.Value = "Yes" && Resus.Value="Yes") )
Result Screenshots:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @bmcnal ,

Is your problem solved?

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @bmcnal ,

I have made another test for your reference.
Try to use the following formula:
Filter( ToggleTest, If(Toggle1.Value,'Pod A,B,C'.Value = "Yes",true)&& If(Toggle2.Value,'Pod TL'.Value = "Yes",true)&& If(Toggle3.Value,Resus.Value="Yes",true) )

Best Regards,
Charlie Choi

Was this reply helpful? Yes No