Unanswered

Filter and search with exact entry

(0) Share

Report

Posted on by kajsiretardiran

Hello,

I know this has been answered but I need a little bit more help with exactin when filtering and searching as I do not understand where should I put it into my code.

I am filtering the gallery with two selects (is that even a word?) and then I am searching the gallery for the device.

Now I am totally lost on where to put exactin into this in order to filter the name of the device exactly as I have put it into my search box.

Here is whats in items of the gallery.
Search(Filter(Switches,And(SwitchCategoryId = galSwitchSearch.Selected.SwitchCategoryId), And(NodeId = galSwitchSearch.Selected.NodeId)),MainSearch_2.Text,"Device")

Any help is appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

WarrenBelz 153,032 Most Valuable Professional on at

Like (0)

Report
Hi @kajsiretardiran ,

You have and extra And in there, but this should work

Search( Filter( Switches, And( SwitchCategoryId = galSwitchSearch.Selected.SwitchCategoryId, NodeId = galSwitchSearch.Selected.NodeId ) ), MainSearch_2.Text, "Device" )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
kajsiretardiran 98 on at

Like (0)

Report

Thank you Warren for that tip but that is not my problem.

When I search through the gallery lets say with "Carpool" and I have a "Carpool","Car" and "Pool" in the gallery it will always return all three of them and I want the search to return only "Carpool".

I understand I have to use exactin somewhere and that is where my problem lies. I have no idea where to put it inside of my code.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,032 Most Valuable Professional on at

Like (1)

Report
Hi @kajsiretardiran ,

I am wonder how "carpool" would return "car" in a search, but if you really want exactin

Filter( Switches, And( SwitchCategoryId = galSwitchSearch.Selected.SwitchCategoryId, NodeId = galSwitchSearch.Selected.NodeId, MainSearch_2.Text exactin Device ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
kajsiretardiran 98 on at

Like (0)

Report

Thank you Warren but could you please explain why did you remove Search infront of the Filter? I have tested this and when I type anything in the Mainsearch_2.text nothing is happening.

Was this reply helpful? Yes No
WarrenBelz 153,032 Most Valuable Professional on at

Like (0)

Report

Hi @kajsiretardiran ,

I am not a fan of exactin and to be honest Search does the job of finding any instance of a string anywhere in a field (which is why I asked why it was not doing it for you)

Was this reply helpful? Yes No
kajsiretardiran 98 on at

Like (0)

Report

I have managed to make it work. There were some typos in the code that I overseen.

I now understand why you dont like exactin....

Thank you for your help you have as always helped alot!

Was this reply helpful? Yes No