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

I have the same question (0)

All responses (10)

Answers (1)

Sort by

WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
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,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz that's certainly what it seems like.

Was this reply helpful? Yes No
Niravajudia 14 on at

Like
a
(0)

Report
Copy link

Link copied!

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 155,752 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Niravajudia ,

It was missing a comma

Was this reply helpful? Yes No
Niravajudia 14 on at

Like
a
(0)

Report
Copy link

Link copied!

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 155,752 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@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
a
(0)

Report
Copy link

Link copied!
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

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

Like
a
(1)

Report
Copy link

Link copied!

@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
a
(0)

Report
Copy link

Link copied!

Absolutely amazing.

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

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Niravajudia ,

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

Was this reply helpful? Yes No