web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Answered

Data table issues

(0) ShareShare
ReportReport
Posted on by 205

Hi there, 

 

Attempting to sort data table column "date" 

 

I would like it to have the newest data at the top and oldest and the bottom. 

 

Also, would like to change the date orientation as I am in the UK 

 

Current Orientation: MM/DD/YEAR

The one I would like: DD/MM/YEAR 

 

I have looked for videos online to help but have struggled. 

 

Thanks in advance for any help with this. 

 

 

date.PNG
Categories:
I have the same question (0)
  • Verified answer
    cofordpa Profile Picture
    77 on at
    For the date orientation, use the Text function.
    In the Datatable, select the date column.
    I forget which ThisItem is targeted, either Default or Text. When you find the property for ThisItem.Date (or whatever your Date column is referencing):
    Text(ThisItem.Date,"dd/mm/yy")

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard