Answered

Datepicker save date as text in excel

(1) Share

Report

Posted on by ARODRIGUEZESCOT

Hi! I have a problem I can't solve. I have a datepicker in one datacard associated with an excel table. The problem is that the date I choose is saved in my exel table as text instead of a number (or a date). I have tried with the function text on the Update property and also the DateValue function.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Have formatted the excel column as Date?

If not format the column as Date, remove the datacard and reinsert.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
ARODRIGUEZESCOT 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi!

Thank you for your answer. unfortunately it didn't work. I think that the issue coul be fixed with the Update property from the datacard where the datepicker is located, but I haven't been able yet.
My excel column is formatted as a date, but the new rows created still gets saved as a text, instead of a number that I can format. At the first 2 rows I changed manually the date and the error gets reflected in the app. It's like there are two different languages... (look at the first two images).

I have also been looking about the original format that the datepicker write the information. I think it's not a date value, but it's a text, isn't it?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @ARODRIGUEZESCOT,

Have you solved your problem?

Do you want to save selected date to your Excel table?

I think you have something misunderstanding with the date format within Excel table.

If you have formatted the column as Date, then the value within always expects date value. Even if it display as numbers, it is Date value when logic works.

In addition, make the entire date column format as the same date format.

To tell you the truth, I always suggest a General column type to save the date because you could use the Text() function to format the date as any format you want to, like "dd mmm yyyy"

Then you just need to modify the Update property as below:

Text(DatePicker1.SelectedDate,"dd mmm yyyy")

Was this reply helpful? Yes No
ARODRIGUEZESCOT 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft!

I have just try it and it worked!!! Thank you so much!!!

Best Regards!

Was this reply helpful? Yes No