Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Power Apps Experimental Features / Issue display timestam...
Power Apps - Power Apps Experimental Features
Suggested answer

Issue display timestamp from Excel data to DataTable

Like (0) ShareShare
ReportReport
Posted on 6 Dec 2024 16:52:39 by CU01121428-0 4
I have problems displaying timestamps correctly in a DataTable in my Power App. 
The input data is from Excel stored in a column such as this:
 
 
My DataTable column in Power App is like this differnt functions to format it as date a time:
 
WIthout editing anything it looks like this which is somehting completly different:

 
 
  • ronaldwalcott Profile Picture
    ronaldwalcott 3,653 on 06 Dec 2024 at 19:00:52
    Issue display timestamp from Excel data to DataTable
    The date should display correctly if the excel column is defined as a date, The problem might be that the datatable is in preview and might not be configured to manage all locales
     
  • Suggested answer
    SwatiSTW Profile Picture
    SwatiSTW 577 Super User 2025 Season 1 on 06 Dec 2024 at 17:39:30
    Issue display timestamp from Excel data to DataTable

    • The issue happens because Excel stores dates as numbers, and Power Apps reads them as raw numbers instead of dates.

    • Use this formula in the Text property of your column in Power Apps to convert the number to a proper date and time:
      Text(DateAdd(Date(1900, 1, 1), Value(ThisItem.Timestamp) - 2, Days), "yyyy-mm-dd hh:mm:ss")

    • This formula takes the Excel number, converts it to a date starting from January 1, 1900, and formats it into a readable format.

    • Replace ThisItem.Timestamp with the name of your column if it is named something else.

    • Apply the formula in the relevant field or column where the date is displayed in your DataTable.

    • Ensure the data in Excel is consistent and clean, with no blanks or errors in the timestamp column.

    • If needed, format the dates in Excel to make them readable before uploading to Power Apps.

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

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Power Apps Experimental Features

#1
mmbr1606 Profile Picture

mmbr1606 49 Super User 2025 Season 1

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 22

#3
stanmiller95 Profile Picture

stanmiller95 16

Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans