Sorting subgallery under the main gallery

(0) Share

Report

Posted on by macsevet

I'm working on a voting app, and I created the results screen based on this video by Reza Dorrani

My galleries look like this:

I want to sort the gallery items in descending order based on the number of nominations, but I can't figure out how to do it.

The code for the Number of nominations (NumberOfNominations_sum) Text property:

CountRows(Gallery7.AllItems)

And the Items property of the main gallery:

GroupBy(
 AddColumns(
 StarAwards_DeviceOperations_Nominees, "NomineeText", Nominee.DisplayName
 ), 
 "NomineeText", 
 "Data"
 )

Not sure how to use the Filter and Sort functions in this case.

Thanks in advance for any suggestion!

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

WarrenBelz 156,732 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @macsevet ,

The structure would be something like this

GroupBy( AddColumns( Sort( Filter( StarAwards_DeviceOperations_Nominees, YourFilterHere ), YourSortHere ), "NomineeText", Nominee.DisplayName ), "NomineeText", "Data" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
macsevet 35 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WarrenBelz ,
Thank you for the quick reply!
I'm sorry, I might be a bit lost in here. I only added now the Sort function as below, but I got 8 errors about it giving circular references:
GroupBy( AddColumns( Sort( StarAwards_DeviceOperations_Nominees, CountRows(SubGallery_NominationDetails.AllItems), SortOrder.Descending ), "NomineeText", Nominee.DisplayName ), "NomineeText", "Data" )
And this is the nested gallery setup:
Can you please check what am I doing wrong?
Many thanks!
AndrewR1 1,572 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

This won’t work sorry
macsevet 35 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AndrewR1 ,
Thanks for the help!
Although with your code I got this error: "The specified column 'CountRows(Data)' does not exist."
I modified that line as below, but now this error pops up: "Invalid argument type (Number). Expecting a Text value instead."

SortByColumns( GroupBy( AddColumns( StarAwards_DeviceOperations_Nominees, "NomineeText", Nominee.DisplayName ), "NomineeText", "Data" ), CountRows(SubGallery_NominationDetails.AllItems), SortOrder.Descending )
Could you please advise what to modify? 🙂
Thanks!
WarrenBelz 156,732 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@macsevet ,

You cannot Sort by CountRows - you would have to do this - I am assuming this is not the Items of the SubGallery mentioned.

GroupBy( Sort( AddColumns( StarAwards_DeviceOperations_Nominees, "Rows", CountRows(SubGallery_NominationDetails.AllItems), "NomineeText", Nominee.DisplayName ), Rows, SortOrder.Descending ), "NomineeText", "Data" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
WarrenBelz 156,732 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@macsevet ,

You cannot sort a gallery by itself (hence the circular reference)
macsevet 35 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz, I was trying to add this code you sent the last time to the Items property of 'MainGallery_Nominees', but it also creates circular references:
If this approach is not possible at all, do you have maybe any tips for another solution?
WarrenBelz 156,732 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@macsevet ,

Sorry, not that I can think of if you are trying to sort a gallery by the row count of a sub gallery that has direct relationship with the contents of the main item.