cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MW19
Level: Powered On

Date format outputted to SP list

Hi All,

 

I am using a datepicker to send and update a SP list. However the format in the SP list is "m/dd/yyyy".

I have my format set in PowerApps as "dd/mm/yyyy" and you can see in the attached image that the datepicker displays as I want, however the output to SP is wrong.

 

Can someone please advise what is happening here?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Date format outputted to SP list

Hi @MW19,

Based on the issue that you mentioned, I have made a test, and the issue is confirmed on my side.

I think this issue is not related to PowerApps itself, instead, it may be the issue within SharePoint. On my side, the default format of Date column is "mm/dd/yyyy".

Actually, the date format within SP list is dictated by Locale. Please check and see if the following article would help in your scenario:

https://social.technet.microsoft.com/Forums/ie/en-US/ade1b4a2-7eac-479a-9dde-baa66eb18e36/how-to-cha...

 

As an alternative, you could consider take a try to create a calculated column within your SP list instead of the Original Date column to display Date value, then type the following formula within the Formula box:

=TEXT([Due Date], "mm/dd/yyyy")

1.JPG

On your side, you should type:

=TEXT([Your Date Column], "mm/dd/yyyy")

Or

=TEXT([Your Date Column], "dd/mm/yyyy")

 

Best regards, 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Date format outputted to SP list

Hi @MW19,

Based on the issue that you mentioned, I have made a test, and the issue is confirmed on my side.

I think this issue is not related to PowerApps itself, instead, it may be the issue within SharePoint. On my side, the default format of Date column is "mm/dd/yyyy".

Actually, the date format within SP list is dictated by Locale. Please check and see if the following article would help in your scenario:

https://social.technet.microsoft.com/Forums/ie/en-US/ade1b4a2-7eac-479a-9dde-baa66eb18e36/how-to-cha...

 

As an alternative, you could consider take a try to create a calculated column within your SP list instead of the Original Date column to display Date value, then type the following formula within the Formula box:

=TEXT([Due Date], "mm/dd/yyyy")

1.JPG

On your side, you should type:

=TEXT([Your Date Column], "mm/dd/yyyy")

Or

=TEXT([Your Date Column], "dd/mm/yyyy")

 

Best regards, 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MW19
Level: Powered On

Re: Date format outputted to SP list

Hi @v-xida-msft,

 

That works! Thank you very much again.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

Follow PowerApps on Twitter

Stay Up-to-Date by following PowerApps on Twitter

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 49 members 3,844 guests
Please welcome our newest community members: