Sort by calculated label control in gallery

[ardak2]

Hello Sir @WarrenBelz 

I have a gallery with following settings. These settings works perfectly. But I like to sort the gallery in the Descending order by Label1_3, the label that sums ThisItems's total. (Please see attached screenshot of gallery - Value column. Label1_3, is the one I like to sort by. I did a lot research and try to modify former similar approaches to my problem but couldn't get it to work. If you could tell me what to put to each of these fields (newbee), that would be great. Thank you in advance

Gallery Items:

Distinct(
    Filter(
        flowdata1,
        Not(IsBlank('Requirement Owner'))
    ),
    'Requirement Owner'
)

Title1_1 Text:

ThisItem.Value

Title1_2 Text:

CountRows(
    Filter(
        flowdata1, 'Requirement Owner' = ThisItem.Value &&
        (Dropdown_ContractStatus_ReqOwner.Selected.Value = "All" || 'Contract Status' in Text(Dropdown_ContractStatus_ReqOwner.Selected.Value)) &&
        (Dropdown_FY_ReqOwner.Selected.Value = "All" || FY = Text(Dropdown_FY_ReqOwner.Selected.Value))

    )
)

Title1_3 Text:

Text(
    Sum(
        Filter(
            flowdata1, 'Requirement Owner' = ThisItem.Value &&
        (Dropdown_ContractStatus_ReqOwner.Selected.Value = "All" || 'Contract Status' in Text(Dropdown_ContractStatus_ReqOwner.Selected.Value)) &&
        (Dropdown_FY_ReqOwner.Selected.Value = "All" || FY = Text(Dropdown_FY_ReqOwner.Selected.Value)))
        ,
        'Award Amount'
    ),
    "[$-en-US]#,###.00"
)

[WarrenBelz]

Hi @ardak2 ,

Apart from Value being a very bad name for a field (I strongly suggest you change it), you need to use AddColumns to the actual gallery Items (you cannot sort a gallery by a calculated label inside it).  Also this does not appear to be the correct filter as Value is a number and 'Requirement Owner' is Text. What exactly are you trying match to what to get the value for the sort field ?

With
   {
      _Data: 
      Filter(
	     flowdata1,
		 (
            Dropdown_ContractStatus_ReqOwner.Selected.Value = "All" || 
            'Contract Status' in Text(Dropdown_ContractStatus_ReqOwner.Selected.Value)
         ) &&
         (
            Dropdown_FY_ReqOwner.Selected.Value = "All" || 
            FY = Text(Dropdown_FY_ReqOwner.Selected.Value)
         )
      )
   },
   Distinct(
      Sort(
         AddColumns(
            Filter(
               flowdata1,
               !IsBlank('Requirement Owner')
            )
            "Award",
            Text(
               Sum(
                  Filter(
                     _Data, 
                     'Requirement Owner' = Value
                  ),
                  'Award Amount'
               ),
               "[$-en-US]#,###.00"
            )
         ),
         Award,
         SortOrder.Descending
      ),
      'Requirement Owner'
   )

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

[ardak2]

Hello Sir @WarrenBelz,

I have a sharepoint list with many rows. Each row has a Requirement Owner assigned and have Award Amount. As you could guess, same Requirement Owner exists in more than one row (see attachment 1). I bring data In this list to app via flow and response (premimum). Please see 3rd attachment. Since I bring them as string, I dont have to deal with column type of sharepoint list. So in the Gallery, I use the syntaxs above to get the gallery view, 2nd attachment. My above syntaxes and your snytax (I had AI to make minor corrections to yours) show up the same result, which is fine. It shows requirement owner names uniquely on one label and sums up all awards for each requirement owner on another label. so your corrected syntax showed the same results too but it is not in order. So as you see in 2nd attachment  I need that value (I;ll change name later) column to be sorted from highest to lowest. I would highly appreciate your help since I have spend a good 7-8 hrs and still no luck.

[ardak2]

@WarrenBelz Also, if the whole syntax you provided is going yo gallery items, what would be the text value of 3 gallery labels? Currently what i have each of them is listed above, so i would highly appreciate if you could guide me as what text values of each label would be if i were to use your hopefully modified syntax on gallery items. Thank you

[WarrenBelz]

Hi @ardak2 ,

The question you asked was regarding Sort by calculated label control in gallery, which I clarified that you cannot do this - you need to use AddColumns in the Gallery Items to create this field value.  The piece missing here is in connection with this bit (where ???? is shown)

Sum(
   Filter(
      flowdata1,
      (
         Dropdown_ContractStatus_ReqOwner.Selected.Value = "All" || 
         'Contract Status' in Text(Dropdown_ContractStatus_ReqOwner.Selected.Value)
      ) &&
      (
         Dropdown_FY_ReqOwner.Selected.Value = "All" || 
         FY = Text(Dropdown_FY_ReqOwner.Selected.Value)
      ) &&
      'Requirement Owner' = ?????
   ),
   'Award Amount'
)

You need to put in whatever value that this field needs to equal (it cannot be another label in the gallery or it is filtering on itself). The text labels are a completely separate issue as they do not affect this filter.