Answered

Sorting SharePoint Calculated Column Content in Power App Combo Box

(1) Share

Report

Posted on by Phineas

5,331 Moderator

I am trying to sort the content of a SharePoint calculated column in a Power Apps Combo Box.

If I filter the SP column content it all comes through without issue, but it is not sorted.

When I replace 'Filter' with 'Sort' (see below) I get errors.

It is my understanding that SP calculated columns are not searchable in a Power Apps Combo Box?

Is this true, and does the same restriction apply to the sorting of SP calculated column content in a
Power Apps Combo Box?

What am I missing?

First Attempt:

If(Role_DataCardValue.Text = "Subcontractor",Sort(Staking_Collection,Cost_Type = "Subcontractor" && Title =
     Location_Dropdown.Selected.Value).Billing_Unit_and_Description,SortOrder.Ascending),
    If(Role_DataCardValue.Text = "Technician",Sort(Staking_Collection,Cost_Type = "In House" && Title =
     Location_Dropdown.Selected.Value).Billing_Unit_and_Description,SortOrder.Ascending)

Second Attempt:

If(Role_DataCardValue.Text = "Subcontractor",Sort(Staking_Collection,Cost_Type = "Subcontractor" && Title =
     Location_Dropdown.Selected.Value).Billing_Unit_and_Description,SortOrder.Ascending,
    If(Role_DataCardValue.Text = "Technician",Sort(Staking_Collection,Cost_Type = "In House" && Title =
     Location_Dropdown.Selected.Value).Billing_Unit_and_Description,SortOrder.Ascending))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Michael E. Gernaey 53,960 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi

You are going to get errors. So what you want to do is add a Sort Column into your data. You can do this with AddColumns, and when you do, set the Value = to the output of the Calculated Column, then sort by the new column.

AddColumns, DropColumns, RenameColumns, and ShowColumns functions - Power Platform | Microsoft Learn

Let me know if you have any questions

Was this reply helpful? Yes No
Verified answer

Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

@FLMike

Are you confirming my assumption is correct, that the issue is the restrictions on the SP calculated column?

Also, does this mean the output of an 'AddColumns' is not bound to the restrictions of a calculated column
in the Power Apps Combo Box, and would allow for sort and/or search of the returned results?

Was this reply helpful? Yes No
Suggested answer

Ravindra Jadhav 342 Moderator on at

Like (1)

Report
Copy link

Link copied!

In combobox you have less then 2000 item, then you can load that in collection and then sort it will work

Please Closed the Question, Mark it Solved

If my answer helped resolve your issue, please consider marking it as solved to assist others facing the same problem. Additionally, giving it a like would be greatly appreciated and motivates us to keep helping

Thank You

Ravindra Jadhav

Please Subscribe to https://www.youtube.com/@jadhav_ravi_oo7

Connect On https://www.linkedin.com/in/ravindra-jadhav-powerplatform/

Was this reply helpful? Yes No