Sorting a Gallery - By Subtitle?

[smartin]

Hi everyone

I have a gallery built in my app that's based on a collection.

The Item code that I have on the gallery is the following: SortByColumns(GroupBy(SelectedSST,"Help_Reasons","Help_Group"),"Help_Reasons",Ascending)

So I've grouped all the responses based on the Title of the response. 

I need them grouped together based on the response, but I'm hoping I can sort by the Subtitle label that I have highlighted in blue. The Text coding that I have on the subtitle is just a count function: CountIf(SelectedSST,Help_Reasons=Title9_1.Text)

Anyone know how I can Sort by my Subtitle but still keep the gallery grouped by it's responses? 

[FabianAckeret · Accepted solution]

Hi @smartin 

On your Gallery.Items property, you can add the following formula:

SortByColumns(
    AddColumns(
        GroupBy(SelectedSST,"Help_Reasons","Help_Group"),
        "Total",
        CountRows(Help_Group)
    ),
    "Total",
    Descending
)

and then change your Subtitle label to ThisItem.Total.

---

Please click Accept as Solution if my post answered your question. Like my answer? Consider giving it a Thumbs Up. Others seeking the same answers will be happy you did.