Date and Time difference between Power apps and related Sharepoint list Need HELP

(0) Share

Report

Posted on by sabb17

Hi guys..

i created an app for my organization, to record the productivity of the employees.

Everything is fine...other than the date and time difference between Power apps and sharepoint.

In my app there are 2 fields to record Task start date & time and end date & time. Once i select date and time for both fields and submits on power apps, the related sharepoint lists shows difference in the entered date and time ( difference of 12 hrs always).

For eg- on power apps i entered 8-1-23, 10.00 AM. Then in the share point it shows 7-1-23, 10.00 PM.

PLease help and Thanks in Advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sabb17 ,

This will be a difference in the Regional Settings of the user's device and the SharePoint site. You need to check both of these.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

v-liwei-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @sabb17

Are you submitting the date to the List on the Form?
You can modify the Update property of the Form's date column DataCard.
By default, the Update property is:

DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0).

You can modify it to:

DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0)+Time(12,0,0)

Best Rgards,

Levi

1 people found this reply helpful.

Was this reply helpful? Yes No
sabb17 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your response. Unfortunately, I already tried it and still is not working.

Was this reply helpful? Yes No