cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kishorep
Regular Visitor

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
v-xida-msft
Community Support
Community Support

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
v-xida-msft
Community Support
Community Support

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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,266)