How to search a choice field from within a text input

(0) Share

Report

Posted on by ShadowTech

How can I run a search in a text input for a choice field from a SharePoint list as the data source. This is a gallery.

Thanks in advance.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

rizkyaditya 292 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @ShadowTech ,

You might consider this post as your answer : Search a SharePoint "Choice" column in Power Apps?
Verified answer

WarrenBelz 156,756 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ShadowTech ,

Note the below is not Delegable

Filter( AddColumns( DataSource, "WhateverName", YourChoiceField.Value ), YourTextBoxName in WhateverName )

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.
ShadowTech on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz What would be your recommendation on inserting it in my current formula?

Sort( Filter( Search( 'Freight-Damage', SearchBox.Text, "ClaimNumber", "Vendor_x0028_Origin_x0029_" ), If( Dropdown1.Selected.Value = "All", true, Branch.Value = Dropdown1.Selected.Value ), If( Dropdown2.Selected.Value = "All", true, 'Claim Status'.Value = Dropdown2.Selected.Value ) ), Created, Descending )

Thanks in advance.
ShadowTech on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz So I got it working but broke something else. I have a display form based on the "Gallery2.Selected" (This gallery) but now shows no data when a record is selected in the Gallery. Recommendations?

Sort( Filter( Search( AddColumns( 'Freight-Damage', "BranchLook", Branch.Value ), SearchBox.Text, "ClaimNumber", "Vendor_x0028_Origin_x0029_", "BranchLook" ), If( Dropdown1.Selected.Value = "All", true, Branch.Value = Dropdown1.Selected.Value ), If( Dropdown2.Selected.Value = "All", true, 'Claim Status'.Value = Dropdown2.Selected.Value ) ), Created, Descending )

Thanks in advance.
ShadowTech on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Figured it out. You now have to have the forms perform a lookup of the ID.
WarrenBelz 156,756 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ShadowTech ,

I would be inclined to go this way

Sort( Search( Filter( 'Freight-Damage', ( Dropdown1.Selected.Value = "All" || Branch.Value = Dropdown1.Selected.Value ), ( Dropdown2.Selected.Value = "All" || 'Claim Status'.Value = Dropdown2.Selected.Value ) ), SearchBox.Text, "ClaimNumber", "Vendor_x0028_Origin_x0029_" ), Created, Descending )

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.