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 Platform Community / Forums / Power Apps / Datepicker shows wrong...
Power Apps
Answered

Datepicker shows wrong date in SP

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi

I have encountered another problem on the datepicker whereas I have two datepickers on my EditForm.

Datepicker1 - A normal datepicker with time input and thats it. Its supposed to record the starting date and time of an aircrafts flight and its stores the data to a sharepoint column.

Datepicker2 - Is the exact same thing. I have tied Datepicker2's DATE default setting to Datepicker1 because no one will be flying any aircraft at night or through the night. and I will enter the TIME of day manually into the time entry field.
Also will then be stored in a sharepoint column.

Basically I can then go back and see the date, start time and finish time of the flight and I can then work out my own duration of the flight if I need to at a later stage.

My problem however, Is when I enter the dates in my Apps, all is good. But when I go back to my Sharepoint list the date is always off by 1 or 2 days and the time is always off by 3-4 hours.

Anyone encountered this before?

Regards
Lorcan

Categories:
I have the same question (0)
  • Verified answer
    v-monli-msft Profile Picture
    Microsoft Employee on at

    Hi Lorcan,

     

    This should be related with the date time zone.

     

    By default PowerApps would change the date time into UTC time zone. Currently this is not available for PowerApps to auto-detect the local time zones for the date time value. The Product team is aware of this and are working on a solution for this scenario.

     

    For a workaround, you may consider to use the text function to convert the time zones.

     

    For the details, please check the thread below:

    Date displayed is one day off

     

    Regards,

    Mona Li

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 416 Most Valuable Professional

#2
11manish Profile Picture

11manish 205 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 128 Super User 2026 Season 2

Last 30 days Overall leaderboard