Now() is correct in PowerApps but wrong once pushed to SharePoint via Patch()

Like (0) Share

Report

Posted on 5 Apr 2018 22:04:43 by patrickabel

I have a Visitor Management Solution PowerApp which checks users in and out of an office.

On button click following the check-in process, I am running a Patch() command to take the current time via Now() and store this value as a timestamp to a list in SharePoint Online.

Now() shows the correct local time in PowerApps, but once this value is pushed to SharePoint, the value is two hours in the past. I'm in CST. What's the recommendation here? Is this simply a bug?

This is not a "your time-zone is wrong in SharePoint" issue.

I can do something like DateAdd(Now(), -2, Hours) in order to get the data pushed to SharePoint correctly but then I'll have to make the same correction/conversion everywhere in my app where this date-time is returned and shown. This approach would also not support situations where multiple time-zones are in play which will be common for me moving forward.

Categories:

General Questions

All responses (7)

Answers (0)

dallinp12 2 on 25 Jan 2024 at 19:19:17

Like (0)

Report

Re: Now() is correct in PowerApps but wrong once pushed to SharePoint via Patch()

Check your sharepoint regional settings. I had the same issue and my end-user's sharepoint site was set to Pacific Time, while we're actually on Eastern Time. Changing this fixed my issue
Community Power Pla... on 11 Oct 2019 at 05:15:42

Like (0)

Report

Re: Now() is correct in PowerApps but wrong once pushed to SharePoint via Patch()

think you have to use utcnow() so it adapts to the end-user's timezone. Could be wrong though.
Community Power Pla... on 09 Aug 2019 at 16:36:04

Like (0)

Report

Re: Now() is correct in PowerApps but wrong once pushed to SharePoint via Patch()

Hi All,

I found a similar thread that discusses timestamps in SharePoint. Please review the following and let me know if it's helpful

https://powerusers.microsoft.com/t5/Expressions-and-Formulas/Write-Date-Time-to-Sharepoint/td-p/159479

@Anonymous
Community Power Pla... on 26 Jun 2019 at 13:07:01

Like (0)

Report

Re: Now() is correct in PowerApps but wrong once pushed to SharePoint via Patch()

Bump
Community Power Pla... on 28 May 2019 at 13:20:30

Like (0)

Report

Re: Now() is correct in PowerApps but wrong once pushed to SharePoint via Patch()

Any luck? I have the same issue
patrickabel 53 on 15 Apr 2018 at 22:28:20

Like (0)

Report

Re: Now() is correct in PowerApps but wrong once pushed to SharePoint via Patch()

bump, any assistance here would be appreciated.
patrickabel 53 on 09 Apr 2018 at 02:57:03

Like (0)

Report

Re: Now() is correct in PowerApps but wrong once pushed to SharePoint via Patch()

Just checking back in, can anyone help on this issue?