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
Solved! Go to 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,
@Nandha you can try this
Text(DateTimeValue(Text(DatePicker1)), "[$-en-US]dd-mm-yyyy") it converts the date as 07-08-2020
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,
User | Count |
---|---|
253 | |
106 | |
94 | |
50 | |
39 |