Unanswered

Unable to sort the Date and Time column in ascending order

(0) Share

Report

Posted on by mcn24

I am unable to sort the Date and Time column in ascending order using Sort List. Data are text format. I changed time to 24hr format and it does not work either. Your advice is much appreciated.

date and time.png

Categories:

Power Automate Desktop

All responses (3)

Answers (0)

Sort by

UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mcn24

You can use Excel as database or Run.net action to sort the date and time

for more clarification please send me the sample input so that I can give a Try.

Hope this helps,

Usha.
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

HI @mcn24

Use Run .Net action as shown below

You can sort the date and time like this

Hope this helps

Usha.
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

If you want to use excel as database then write an sql query as shown below

%Excel File Path% is the variable in which path of the excel file stored.

Hope this helps,

Usha.