Announcements
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.
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 NogueiraCheck my LinkedIn!Check my User Group (pt-PT)!Last Post on CommunityMy website!
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.
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 474
WarrenBelz 375 Most Valuable Professional
