Using Combobox to filter part of text in text column

(0) Share

Report

Posted on by Silverel

Hello everyone,

I have a gallery with an SP List as source. The columns of the SP list is "single line of Text".

So for example I have a column with the entries:

[A, B

AB, C

CA, AB, B

A, C, AB]

And I have a combobox with the entries [A, AB]. The filter is set up with

Filter(Gallery, IsBlank(ComboBox.SelectedItems) || IsEmpty(ComboBox.SelectedItems) || 'text column' in ComboBox.SelectedItems)

When I choose AB in the Combobox the gallery will only show the line with "AB, C" but not all the other lines containing AB. How can I change my filter?

Thanks for the help!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report

Lets take a look at this:

For my example my sharepoint list is called: DummyTab

For my example my 'text column' is called: CoolText

First add a new ComboBox to your screen and call it anything for my example I will Call it Combobox1. For my example you need to turn Multi Select off in the properties of the combobox let me know if this is needed.

I want you to make the Items property of the ComboBox to:

Sort(Distinct(Split(Concat(DummyTab.CoolText,CoolText),","),Result),Result,Ascending)

*Remember for you scenario you need to change the names*

then change the filter to:

Filter(DummyTab, IsBlank(ComboBox1.Selected.Result) || ComboBox1.Selected.Result in CoolText )

So what is happening here?

First we are pulling all the options from sharepoint in that column that are separated by ",". We are then making the options Distinct/Unique and then sorting them Alphabetically.

We are then checking in the filter to see if it is selected and if so filter to find where the option chosen exists in that column. If it is not selected show all.

Was this reply helpful? Yes No
Silverel 2 on at

Like (0)

Report

Hi @AJ_Z
thank you! Yes, I need the Multi Select Function, that's why I used a Combobox.
I see it's better I explain the whole functionality, seems like it's not a simple solution. 🙂

I have a SP list 'namelist' with a 'text column' called 'category'. My goal is to filter the list by 'category'.
I use checkbox to show all options of 'category' and have the checkbox connected to a combobox to apply filtering to my gallery.
I hope to achieve what I described in my original post with the multi select option.

Was this reply helpful? Yes No