Sort and SortByColumns don't work with Named Formula tables

Like (0) Share

Report

Posted on 28 Jun 2023 10:58:14 by adedapo

256

I have a named formula table that is dependent on a data source, I noticed that I'm unable to sort this named formula with both Sort and SortByColumns. Note that I was sorting by a number column.

Categories:

Guidance

All responses (2)

Answers (0)

adedapo 256 on 29 Jun 2023 at 20:09:22

Like (0)

Report
Re: Sort and SortByColumns don't work with Named Formula tables

The data source is SharePoint.
Here is a sample of the code
//Named formula TblRequests = Sort(Requests, Created, Sort.Descending); //Text property of TextInput control First(Sort(Filter(TblRequests, StatementValue <> Blank()),StatementValue, Sort.Descending)).StatementValue
JorisdG on 29 Jun 2023 at 19:59:39

Like (0)

Report

Re: Sort and SortByColumns don't work with Named Formula tables

I tried but I seem to be able to do this just fine. Just to clarify, the named formulas is a table. You then use that named formula and try to sort it, correct?

Also, you mention a dependency on a datasource... what is the nature of this dependency? And does it work with a table not dependent on a datasource (that definitely works for me)? What kind of datasource is it (dataverse, sharepoint, etc.)?