why the date does not save correctly ?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I want to save the date correctly without time !

But everytime i submit a form the date is saved with hours and minutes but i only want to save the date ?

here:

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

gcmfaizan 1,022 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

on your label where you want to display the date use this formula:
Text(YourCoulmn, "dd/mm/yyyy")

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous - what is your data source? Have you considered updating the field type to date only?

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

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

it is excel !

Was this reply helpful? Yes No
Prabhakar_S 735 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

In order to save the date from a form to an Excel you can try this way,

Patch(ExcelDataSource,
Defaults(ExcelDataSource),
{
Column1: DataCardValue7.SelectedDate,
Column2: Label1.Text
}
);

Thanks!

If my response has been helpful in resolving your issue, I would suggest you consider clicking "Accept as solution" and "Give it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

i already did but still not work

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous - Consider changing the Update property of Datum_DataCard1 to:

DateValue(DataCardValue1.SelectedDate)

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

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

still dont work, can it be because of excel ?

Was this reply helpful? Yes No
Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous "still don't work" is not very descriptive. Is there an error message or is the time still being displayed?

Working with Excel as a data source in Power Apps is quite unwieldy, particularly for Date field types.

Consider changing the column type in Excel to Text and then use the below in the DataCard Update property:

Text(DataCardValue1.SelectedDate,"dd/mm/yyyy")

Alternatively and ideally, move your data source to SharePoint or Dataverse.

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

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

okay it works now better, but does notsave the date!
When i add a new record then the date is not saved in excel:

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

rather i get values like this:

and in the app he shows me the default values

Was this reply helpful? Yes No