Unanswered

Date Format issues upon Sharepoint embed

(0) Share

Report

Posted on by f8y454

I've embedded a PowerApp in a SharePoint site, connected to SharePoint lists at the backend. The SharePoint site is set to the UK region, and the dates on the lists are in the UK format dd/MM/yyyy. When I view the app in the app maker the date formats are in the UK format, however when I view the app on the SharePoint site the dates are displaying incorrectly as MM/dd/yyyy.

Is there some setting I'm overlooking that would be responsible for this?

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Go to the root of your site collection
Gear Icon > Site Settings
Click on Regional Settings under Site Administration

Under Region, click on Locale drop-down

Change to your locale/country
(see this link if still stuck: https://sharepointmaven.com/change-date-format-sharepoint/ )

If this is a helpful comment please like/kudo it to make me smile 🙂 and if it is your solution please click accept as solution

Was this reply helpful? Yes No
fishmangal011 21 on at

Like (0)

Report
Copy link

Link copied!

Hi,

this is a very frustrating issue. Even changing the regional setting on the SP site does not change anything.

The dates are correctly formatted on the app as wanted: did/MM/yyyy but when embedding to a SP site it reverts to MM/dd/yyyy.

Hope someone can assist with this.

Was this reply helpful? Yes No
harzicn 76 on at

Like (4)

Report
Copy link

Link copied!

This is an old one, but I am having exactly the same issue in 2022. The date in a calendar picker remains US standard.
I changed it in the SharePoint site regional settings, I set the calendar picker to 'Local' then 'UTC' then 'en-GB' and nothing changes it to a European/UK date format. This is very frustrating.
Any further advice would be most appreciated.

Was this reply helpful? Yes No
Grumbles 3 on at

Like (0)

Report
Copy link

Link copied!

Having exactly the same problem. PowerApp has correct date format dd/MM/YYYY, Sharepoint Site has correct date format dd/MM/YYYY. App embedded in Sharepoint site reverts to MM/dd/YYYY.

Was this reply helpful? Yes No
teqs 103 on at

Like (0)

Report
Copy link

Link copied!

I had this problem today. It would be really great if Microsoft would fix this. I am surprised that such big bugs are present in such a big, frequently used product all over the world.

Was this reply helpful? Yes No
Shoniyi 5 on at

Like (1)

Report
Copy link

Link copied!

It is the 11th of May 2023 and I am having same issue.
Really frustrating getting the remote team to work on the file.

Was this reply helpful? Yes No
hongkong 277 on at

Like (1)

Report
Copy link

Link copied!

Same issue for Power BI embedded on SharePoint.
Nice job Microsoft

Was this reply helpful? Yes No
StevePerry 2 on at

Like (0)

Report
Copy link

Link copied!

Yup - same issue here in New Zealand..would love a solution suggestion ASAP. Regional site setting = English (New Zealand) date formats in all embedded PowerBI reports now showing US. Changed pretty recently as never previously a problem.

Was this reply helpful? Yes No
CIro193 4 on at

Like (0)

Report
Copy link

Link copied!

Same issue here.

Was this reply helpful? Yes No
CIro193 4 on at

Like (0)

Report
Copy link

Link copied!

Just to add that this appears to be a known issue, and as it's been around for over 18 months I wouldn't expect a quick fix.

The "Embed a report web part in SharePoint Online" page [Embed a report web part in SharePoint Online - Power BI | Microsoft Learn] has a section of known issues and limitations that states:

Power BI doesn't support the same localized languages that SharePoint Online does. As a result, you might not see proper localization within the embedded report.

Was this reply helpful? Yes No