Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Power Platform Community / Forums / Building Power Apps / Powerapps Textbox Sear...
Building Power Apps
Unanswered

Powerapps Textbox Search on a Sharepoint Multichoice Column

(1) ShareShare
ReportReport
Posted on by CU27080302-0 6
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:
Using Apps Using Formulas
General Questions
Connectors
multichoice Searc...
  • Samand Profile Picture
    Samand 9 on at
    Powerapps Textbox Search on a Sharepoint Multichoice Column
    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.
  • CU27080302-0 Profile Picture
    CU27080302-0 6 on at
    Powerapps Textbox Search on a Sharepoint Multichoice Column
    @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"
  • WarrenBelz Profile Picture
    WarrenBelz 140,690 on at
    Powerapps Textbox Search on a Sharepoint Multichoice Column
    I have updated the post shortly after I did it.
  • CU27080302-0 Profile Picture
    CU27080302-0 6 on at
    Powerapps Textbox Search on a Sharepoint Multichoice Column
    Hi @WarrenBelz
     
    I tried your suggestion of swapping the Filter with a Search function instead but the Gallery shows blank :(
  • WarrenBelz Profile Picture
    WarrenBelz 140,690 on at
    Powerapps Textbox Search on a Sharepoint Multichoice Column
    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

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Community Update 9/9/24…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 140,690

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,355

Leaderboard

Featured topics

Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans