Date Field displays incorrectly in Datasource after patching from PowerApps

[KennyJ]

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

[C-Papa]

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)

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 

[zmansuri]

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.

[KennyJ]

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

[KennyJ]

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

Thanks

[zmansuri]

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.

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]

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 · Accepted solution]

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