web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps SortByColumns (issue a...

Power Apps

Unanswered

SortByColumns (issue again)

(0) Share

Report

Report

Posted on by frwewrfwef

39

"PickTime" is a text column. Thats why I put TimeValue. But the code is returning an error.

Any help would be greatly appreciated.

SortByColumns(
Filter(
'SharePoint List Name',
(DateValue(Created) = Today() || DateValue(Created) = DateAdd(Today(), -1)) && Not(IsBlank(Scheduler))
),
"Date_x0020__x0026__x0020_Time_x0", SortOrder.Descending,
TimeValue("PickTime"), SortOrder.Descending
)

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @frwewrfwef

What format is the "PickTime"? If it's Time or Date time format, it's not possible to populate the values into PowerApps. Please use Text columns instead. When using Text function, it's just convert the format of values that have retrieved from the data source.

SortByColumns( Filter( 'SharePoint List Name', (DateValue(Created) = Today() || DateValue(Created) = DateAdd(Today(), -1)) && Not(IsBlank(Scheduler)) ), "Date_x0020__x0026__x0020_Time_x0", SortOrder.Descending, , Text("PickTime", "hh:mm AM/PM"), SortOrder.Descending )

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
HI @frwewrfwef ,

TimeValue( ) function will accept text. What is purpose of using TimeValue. Can you try to use this

SortByColumns( Filter( 'SharePoint List Name', (DateValue(Created) = Today() || DateValue(Created) = DateAdd(Today(), -1)) && Not(IsBlank(Scheduler)) ), "Date_x0020__x0026__x0020_Time_x0", SortOrder.Descending, "PickTime", SortOrder.Descending )

------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB

Join the conversation