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!
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.
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().
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.
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.
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
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.