Unanswered

sort the gallary based on the quantity of InsatallBaseEndUser

(0) Share

Report

Posted on by RafeAdilSk

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) ' .

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

v-qiaqi@microsoft.com on at

Like (0)

Report
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)

Was this reply helpful? Yes No
RafeAdilSk 4 on at

Like (0)

Report

Hi @v-qiaqi-msft updated the items property still not sorting accordingly.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @RafeAdilSk,

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?

Was this reply helpful? Yes No
RafeAdilSk 4 on at

Like (0)

Report

Hello @v-qiaqi-msft
The sorting is happening on the enduser names instead of the quantities they have. Nothing seems changed.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report

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.

Was this reply helpful? Yes No