Powerapps SortByColumns not working for Lookup and OptionSet column values.

(0) Share

Report

Posted on by Community Power Pla...

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 (1)

Answers (0)

mdevaney 29,989 Moderator on at

Like (2)

Report
@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