Answered

Help with Date and Time discrepancy between app and sharepoint list

(0) Share

Report

Posted on by jbrines

1,151

I have a Sign In app that passes sign in date and time also sign out. But the create time and the sign in time are different most of the time.

Occasionally the Sign Out time is also different from the Last Modified date and time

I pass the date and time to a date and time field in a SharePoint list.

It maybe I am not using the correct method of recording date and time.

Categories:

Building Power Apps

All responses (18)

Answers (1)

Sort by

proximacentur 79 on at

Like
a
(0)

Report
Copy link

Link copied!
Greetings,

I have seen this issue before there however, I need a little more information.
Could you provide a screenshot or a snippet of the code you are using.
What function are you using to time? Datepicker or Today()?
Are there user accessing with the application in different time zones?
jbrines 1,151 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @proximacentur ,

See below images.
All working in the UK.
proximacentur 79 on at

Like
a
(0)

Report
Copy link

Link copied!

@jbrines
Thank you for the screenshot. Could you also provide a snippet of the code you are using upload the record into SharePoint? What is the trigger to pass in the DateTime values and are you using Patch, FormSubmit, or something else? Depending on how the values are formatted they could affect how they get converted to UTC in SharePoint.
jbrines 1,151 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @proximacentur ,

Basically using
SubmitForm(Sign_In_Form)
DanyV507 63 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @jbrines , what type is the column where you save the date and time of the app?
Another question, is the date and time entered automatically?
jbrines 1,151 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @DanyV507 ,

It is a Date and Time Column
DanyV507 63 on at

Like
a
(0)

Report
Copy link

Link copied!

@jbrines
Excellent, what we need to be able to identify how you are updating it in the update property of the date card in the form.
jbrines 1,151 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @DanyV507 ,

When the user clicks on Sign In it displays the current date and time (I have this hidden) so when they click on submit it uses that date and time on the screen.
proximacentur 79 on at

Like
a
(0)

Report
Copy link

Link copied!

@jbrines
You could try using setting a variable when the user clicks sign in something like.
Sign in Button:
Set(varCurrentDateTime,Now());

Then set the default value for the time entry datacard = varCurrentDateTime.
jbrines 1,151 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @proximacentur

The following "Sign In Date and Time_DataCard1" is linked to the Date and Time Field column in the SharePoint list, how would I add what you are saying to that as the Time has Hour and Minutes.