Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Powerapps Textbox Search on a Sharepoint Multichoice Column

Like (1) ShareShare
ReportReport
Posted on 27 Aug 2024 04:16:54 by 8
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.
 
 
 
 
  • Samand Profile Picture
    Samand 45 on 07 Oct 2024 at 14:53:08
    Powerapps Textbox Search on a Sharepoint Multichoice Column
     
    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.
  • Suggested answer
    CA1105 Profile Picture
    CA1105 222 on 19 Sep 2024 at 05:21:59
    Powerapps Textbox Search on a Sharepoint Multichoice Column
    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
    )
     
  • CU27080302-0 Profile Picture
    CU27080302-0 8 on 19 Sep 2024 at 03:02:25
    Powerapps Textbox Search on a Sharepoint Multichoice Column
    Hi Samand,
     
    Do I need to set the ClearCollect code in a search button?
  • Samand Profile Picture
    Samand 45 on 05 Sep 2024 at 16:15:21
    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 8 on 05 Sep 2024 at 15:36:07
    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 144,696 on 28 Aug 2024 at 02:35:59
    Powerapps Textbox Search on a Sharepoint Multichoice Column
    I have updated the post shortly after I did it.
  • CU27080302-0 Profile Picture
    CU27080302-0 8 on 28 Aug 2024 at 02:31:53
    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 144,696 on 28 Aug 2024 at 02:24:00
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,696

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,456

Leaderboard
Loading complete