web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Powerapps SortByColumn...

Power Apps

Unanswered

Powerapps SortByColumns not working for Lookup and OptionSet column values.

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I have a DataTable which is having Lookup and OptionSet columns. when i am trying to sort the columns then there arises an error: "Function sortByColumns has some invalid arguments".Also it is not taking relationship data.Can anyone help me out to solve the problem.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

mdevaney 29,991 Moderator on at

Like (2)

Report
Copy link

Link copied!
@Anonymous
Unfortunately, SORTBYCOLUMNS can only be used on simple data types: text, number, date, boolean, etc. It cannot be used in cases where the column holds a record: lookup, options set, etc. You will need to try a strategy like this instead.

Sort(Sort(Sort(your_datasource_name, Column1.Value, Ascending), Column2.Value, Ascending), Column3.Value, Ascending)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No

Join the conversation