Sort by columns for choice column (cannot sort on the expression type)

(1) Share

Report

Posted on by CU16080510-3

Hi, I have below code on the OnStart property and I want to sort my modern data table by status choice column instead of title. When I change it to "Status" i will encounter expression type error.

SortByColumns(
    ClearCollect(
        reportList,
        AddColumns(
            Filter('[Trial] PBI to SP', UserID=User().Email),
            rStatus,
            LookUp(
                '[Trial] PBI Report Registration',
                '[Trial] PBI Report Registration'[@UniqueID] exactin '[Trial] PBI to SP'[@UniqueID],
                Status
                
            )
        )
    ),
    "Title"
);

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!

On SortByColumns expression, at the end, you have defined title as the field you would like to sort by. You will need to change that to the status column or any other column that you would like to sort by.

Sort and SortByColumns functions - Power Platform | Microsoft Learn

Hope this helps.

Cheers!

Was this reply helpful? Yes No
CU16080510-3 6 on at

Like (0)

Report
Copy link

Link copied!

Hi, as stated in my post, when I put status I got the error expression type error (It is a choice column not sure if it will impact anything)

Was this reply helpful? Yes No
Meekou 200 Moderator on at

Like (1)

Report
Copy link

Link copied!
You could not sort on Choice Column directly, you can add columns by Status value and then sort by Status value.

Here is a sample which Status is a choice column

ClearCollect( Test, SortByColumns( AddColumns( StudentsInfo, SortAbleStatus, Status.Value ), "SortAbleStatus" ) )

Best Regards
Meekou
米可爱分享 - YouTube
Power Apps
Power Automate

Was this reply helpful? Yes No
CU16080510-3 6 on at

Like (0)

Report
Copy link

Link copied!

Hi, i have changed it to Status.Value and changed title to rStatus or Status or "Status" or "rStatus". All got error.

Was this reply helpful? Yes No
Meekou 200 Moderator on at

Like (0)

Report
Copy link

Link copied!

Share a demo which including the test data and could reproduce your issue.

Was this reply helpful? Yes No