Sort and Filter

(0) Share

Report

Posted on by YE2

Hello,

I'm new to PowerApps and I'm encountering some challenges while creating my app. Currently, I have a vertical gallery that displays product categories and a horizontal gallery showing individual products.

To sort my horizontal gallery by category using the vertical gallery selection, I'm using the formula: Filter(ShoeDataTable, 'ProductCategory' = galShoeType.Selected.'ProductCategory')

Additionally, I want to implement a search functionality to filter the gallery by product name. I'm using the formula: Filter(ShoeDataTable, StartsWith(ProductName, TextInput.Text))

However, I'm facing issues in combining these functionalities seamlessly. Any assistance on resolving this would be greatly appreciated.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

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

Like
a
(0)

Report
Copy link

Link copied!
@YE2 - not clear what you mean by having both a vertical gallery and a horizontal gallery, but to combine the functions, you can use:

Filter( ShoeDataTable, Len(galShoeType.Selected.ProductCategory) = 0 || ProductCategory = galShoeType.Selected.ProductCategory, Len(TextInput.Text) = 0 || StartsWith( ProductName, TextInput.Text ) )

Was this reply helpful? Yes No