Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

PowerApps Portal Form CDS Data Field Australian Date Format

Posted on by 5

Date Format is en-US despite setting all settings to en-AU and the language code to the correct code for en-AU this is a CDS Date Field set to Date Only 

pastedimage1614840579438v1.png

pastedimage1614840698643v2.png

The Preview is broken and not working at the moment so no screen shot of the control but the date Picker when selecting a date shows a US date Format this is then breaking the Flow (Power Automate) as the Date is not right when submitted. This interface is also not upto par with the Power Apps Canvas Equivalent... Yet we are forced to use it or license every employee for a simple form. Licensing could be simpler.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: PowerApps Portal Form CDS Data Field Australian Date Format

    Hi Jason,

    In Microsoft Dynamics 365, the date for Portals is in a USA format by default.

    pastedimage1614913355890v2.png

    You can set date format as following steps.

    1.Go Portal Management App > Site Settings tab.

     pastedimage1614913639997v4.png

    2.Browse through the Site Setting records to check if you can find a record with "DateTime/DateFormat" in the Name field.

    if record found, you need open the record and edit the Value field to the desired date format string dd/MM/yyyy

    If not find, you need create new record.

    pastedimage1614913592458v3.png

    3.Save and refresh portal.

    pastedimage1614913849549v7.png

    Note: if my date format is not correct for Au, you can set correct format with same steps.

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans