Skip to main content

Notifications

Power Apps - Community Calls Conversations
Suggested answer

How to search multi tags with single text (separator +) gallery powerapps

(0) ShareShare
ReportReport
Posted on by
Hi,
 
I search code to search and filter collection gallery multi-columns with a single text (example : bed+mail+test).
 
Thanks a lot for your help
 
Laurent (the french)
  • Suggested answer
    mmbr1606 Profile Picture
    mmbr1606 10,059 on at
    How to search multi tags with single text (separator +) gallery powerapps
    hey
     
    can u try this approach:
    If(
        IsBlank(TextInput1.Text),
        DataSource,
        Filter(
            DataSource,
            ForAll(
                Split(TextInput1.Text, "+"),
                Lower(Value) in Lower(Name) ||
                Lower(Value) in Lower(Type) ||
                Lower(Value) in Lower(Description)
            )
        )
    )
    
    you would need to insert a textinput control that functions as a searchbox. if you rename the input control you also need to change it in the filter of the items property
     

    you can also try this:

     
    if my answer helped please mark as verified,
     
    Filter(
        DataSource,
        StartsWith(Name, TextInput1.Text) || 
        StartsWith(Type, TextInput1.Text) || 
        StartsWith(Description, TextInput1.Text)
    )
    

     
    cheers

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,867

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,161

Leaderboard

Featured topics