Skip to main content

Notifications

Community site session details

Community site session details

Session Id : QbY9WmlrXYHUt+i3t+w6MS
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 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
    3,636 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
    547 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

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,786 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,093 Most Valuable Professional

Leaderboard

Featured topics

Loading started