Announcements
The column "Date" is a text not a date type!
Looking at the event code above the Items box, your Patch() function converts the date to text to save it, so I'm guessing date is a formatted text field.
You can convert it to a date for sorting with the DateValue() function. Not sure if you can do this directly in the SortByColumns() column parameter but if not you can use AddColumns() combined with your Filter() to create a date column that you can use in your gallery to sort and in whatever controls you need to.
Try:
SortByColumnns( AddColumns( Filter( ...), "ReallyDate", DateValue( Date) ), ReallyDate, ... )
Reference:
AddColumns()
DateValue()
my error is SortbyColumn is an unknown function
ortByColumnns( AddColumns( Filter(colGridDate; Mitarbeiter = User().Email); "ReallyDate"; DateValue( Date) ); ReallyDate; SortOrder.Ascending )
That seems to be missing an 'S'.
But if you're only sorting on one column then you only need to use Sort().
still shows the error !
You need to put the column name "ReallyDate" in "" marks, sorry I should have done that in my example. Like in your original code you have "Date" in "" marks in your SortByColumns function.
SortByColumnns( AddColumns( Filter(colGridDate; Mitarbeiter = User().Email); "ReallyDate"; DateValue(Date) ); "ReallyDate"; SortOrder.Ascending )
still dont work !
This is not helpful. What's the error? Can you screenshot showing the error?
SortByColumns is a unknown and unsuported function !
You don't need SortByColumns(), just change it to Sort() since you're only sorting one column.
I think this maybe a PowerApps 'quirk'. Sometimes the connect to the server lags and you get errors that aren't really errors. Saving the app, exiting and going back in can sometimes fix this.
i also tried with sort, i also think it is because of power apps ! we will see!
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.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305
