Hi
Experts im trying to sort the items based on name if entered and when they select the sortDecending1 button the items should sort based in the recent date order. i.e from new to old and when deselected the sort button gallery items so be normal as old to new.
I do not know if im doing it correctly or not the below code is correct or not. Can anyone help me, please? if m doing wrong and what part im doing ...
Thanks, experts
ON Items property of Gallery: also with the below formula im getting the delegation warning
When I used the above formula or code
Im getting an error. as below
Please see: I have converted date time to different formate using
ON text property :
Text(ThisItem.Created, "[$-en-US]d, mmmm yyyy")
Whereas initial it was just simple Datetime Formate
However, the error does remain the same. I.e. unable to sort items on date order ascending or descending.
Any help Experts Thanks.
Has to raise this query again as I did not get any feedback on my last one.
Thanks in advance.
Solved! Go to Solution.
I'm not completely sure of your formula as you mention sorting by date, but it appears to be sorting by title.
If you want to sort by the Created date, then you can consider using this formula:
SortByColumns(
Filter(
'Petty Cash & GL Code' ,
(StatusResult = "All" || Status = StatusResult) &&
(SearchBox.Text = "" || StartsWith('Name (Title)', SearchBox.Text))
),
"Created",
If(SortDescending1, Descending, Ascending)
)
This should give you results sorted by Created date.
Also, for future reference, if you want to sort by the Text version of a date, you should have your date in a yyyymmdd format. Otherwise your sorting will be incorrect.
I hope this is helpful for you.
I'm not completely sure of your formula as you mention sorting by date, but it appears to be sorting by title.
If you want to sort by the Created date, then you can consider using this formula:
SortByColumns(
Filter(
'Petty Cash & GL Code' ,
(StatusResult = "All" || Status = StatusResult) &&
(SearchBox.Text = "" || StartsWith('Name (Title)', SearchBox.Text))
),
"Created",
If(SortDescending1, Descending, Ascending)
)
This should give you results sorted by Created date.
Also, for future reference, if you want to sort by the Text version of a date, you should have your date in a yyyymmdd format. Otherwise your sorting will be incorrect.
I hope this is helpful for you.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
196 | |
67 | |
46 | |
41 | |
28 |
User | Count |
---|---|
255 | |
121 | |
84 | |
80 | |
80 |