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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Normalizing Dates with...
Power Apps
Unanswered

Normalizing Dates with Region Date Settings

(0) ShareShare
ReportReport
Posted on by

I have been working on a scheduling App and there is a small issue that I came across. 10% of our group has France (French) turned on because of their language and how IT has their MS accounts set up.

I noticed when writing data from the APP to the SP List, I am seeing DD/MM/YYYY from the 10% which totally screws with the inserted data.

I am sure there is a way to normalize the input from the calendar selector but it has me stumped.

Does anyone have a quick fix for me?

Cheers

Categories:
I have the same question (0)
  • TheRobRush Profile Picture
    11,128 Moderator on at

    I was actually just messing around with this on Friday, and it's weird. Once you change a date over to European it doesn't seem to come back just by wrapping it up in a dtv with, "en-US" anymore the conversion get's lost.

     

    What I would recommend, unless someone else has a better idea, throw this in the onchange of your calendar

    UpdateContext({monthSelect:Month(Self.SelectedDate), daySelect:Day(Self.SelectedDate), yearSelect:Year(Self.SelectedDate)})

     

    and then reference your date like so,

    DateTimeValue(monthSelect&"/"&daySelect&"/"&yearSelect,"en-US")

     

    let me know if that sends the date to sharepoint correctly. I think it should

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard