Unanswered

Change date format from Sharepoint

(0) Share

Report

Posted on by Community Power Pla...

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

I have the same question (0)

All responses (3)

Answers (1)

RezaDorrani 12,143 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

RezaDorrani 12,143 on at

Like (0)

Report

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

Was this reply helpful? Yes No