Getting report from users that all items are not showing in the Product Name drop-down.
Example:
When selected: Category: Postage Meter Ink & Accessories → Subcategory: Ink Cartridges → Only 13 item show up from the Product Name dropdown then the 22 on the SharePoint List
Formula that I'm using
Category
Distinct('Pitney Bowes Data',Category)
Subcategory
Distinct(Filter('Pitney Bowes Data',IsBlank(Category)=true Or Category=CategoryDrp.Selected.Result),SubCategory)
Product Name
Distinct(Filter('Pitney Bowes Data',IsBlank(SubCategory)=true Or SubCategory=SubCategoryDrp.Selected.Result),ProductName)
SharePoint List total items: 128
I do have "Data row limit for non-delegable queries" set to Value: 2000
Hope i explain myself clearly.
Solved! Go to Solution.
Updated -
I rename the Product Name items with some description all items now appears in the dropdown. Quick & Dirty 😎
After doing some research. The item that are being return is in "Yellow'
Updated -
I rename the Product Name items with some description all items now appears in the dropdown. Quick & Dirty 😎
User | Count |
---|---|
183 | |
124 | |
88 | |
45 | |
43 |
User | Count |
---|---|
248 | |
158 | |
127 | |
78 | |
73 |