Answered

Filtering and Searching using two search fields

(0) Share

Report

Posted on by heiavieh

I've looked this question up, but it's really difficult for me to parse how I'm supposed to fix any of this.

I'm making an app that will allow a user to look at a machine and its details. I want them to sort by business unit, and then have the option to look up a machine in the gallery.

But I'm getting nothing but errors. Here are the multiple attempts I have made:

(Search(newunit1,TextSearchBox1.Text, "MACHINE")

SortByColumns(Search(Search(newunit1,TextSearchBox1.Text, "MACHINE"), Dropdown1.SelectedText, "UNIT"

SortByColumns(Filter(newunit1, "UNIT" = Dropdown1.SelectedText), "UNIT", SortOrder.Ascending, SortByColumns(Search([@newunit1], TextSearchBox1.Text, "MACHINE"), "MACHINE", SortOrder.Ascending)

TextSearchBox1 is supposed to reference the machine name. Dropdown 1 is supposed to be the business units. I'm sure this is very simple, but I can't wrap my head around it. Any help is much appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@heiavieh , for a delegable solution, try using the StartsWith function which limits the search to the beginning of the text:

SortByColumns( Filter( newunit1, StartsWith( 'the column you want to search', TextSearchBox1.Text ), Len(Dropdown1.Selected.Value) = 0 || 'the column you want to filter on' = Dropdown1.Selected.Value ), "UNIT", SortOrder.Ascending )

If you need to use the Search function (which is not limited to searching the beginning of text but is not delegable), you can partially delegate this with:

With( { _data: Filter( newunit1, Len(Dropdown1.Selected.Value) = 0 || 'the column you want to filter on' = Dropdown1.Selected.Value ) }, SortByColumns( Search( _data, TextSearchBox1.Text, "the column you want to search on" ), "UNIT", SortOrder.Ascending ) )

Note the above assumes the column you want to ilter your dropdown on is not a SharePoint Choice data type. If the column is a single select Choice data type, you need to change this line:

'the column you want to filter on'

To:

'the column you want to filter on'.Value

I see you're a new community member so if none of this is making sense, feel free to ask questions.

For more information on what delegation is, see here:

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview

Was this reply helpful? Yes No
mbarbosa 146 on at

Like
a
(0)

Report
Copy link

Link copied!
Are you setting that formula as your gallery items property? Maybe you want to create a search button/icon and use the formula on its OnSelect event.
I believe you should use something like this:
ClearCollect(ItemsCollection,Filter(newunit1,UNIT=Dropdown1.Selected.Value,TextSearchBox1.Text in MACHINE))
And then you use that collection (ItemsCollection) in the Gallery items property.

Was this reply helpful? Yes No