Difference between datetime of Sharepoint List and Power App

(0) Share

Report

Posted on by alessandrodaros

Hi,
the time in the data table connected to SharePoint has increased by one hour and I don't understand why.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Abhilash_Swain 901 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @alessandrodaros ,
Check the regional settings in the Site Collection settings in SharePoint. SharePoint online normally defaults to whatever timezone the server is in unless you change the regional settings for the site collection.

You can see the dev server for share point is lagging almost 7 hrs for me. Chenage the setting in Sharepoint if you have access.

Please give me a Thumbs up if I answered your question and mark it as a solution to help others.

Thanks

Abhi (LinkedIn)

Was this reply helpful? Yes No
alessandrodaros 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Abhilash_Swain,
This isn't a problem of Sharepoint, the datetime in Sharepoint is OK, the datetime in Power App is wrong, one hour ahead.

Was this reply helpful? Yes No
Abhilash_Swain 901 on at

Like
a
(0)

Report
Copy link

Link copied!

You can avoid this difference . Make sure the regional setting (Time zone) in Sharepoint matches with your local system time zone.

Was this reply helpful? Yes No
alessandrodaros 6 on at

Like
a
(0)

Report
Copy link

Link copied!

sharepoint time zone is correct, what can i do ?

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @alessandrodaros ,

Maybe you could try to check the timezone setting in Power Apps. In addition, you might consider using the DateAdd() function.
Text(DateAdd(ColumnName,-1,Hours),ShortDateTime24)

Best Regards,
Charlie Choi

Was this reply helpful? Yes No