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

Unable to store the Date Format in Excel as DD/MM/YYYY. Using Power Apps Date Picker.

Hi , I am pretty new to this PowerApps. I am trying to store the date in dd/mm/yyyy format. I tried finding a solution from other posts and ended up in just making them to view in DD/MM/YYYY format. I tried using the following and

ended up in getting the wrong result (I mean I am picking a date as feb 12 2019 and its storing in execel as 02/01/2020). 

image.pngimage.png

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Unable to store the Date Format in Excel as DD/MM/YYYY. Using Power Apps Date Picker.

HI @Kishorep,

Do you format a column as a Date type column in your Excel table to store the Date value picked from your app?

Actually, the Date Value format stored within your Excel table based on which Date format you set the Date column to in your Excel table.

In other words, if you want to store the Date Value format in your Excel table as "dd/mm/yyyy", you must format the Date column in your Excel table as "dd/mm/yyyy".

 

In addition, as an alternative solution, you could consider add a Normal Text column (DateOfContact1) to store the Date value picked from your app instead of Date type column in your Excel table. When you generate an new app based on your modified Excel table, the DateOfContact1 column would be decorated as a Text Input box rather than a DatePicker control in your Edit form.

After that, you could take a try to remove the Text Input box within DateOfContact1 Data card, then add a Date Picker control within it. Set the Update property of the DateOfContact1 Data card to following:

Text(DatePicker1.SelectedDate,"[$-en-US]dd/mm/yyyy") /* <-- Type Text(DatePicker1.SelectedDate,"[$-en-US]dd/mm/yyyy") rather than DateValue(Text(DatePicker1.SelectedDate,"[$-en-US]dd/mm/yyyy"))*/

Please check the attached GIF screenshot for more details:

 

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.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Unable to store the Date Format in Excel as DD/MM/YYYY. Using Power Apps Date Picker.

HI @Kishorep,

Do you format a column as a Date type column in your Excel table to store the Date value picked from your app?

Actually, the Date Value format stored within your Excel table based on which Date format you set the Date column to in your Excel table.

In other words, if you want to store the Date Value format in your Excel table as "dd/mm/yyyy", you must format the Date column in your Excel table as "dd/mm/yyyy".

 

In addition, as an alternative solution, you could consider add a Normal Text column (DateOfContact1) to store the Date value picked from your app instead of Date type column in your Excel table. When you generate an new app based on your modified Excel table, the DateOfContact1 column would be decorated as a Text Input box rather than a DatePicker control in your Edit form.

After that, you could take a try to remove the Text Input box within DateOfContact1 Data card, then add a Date Picker control within it. Set the Update property of the DateOfContact1 Data card to following:

Text(DatePicker1.SelectedDate,"[$-en-US]dd/mm/yyyy") /* <-- Type Text(DatePicker1.SelectedDate,"[$-en-US]dd/mm/yyyy") rather than DateValue(Text(DatePicker1.SelectedDate,"[$-en-US]dd/mm/yyyy"))*/

Please check the attached GIF screenshot for more details:

 

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.

View solution in original post

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,639)