NOW() from PowerApp not returning the same in Sharepoint List

[MarkB1977]

Afternoon all.

I have a simple canvas app where I am using Now() to trigger a FLOW. When a user submits the form via the canvas app, the time and date updates in a SP column formatted as time and includes the date.

No issues with that, except the data doesn't match!

For example

10/06/2020 15:39 in the app  = 09/06/2020 16:00 when SP is updated? 

It doesn't appear to be the issue between UTC and UTC+00:00 Dublin, Edinburgh, Lisbon, London either.

Any ideas?

[Paulo_VS]

@MarkB1977 

Hi guy,

Please show the code that does this update

[MarkB1977]

@Paulo_VS 

I have a label within an app,  which displays NOW().  When the app updates the information in SP, the date & time column doesn't return the same value. 

You can see the time and date in each isn't the same within the attached.

Form submitted 10/06/2020 17:18

SP returns 09/06/2020 16:00?  one day and 1hr 18mins earlier???

TEXT function - Now().

[KrishnaV]

Hi @MarkB1977 ,

Now() always get the local time unless you specify which time zone you want, as below

Text(Now(), UTC) this will get the UTC time:2020-06-10T16:33:26.763Z but Now() shows as 6/10/2020 12:32 PM

Having said that just check how it is getting date and time with respect to your SharePoint Tenant timezone.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

[Paulo_VS]

@MarkB1977 

I think you are confused, the Label being Now () it will always show the current time, to show the time that is in SP you need to reference, example: ThisItem.CollumnName

I hope this helps

[MarkB1977]

@Paulo_VS

No I want to time stamp the form submission from the app so now() is the correct function. It's the value it returns in the sp list that's different.