Collection: Counting Products from Category?

(0) Share

Report

Posted on by oguruma

I want to build a quote tool. I will use a collection called colSelectedProducts. I want to prohibit users from adding too many products from certain categories.

ClearCollect( colSelectedProducts, { Item: "Denim Jeans", Category: "Pants", Quantity: 2 }, { Item: "Rolex Watch", Category: "Watch", Quantity: 1 })

I'll have a table with {Category: "Jeans",Limit: 5}.{Category:"Watch",Limit:1} to set the limitations per category.

How do count the products in the colSelectedProducts Collection to make sure that there aren't, for example, 2 watches?

Categories:

Building Power Apps

All responses (1)

Answers (0)

AaronKnox 514 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @oguruma ,
The solution might be the CountRows() function:
CountRows(Filter(colSelectedProducts, Category="Watch"))