How to sort a data table in PA

(0) Share

Report

Posted on by Didi-Fischer

Hi all, hope somebody could help me with the following.

As you can see at the attachment I work with a data table in PA.

I would like to sort the entries by Trip Start date. I tried a lot meanwhile, but still not successful.

Could somebody please give me the right kick what to do ??

Thanx in advance,

Didi

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Didi-Fischer is the Trip Start Date field actually a date data type in your source data?

Was this reply helpful? Yes No
narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Didi-Fischer

It seems like the date field is not actually a date data type.

Cheers!

Was this reply helpful? Yes No
Didi-Fischer 28 on at

Like (0)

Report
Copy link

Link copied!

Hi Amik, yes there are REAL dates data !

Was this reply helpful? Yes No
Didi-Fischer 28 on at

Like (0)

Report
Copy link

Link copied!

next problem is just popping up...
how can I hide rows where Trip End is in the past ???
Thanx for help again !!

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Didi-Fischer below is a basic example of the syntax you need to apply to the Items property of the Data Table. Have you attempted this?

Sort( 'Your Data', 'Your Date Field', SortOrder.Ascending )

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

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Didi-Fischer 28 on at

Like (0)

Report
Copy link

Link copied!

Hi,
That was the kick I needed 😄
Because I am working with european system I need to put ";" instead of "," than it works. Many thanks.
Any idea for the hiding problem ???

Was this reply helpful? Yes No
Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Didi-Fischer - you need to apply a Filter and then wrap the resulting table with the a Sort function. E.g.

Sort( Filter( 'Yuor Data'; 'Your Date Field' > Today() ); 'Your Date Field'; SortOrder.Ascending )

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

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No