cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
patrickabel
Level: Powered On

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

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.

6 REPLIES 6
patrickabel
Level: Powered On

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

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

patrickabel
Level: Powered On

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

bump, any assistance here would be appreciated. 

jernejp
Level: Powered On

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

Any luck? I have the same issue

jernejp
Level: Powered On

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

Bump

TopShelf-MSFT
Level 10

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/1594...

 

@TopShelf-MSFT 

Highlighted
SaneN85
Level: Powered On

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.

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (7,982)