Announcements
Hi, I am trying to sort the gallary based on the quantity of InsatallBaseEndUser. On my gallary's item's property I have 'Sort(Distinct(ColEU,installedbaseEndUserName),SortOrder.Descending) ' .
Hi @RafeAdilSk,
Do you want to distinct each installedbaseEndUserName and cauculate how manys rows in each distinct user group?
If so, please set the Items property as below:
Sort(AddColumns(Distinct(ColEU,installedbaseEndUserName),"Quantity",CountIf(ColEU,installedbaseEndUserName=Value)),"Quantity",SortOrder.Descending)
Hi @v-qiaqi-msft updated the items property still not sorting accordingly.
I have tested it in my scenario, the formula works as expected, tell me what makes the difference in your scenario?
Count a wrong quantity for some special user?
Hello @v-qiaqi-msft
The sorting is happening on the enduser names instead of the quantities they have. Nothing seems changed.
Hi @RafeAdilSk，
That's weird.😂
The logic is correct and the syntax is also correct.
This is my testing result
Try to re-write the formula.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 360 Super User 2026 Season 2
M Bilal Khan 325
Mohsin Ali 232
