By default in PowerApps portals, the date and time is showed in the format as configured in CDS/ Dynamics 365. However you can override the default date/ time format to be used on portals with the below site settings.
- DateTime/DateFormat: The date format used on the portal.
- DateTime/TimeFormat: The time format used on the portal.
- DateTime/DateTimeFormat: The format for full date and time used on the portal.
We have a requirement to display the date field in particular format such as 20-May-2020 in Power Apps Portals. This can be achieved by creating site setting in the below format.
Now let us create a site setting
Name – DateTime/DateFormat
Value – dd-MMM-yyyy
Screenshot for reference
![clip_image002[4] clip_image002[4]](https://i0.wp.com/debajmecrm.com/wp-content/uploads/2020/05/clip_image0024_thumb.jpg?w=1200&ssl=1)
Once you clear your portal cache, you should see the date time values now reflected in the portal accordingly.
![clip_image004[4] clip_image004[4]](https://i0.wp.com/debajmecrm.com/wp-content/uploads/2020/05/clip_image0044_thumb.jpg?w=1200&ssl=1)
It displays time as my date field is of type date-time format. For the benefit of readers, sharing some other format which can be of help.
1. yyyy-MM-dd – 2020-05-16
2. MMM dd yy – May 13 20
3. dd/MM/yyyy – 27/05/2020
4. dd/MM/yyyy HH:mm – 14/05/2020 12:27
5. dd/MM/yyyy hh:mm:ss – 12/05/2020 12:30:52 – 12 Hour format
6. dd/MM/yyyy HH:mm:ss – 27/05/2020 19:32:02 -24 Hour format
Hope this helps!
Debajit Dutta
(Dynamics MVP)
For consultation/ corporate training visit www.xrmforyou.com or reach out to us at info@xrmforyou.com
Our product offerings:
CRM-Sharepoint Attachment uploader and metadata manager (http://www.xrmforyou.com/sharepoint-integrator.html)
Notes Manager (https://debajmecrm.com/add-metadata-to-your-notes-and-attachments-in-dynamics-notes-metadata-manager-from-xrmforyou-com/)
Role based views for Dynamics 365 (http://www.xrmforyou.com/role-based-views.html)
Record Cloner for Dynamics 365 (http://www.xrmforyou.com/record-cloner.html)
Discover more from Debajit's Power Apps & Dynamics 365 Blog
Subscribe to get the latest posts sent to your email.