Using CheckBoxes to filter OR instead of And

[Field]

I have 2 choice columns in a Sharepoint list where i would like to filter.

Those 2 choice columns would be:

1. Number
   1. Test 1
   2. Test 2
   3. Test 3
2. Words
   1. Test A
   2. Test B
   3. Test C

I want to filter items using these choice columns with checkboxes, and everytime they pick a checkbox, thet get those items choose on the filter. "Without using (Test A and Test B(Automatic Error)), but using (Test A or Test B)".

Is it possible to get this?

Thank you.

[Anonymous]

Hi @Field,

Are you sure you want to use checkbox ? There is an other way simplier.

I remade your source to help.

You can just put 2 combobox like on the picture below

The first (ComboBox1) with this code : 

Distinct(Tableau1;Number)

The second (ComboBox1_1) with this code : 

Distinct(Tableau1;Words)

After that in your gallery you put this code in items statement :

Filter(Tableau1;Number in ComboBox1.SelectedItems;Words in ComboBox1_1.SelectedItems)

Best regards,

Louis

[Field]

Hello Louis,

Thank you very much for the help.

Altough the combo box might be usefull, i would prefer the checkboxes because it's easier to use and it is more "User-Friendly" of some sort.

[Anonymous]

Mmmh I understand that!

But to use a checkbox for each possible value of your list you'll have to create it one by one... I hope for you you don't have a lot of possibilities!

I made some experiments to find an answer for you but nothing is working, i'm sorry...

Louis

[v-xida-msft · Accepted solution]

Hi @Field ,

Could you please share a bit more about your scenario?

Do you want to filter your SP list records based on the two Choice columns using Checkbox controls?

How do you display the filtered result within your app? Using Gallery control?

I agree with @Anonymous 's thought almost, the ComboBox controls could achieve your needs. If you just want to filter your SP list records using Checkbox controls, I think the combination of Gallery controls and Checkbox controls would achieve your needs simply.

I have made a test on my side, please take a try with the following workaround:

Set the OnStart property of the App control or the OnVisible property of the first screen to following:

ClearCollect(NumberCollection, "Test 1", "Test 2", "Test3");
ClearCollect(WordsCollection, "Test A", "Test B", "Test C")

Add two Gallery controls within my app, set the Items property of the Gallery1 to following:

NumberCollection

Add a Checkbox control (Checkbox1) within your Gallery1, set the Text property of the Checkbox to following:

ThisItem.Value

Set the Items property of the Gallery2 to following:

WordsCollection

Add a Checkbox control (Checkbox2) within your Gallery2, set the Text property of the Checkbox to following:

ThisItem.Value

Then within your app, if you want to filter your SP list reocrds based on the Checkboxes within your Gallery1 and Gallery2, please take a try with the following workaround:

Set the Items proeprty of the Gallery3 or Data Table to following:

Filter(
         'YourSPList',
          Number.Value in Filter(Gallery1.AllItems, Checkbox1.Value = true).Value,
          Words.Value in Filter(Gallery2.AllItems, Checkbox2.Value = true).Value
)

Note: The Number and Words represent the Choice type columns in your SP list.

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

Filter function

Best regards,

[Field]

Hello,

Thank you for the answer. This helps me a lot and works.

I have a question, is there anyway to show all items of that column, if none of the checkboxes are active?

Thank you.

[RyanXExner]

@v-xida-msft, will this cause performance issues with large lists?

I get a delegation warning when I implement your solution in my app.  However, it does currently work.