Unanswered

Powerapps Textbox Search on a Sharepoint Multichoice Column

(1) Share

Report

Posted on by CU27080302-0

As the title suggests, I have been stuck on trying to create a textbox search in Powerapps against a Multichoice column in Sharepoint.

Scenario:

In Sharepoint, I have 2 Lists:

1. "Projects in Flight" with a column that is multichoice (Testers). Users are able to add Names of Multiple Testers from the second list below, into this column.

2. "Names" contains one column only (Name)

In Powerapps I have created a text box (txtsearchTesterName) to search the "Testers" column for any name and be able to produce a result that shows all projects associated with that Tester's Name.

I have attempted the following but with no success..

Filter('Projects in Flight', txtsearchTesterName.Value, Testers)

Your help will be greatly appreciated.

Categories:

Building Power Apps

multichoice Searc...

I have the same question (0)

All responses (8)

Answers (0)

WarrenBelz 153,032 Most Valuable Professional on at

Like (1)

Report
Hi CU27080302-0

If this is a multi-choice field, you need
Filter( 'Projects in Flight', txtsearchTesterName.Value in Testers.Value )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
CU27080302-0 8 on at

Like (0)

Report

Hi @WarrenBelz

I tried your suggestion of swapping the Filter with a Search function instead but the Gallery shows blank :(

Was this reply helpful? Yes No
WarrenBelz 153,032 Most Valuable Professional on at

Like (0)

Report

I have updated the post shortly after I did it.

Was this reply helpful? Yes No
CU27080302-0 8 on at

Like (0)

Report

@WarrenBelz

The "Testers" column in the "Projects in Flight" List is a Lookup of the "Names" list.

Hope that helps.

Unfortunately your suggestion below does not work for me :(
"We didn't find any data"

Was this reply helpful? Yes No
Samand 91 on at

Like (1)

Report

Not sure if this helps, but if you’re using a collection (if not just try ignoring the rows related to the collection) you can try this:

ClearCollect(

col_name,

Filter(

data_source,

Upper(TextInput) in Upper(Proj_A) || Upper(TextInput) in Upper(Proj_B) || …

)

);

Replace TextInput with the name of your input box, where you type your search, your own collection name and data source.

I think it might work better if you use a Concat on your columns. I always change the text to upper, because people get things wrong.

Was this reply helpful? Yes No
CU27080302-0 8 on at

Like (0)

Report

Hi Samand,

Do I need to set the ClearCollect code in a search button?

Was this reply helpful? Yes No
Suggested answer

CA1105 545 Super User 2025 Season 2 on at

Like (0)

Report
You can use In opertor to filter the results I'm just afraid of having deligation issue in your query. You might also use collection to keep all the records and then perform filter using In operator.
//Direct from datasource Filter( 'Projects in Flight', Textboxname.Value in Testers.Value ) //Using collection ClearCollect(colProject, 'Projects in Flight'); Filter( colProject, Textboxname.Value in Testers.Value )

Was this reply helpful? Yes No
Samand 91 on at

Like (0)

Report

Hi CU27080302,

You can put it in a search button or the OnChange property of you Text Input box.

I suppose you can also try a named function instead and you won’t have to update your collection every time.

Was this reply helpful? Yes No