Answered

How to filter data by clicking on the icon?

(0) Share

Report

Posted on by Niravajudia

Scenario: Clicking on the Shopping Cart Icon it should filter all items with the text "Order" in the column name called "Order".

Details:

Name of the list: LS and Studio Spare

Gallery name: BrowseGallery1

The formula already has on "Items" in BrowseGallery 1 -

SortByColumns(

Filter(

'LS and Studio Spare',

StartsWith(Title, TextSearchBox1.Text) ||

StartsWith('Sub Title', TextSearchBox1.Text) ||

StartsWith('Sec Loc', TextSearchBox1.Text) ||

StartsWith('Ter Loc', TextSearchBox1.Text) ||

StartsWith('Buy From', TextSearchBox1.Text) ||

StartsWith('Pri Loc'.Value, TextSearchBox1.Text)||

StartsWith(Order, TextSearchBox1.Text)

"CreatedDate",

If(SortDescending1, SortOrder.Descending, SortOrder.Ascending)

)

Thank you so much for your help

Categories:

Building Power Apps

PA S03.PNG

PA S01.PNG

PA S02.PNG

I have the same question (0)

All responses (10)

Answers (1)

WarrenBelz 153,079 Most Valuable Professional on at

Like (2)

Report
Hi @Niravajudia ,

Is this what you mean ?

SortByColumns( Filter( 'LS and Studio Spare', ( StartsWith(Title, TextSearchBox1.Text) || StartsWith('Sub Title', TextSearchBox1.Text) || StartsWith('Sec Loc', TextSearchBox1.Text) || StartsWith('Ter Loc', TextSearchBox1.Text) || StartsWith('Buy From', TextSearchBox1.Text) || StartsWith('Pri Loc'.Value, TextSearchBox1.Text) || StartsWith(Order, TextSearchBox1.Text) ) && Order = "Order" ), "CreatedDate", If( SortDescending1, SortOrder.Descending, SortOrder.Ascending ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Michael E. Gernaey 53,429 Super User 2025 Season 2 on at

Like (0)

Report

@WarrenBelz that's certainly what it seems like.

Was this reply helpful? Yes No
Niravajudia 14 on at

Like (0)

Report

Thanks, Warren. That seems perfectly correct, but I am getting an error. I don't know why exactly.

Thanks a lot

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

Like (1)

Report

@Niravajudia ,

It was missing a comma

Was this reply helpful? Yes No
Niravajudia 14 on at

Like (0)

Report

Thanks, Warren. That's amazing.

But I can see all the "Order" items without clicking the Shopping Cart Icon. What OnSelect formula do I need to apply to the Shopping Cart Icon to make that happen?

Thanks

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

Like (1)

Report
@Niravajudia ,

Set a Variable on the Icon OnSelect

UpdateContext({varOrder: true})

at screen OnVisible or whenever you want to reset this

UpdateContext({varOrder: false})

then the Gallery Items

SortByColumns( Filter( 'LS and Studio Spare', ( StartsWith(Title, TextSearchBox1.Text) || StartsWith('Sub Title', TextSearchBox1.Text) || StartsWith('Sec Loc', TextSearchBox1.Text) || StartsWith('Ter Loc', TextSearchBox1.Text) || StartsWith('Buy From', TextSearchBox1.Text) || StartsWith('Pri Loc'.Value, TextSearchBox1.Text) || StartsWith(Order, TextSearchBox1.Text) ) && ( !varOrder || Order = "Order" ) ), "CreatedDate", If( SortDescending1, SortOrder.Descending, SortOrder.Ascending ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Niravajudia 14 on at

Like (0)

Report
It worked. 😃

Thanks a lot, Warren. Possibly the last thing I am having an issue with is with the reset properties. I am applying
UpdateContext({varOrder: false})
to my logo on the Onselect property, but I am receiving an error that Characters are used in an unexpected way. Is there a solution to this?

Thanks a lot again

PA S06.PNG

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

Like (1)

Report

@Niravajudia ,

Try typing it in - you have a strange hidden character at the end of your posted code

Was this reply helpful? Yes No
Niravajudia 14 on at

Like (0)

Report

Absolutely amazing.

Thanks a lot, Warren. I can't thank you enough. 🙏

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

@Niravajudia ,

Happy to help - I assume this is now solved and closed ?

Was this reply helpful? Yes No