Date Picker Input wrong values

[Nandha]

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

 

[krishnags]

@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 · Accepted solution]

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:

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,