Announcements
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.
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.)?
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 1,055
Valantis 666
11manish 666
