Filtering SQL-table with multiple values

(0) Share

Report

Posted on by ppedersen1985

Hi,

I have a SQL table called "Prod" that I'm viewing in a gallery.

How can I filter and view product A+B+C and so on ? It could potentially be 10-20 products that I want to view from the Prod-table.
If I had a few products I would use and/or operator but here I would use combobox or a collection to use as a filter products.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Use comboboxes...

Imagine, in your combobox you have the categorys from the products. In your gallery you write:
If(
IsBlank(ComboBox1.Selected),
Prod,
Filter(Prod, Category = ComboBox1.Selected)
)

https://www.youtube.com/watch?v=pjs0ZsnJZXo&t=8s

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
ppedersen1985 4 on at

Like (0)

Report
Copy link

Link copied!

Hi, I can not use product category based filter. For example a user want to list order that contains product A, or B or C or D and so on.

I have manged to get the right result by using a long filter code:
Filter(Prod, ProdNo=AAA || ProdNo=BBB || ProdNo=CCC || ProdNo=DDD || ProdNo=DDD and so on...)
But Im trying to make this more user friendly so each user can select multiple products and filter by this.

For now I have created a collection that collects the selected product numbers. The question is how to filter another table (orders or customer) to filter based on a table with product numbers.

Was this reply helpful? Yes No
ppedersen1985 4 on at

Like (0)

Report
Copy link

Link copied!

So to use your example, how can I filter when selecting multiple categories?

In my case, I want to filter orders based on multiple product numbers and multiple customer numbers.

Was this reply helpful? Yes No