web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Datetime format issue ...
Power Apps
Answered

Datetime format issue after language template issues

(0) ShareShare
ReportReport
Posted on by 432

Hello All,

 

Yesterday I posted here

https://powerusers.microsoft.com/t5/Building-Power-Apps/some-variables-and-collections-have-been-reset/m-p/660994#M210613

 

Where I encountered some very odd issues as a result of switching browser..

Today I fire up my app, after we ''fixed''  yesterdays issues and want to try some more tests.

Purpose of the app is to update metadata fields of documents- so i select a document, fill in the fields and select the button to start the flow to update the data. The data includes a date at which this document was sent.

 

See examples from past flow runs:

wtfbrah.png

In the top 2 pictures we see examples of flow runs before all the issues happened. We see dd-mm-yyyy being accepted as a valid datetime format.

In the 3rd picture we see a flow run from several minutes ago ; where the datetime had been passed as dd-mm-yyyy   which caused it to fail.

In the 4th picture we see also a run from several minutes ago but where in powerApps i formatted date time to  yyyy-mm-dd before sending it to flow.

 

What can I do for my system to allow me to pass in dd-mm-yyyy again ? because working with an unnatural datetime format for our region can't be done. it will cause too many confusions for endusers.

Categories:
I have the same question (0)
  • Verified answer
    v-siky-msft Profile Picture
    Microsoft Employee on at

    Hi @gjeh ,

     

    The date format is up to the region setting of SharePoint site. Please go to SharePoint site setting to change to region/locale to Dutch(Netherlands).

     

    The locale determines the order of the month and day, with the year either first or last. So your sharepoint locale setting supports the "mm-dd" format.

    The reason why the first top two example works is that the "12-8-2020" is in the format of "mm-dd-yyyy", so when you change to use "18-8-2020", an error occurred.

    Hope this helps.

    Sik

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 326 Most Valuable Professional

#2
11manish Profile Picture

11manish 168

#3
sannavajjala87 Profile Picture

sannavajjala87 75 Super User 2026 Season 1

Last 30 days Overall leaderboard