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

Community site session details

Session Id : LLnooeYXt1Ds4KNQvxNqtK
Power Apps - Building Power Apps
Answered

Date Field displays incorrectly in Datasource after patching from PowerApps

Like (0) ShareShare
ReportReport
Posted on 3 Jun 2021 13:54:21 by 168

Hi,

This might end up being a more of SharePoint issue, but maybe someone has had the same issue...

I have a PowerApps application that users use to enter events in that then creates a record in a SharePoint Online List.  It works fine when I, or many other employees use it, but i have one user that when they create the record, the date displays the day before in the SharePoint list.  I have placed a trace on the PowerApp itself, and can see when it calls the create item API that it passes the correct date value.

 

This gets a little more strange, when i select the record and select edit, it shows the correct date.

 

I have checked with the user their O365 profile that the region and timezone settings are set correctly, including in SharePoint and PowerApps and it all looks correct. 

 

Has anyone experienced this type of behaviour, or have any suggestions?

 

Thanks

K

Categories:
  • Verified answer
    zmansuri Profile Picture
    6,048 Super User 2024 Season 1 on 03 Jun 2021 at 16:36:06
    Re: Date Field displays incorrectly in Datasource after patching from PowerApps

    a82.jpg

    DateTimeValue function will convert any string to "DateTime". In this pic string in the text input is from my "TimeAsText" colum. and in the label it is converted to date. you can see the  type in formula bar

  • KennyJ Profile Picture
    168 on 03 Jun 2021 at 16:22:59
    Re: Date Field displays incorrectly in Datasource after patching from PowerApps

    Thanks, just tried this and it does get me a step closer, but my App relies on formatting and filtering on the date field.  The problem i am left with is that it doesn't recognise this as a valid date to do the calculation

  • zmansuri Profile Picture
    6,048 Super User 2024 Season 1 on 03 Jun 2021 at 15:38:34
    Re: Date Field displays incorrectly in Datasource after patching from PowerApps

    When you work with time and include PowerApps, Automate and SharePoint. due to different time zones and daylight saving and everything will always create confusion. 

    What we want is simple. Whatever the value we choose in PowerApps should be stored and displayed in SharePoint and anywhere else. For that create one simple text column in your SharePoint let's say "TimeAsText".

    Add this Colum in your SharePoint form where you are choosing date and time through your date picker control.

    Select data card of "TimeAsText" and set it's default property to take values from date picker control. That way you will get static value in your database which you can be sure of is not changed in anyway.

    a72.jpga73.jpga74.jpga75.jpga76.jpg

    As you can see datepicker control have 3 different components. Date,Hour and Minute. And we are also working with different timezones.

    "TimeAsText" field is not visible on forms. So user side nothing has changed. He will enter value as usual. As soon as he select date and time it will be entered in the text field hidden in form. And submitted with the form. That way we have field we can be sure of that it is not changed. As you can see in the final picture is from sharepoint.

     

     

  • KennyJ Profile Picture
    168 on 03 Jun 2021 at 14:18:08
    Re: Date Field displays incorrectly in Datasource after patching from PowerApps

    Its on a date picker field yes, not the created by.  Happy to try a workaround.

     

    Thanks

  • KennyJ Profile Picture
    168 on 03 Jun 2021 at 14:17:23
    Re: Date Field displays incorrectly in Datasource after patching from PowerApps

    I am sure i checked this, but i will double check, thanks.

  • zmansuri Profile Picture
    6,048 Super User 2024 Season 1 on 03 Jun 2021 at 14:12:34
    Re: Date Field displays incorrectly in Datasource after patching from PowerApps

    Your problem is strange if it's happening to only one user. I had the same experience a while back.

    Date was changing in SharePoint. But was showing correct in PowerApps form. Turns out for SharePoint every individual site has time settings. Which converted the date time value on it's own. Since my company is working from many location. With daylight saving and all. I didn't wanted to make that complicated.

    If you are talking about "Created" field which is default column in SharePoint. I have no idea. But, if you are talking about date picker control where user choose the date. I can give you a workaround.

  • C-Papa Profile Picture
    1,836 on 03 Jun 2021 at 14:08:43
    Re: Date Field displays incorrectly in Datasource after patching from PowerApps

    Hi, have you checked the users browser settings, if you go to setting and type language the below will pop up. i had a similar issue when people had their browser language set to English (US) rather than English(United Kingdom)

     

    C-Papa_0-1622729244823.png

     

    An easy way to check is put a text box into the APP and set its text property to Text(Today(),"dd mmm yyyy") if the date is correct when the user runs the app then the language or browser is not the issue 

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

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete