Powerapps SortByColumns not working for Lookup and OptionSet column values.

Like (0) Share

Report

Posted on 1 Oct 2020 07:47:49 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:

Canvas Apps

All responses (1)

Answers (0)

mdevaney 29,987 Super User 2025 Season 1 on 08 Oct 2020 at 12:05:21

Like (2)

Report
Re: Powerapps SortByColumns not working for Lookup and OptionSet column values.

@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."