How to sort in the browse screen by sharepoint list specific columns

(0) Share

Report

Posted on by AT_AlanTse123

181

Hello everyone,

I would like the sort button to sort the items by "Cable left" which is one of the columns in my SharePoint list - "CLPeS Cable Store".

Would anyone help how to sort by a column called "Cable left"?

Below is the code of the item in my browse gallery:

SortByColumns(

Filter([@'CLPeS Cable Store'],

'Cable Type'=Dropdown1_3.Selected.Result, Location=Dropdown3_3.Selected.Result,

"Title"),

"Title",

If(SortDescending1,

SortOrder.Descending,

SortOrder.Ascending)

)

Thank you very much for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

WarrenBelz 154,399 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @AT_AlanTse123 ,

Is this what you need ?

SortByColumns( Filter( [@'CLPeS Cable Store'], 'Cable Type' = Dropdown1_3.Selected.Result, Location = Dropdown3_3.Selected.Result ), "Cable Left", SortOrder.Ascending )

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

Was this reply helpful? Yes No
AT_AlanTse123 181 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply but it not work

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@AT_AlanTse123 ,

"Did not work" does not really help me - do you get an error (if so, what) or the wrong result ?

Was this reply helpful? Yes No
AT_AlanTse123 181 on at

Like (0)

Report
Copy link

Link copied!

Oh Sorry,
The error said that the the specified row "Cable left" does not exist
However my sharepoint list has this ccolumn

Thank you very much for your help.

Was this reply helpful? Yes No
AT_AlanTse123 181 on at

Like (0)

Report
Copy link

Link copied!
Hi @WarrenBelz ,

I refer below website
https://powerusers.microsoft.com/t5/Building-Power-Apps/SortByColumns-specified-column-does-not-exists/td-p/329610

and found that the reason is do with renaming the column as SortByColumn uses 'base' column names:
now i updated as below, it works, thank you very much for your help.
SortByColumns( Filter([@'CLPeS Cable Store'], 'Cable Type'=Dropdown1_3.Selected.Result, Location=Dropdown3_3.Selected.Result , "field_6"), "field_6", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending) )

Was this reply helpful? Yes No