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
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,372)