web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Sorting Gallery by cus...

Power Apps

Answered

Sorting Gallery by customer date column

(0) Share

Report

Report

Posted on by NeonThunder

76

I have a custom datetime column called 'Date from'. How do I sort by this date asc/desc?

Below is working code when sorted by 'created'

SortByColumns(Filter([@'Time Tracker'], 'Created by'.Email = varUser.Email), "Created", If(SortDescending1, Descending, Ascending))

However, if I change the column name to my datetime customer column it breaks?

SortByColumns(Filter([@'Time Tracker'], 'Created by'.Email = varUser.Email), "Date from", If(SortDescending1, Descending, Ascending))

Sharepoint list column...

Why is not possible to sort by this date?

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

HenriDesmet59 295 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @NeonThunder ,

does powerapps throw an error to you ?
NeonThunder 76 on at

Like
a
(1)

Report
Copy link

Link copied!

When I change I get the red lines with the text 'The function 'SortbyColumns' has some invalid arguments'.

Thanks, I have changed it to Datefrom and it works! But not sure why it doesnt like the space. The space exists on the list
HenriDesmet59 295 on at

Like
a
(0)

Report
Copy link

Link copied!

Oh okay, nice for you !

Join the conversation