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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard