Answered

Change date format from Sharepoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello, I am using SharePoint list as data source and in the list there are two date columns. When I insert them in the power app, the hour is different by two hours.

What I should see "13/05/2019 07:00" and what I am getting "13/05/2019 09:00".

Any help or suggestions on how to fomart that value would be great.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

PowerApps always shows results in utc format
SharePoint also shows data in UTC format but when displayed converts it to local time zone

https://toddbaginski.com/blog/working-with-local-and-utc-dates-and-times-in-powerapps/

https://sharepoint.stackexchange.com/questions/256813/powerapps-date-only-field-showing-wrong-date-but-only-for-certain-dates

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply, but I do not see how to implement this.
I have a label in wich the text property is "thisItem.DateA", how do I modify it? Thanks
Verified answer

RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Use

DateAdd( thisItem.DateA, TimeZoneOffset(), Minutes )

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly