Sort Column by date using the dates that is to be stripped from value in first column eg. Value data = STR-Joe-Bloggs23-03-2023

(0) Share

Report

Posted on by John777

Hi,

First Column data is in this format:

STR-Joe-Bloggs23-03-2023

STR-Nigel-Lovelace28-03-2023

I want to sort the column by date by stripping the date from end of value eg from Nigel's record I want the date at end 28-03-2023

as a variable and sort the columns records by date. I cant do this easy as the column is not a proper date field or string, it combined with the name. (Done Before my time)

Any Help Apricated.

John

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (4)

Sort by

Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@John777 ,

Actually you can add a column with the last 10 chars of the string and convert it to date value.

ClearCollect( test, Sort( AddColumns( yourDataSource, "Date", DateValue(Right(Value,10),"DE") ), Date, SortOrder.Ascending ) )

I noticed that the your date has an "European" similar format so I choose for date German date format representation.

Please note that this formula cannot be delegated on server side to be executed and the data resulted will be subject of powerapps limits (no more than 500-2000 items).

Hope it helps !

Was this reply helpful? Yes No
Verified answer

John777 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much for your advice. Below is the the code on gallery search. As I am not familiar with PowerApps, I need to modify it to accommodate your suggestion but not sure how. Can you help modify that code.

SortByColumns(Filter('NDIA Service Request', StartsWith(Participant_x0020_Last_x0020_Nam, SearchBox1.Text)), "Participant_x0020_Last_x0020_Nam", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
I wasn't sure how you want to sort the result by Date or by Participant Last Name, so I preferred Date:

With( { dataSource: Filter('NDIA Service Request', StartsWith(Participant_x0020_Last_x0020_Nam, SearchBox1.Text)) }, SortByColumns( AddColumns( dataSource, "Date", DateValue(Right(Value,10),"DE") ), "Date", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending), "Participant_x0020_Last_x0020_Nam", SortOrder.Ascending ) )

Hope it helps !

Was this reply helpful? Yes No
Verified answer

John777 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks' greatly for your input and fast reply. I will try this out today. 🙂

Was this reply helpful? Yes No