cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nandha
Frequent Visitor

Date Picker Input wrong values

Hi,

I have used a date Picker with format "dd-mm-yyyy", language-'en-US', UTC-Local

Powerapps linked with an Excel in ondrive. 

Most of the inputs from date Picker comes with defined format-(07-08-2020)

But sometimes it writes as (07-08-2020T00:00:00.000Z) due this one input the whole date column in Excel get changed to number format and makes mess.pls help me out

Screenshot_20200807-073625.png

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @Nandha ,

Could you please share a bit more about your scenario?

Which type is the "Date" column in your Excel table? Date only type column or Date Time type column?

 

Please make sure you have set the "Date" column in your Excel table as a "Date" only type column as below:

1.JPG

Note: You could also customize the date value format in your Excel table.

 

If you use general Text type column to store the selected Date value from your DatePicker control, please consider set the Update property of the Date field data card in your Edit form to following:

Text(DatePicker1.SelectedDate, "[$-en-US]dd-mm-yyyy")

 

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

2 REPLIES 2
krishnags
Responsive Resident
Responsive Resident

@Nandha you can try this

Text(DateTimeValue(Text(DatePicker1)), "[$-en-US]dd-mm-yyyy") it converts the date as 07-08-2020

v-xida-msft
Community Support
Community Support

Hi @Nandha ,

Could you please share a bit more about your scenario?

Which type is the "Date" column in your Excel table? Date only type column or Date Time type column?

 

Please make sure you have set the "Date" column in your Excel table as a "Date" only type column as below:

1.JPG

Note: You could also customize the date value format in your Excel table.

 

If you use general Text type column to store the selected Date value from your DatePicker control, please consider set the Update property of the Date field data card in your Edit form to following:

Text(DatePicker1.SelectedDate, "[$-en-US]dd-mm-yyyy")

 

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.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

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 (1,548)