Answered

How to search based on keyword matches with any fields in gallery control?

(0) Share

Report

Posted on by Dave Wi

Hello,

I have SharePoint list with "5 fields" ( 1 text field, 1 yes/no field, 2 choice field, 1 number field) that I have bind with Gallery control in PowerApps.

How can I search record based on keyword that matches with any of the "5 fields"( 1 text field, 1 yes/no field, 2 choice field, 1 number field) values in the gallery control?

Thanks and Regards,

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,224 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @dave8 ,
There is no value that will match all three text, number and yes/no.
Text and Choice will match will text and the text was a number you could
Filter( YourListName, YourChoiceField1.Value = YourSearchControl.Text || YourChoiceField2.Value = YourSearchControl.Text || YourTextField = YourSearchControl.Text || Text(YourNumberField,"####") = YourSearchControl.Text )
but the yes/no would not match any of these.

Please click Accept as solution 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 Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 155,224 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @dave8 ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution 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 Thumbs Up.

Was this reply helpful? Yes No
Dave Wi on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Sorry for the late response, however with further changes, I had to move to data table - Can you please share how can I have search functionality working for data table? Do I have to display a search box + search icon if yes, on "On Select" of "Search" icon which formula I should have?

Thanks and Regards,

Was this reply helpful? Yes No
WarrenBelz 155,224 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @dave8 ,
Your initial requirements were a little vague and I hope I am on the right track here.
The example I gave would have a Text Input. The code is the Items of the Gallery, which would react as soon as something was typed in the search box.

Please click Accept as solution 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 Thumbs Up.

Was this reply helpful? Yes No