Unanswered

ModernDatePicker does not reflect saved DateTime values

(1) Share

Report

Posted on by IR-04101545-0

When using a ModernDatePicker inside a Form DataCard bound to a SharePoint Date and Time column, the control does not display the persisted value after saving and reloading the record, even though the value is correctly stored in SharePoint. The same scenario works correctly when using the classic DatePicker control.

I am working with a Canvas App that uses Forms (SubmitForm) connected to a SharePoint list.

The list contains a Date and Time column.

The field is implemented as a DataCard inside a Form. The value is set automatically using logic in the DataCard Update property (for example, to store the timestamp of the first save).

Example:

Update:

If(

IsBlank(ThisItem.MyDateTimeColumn);

Now();

ThisItem.MyDateTimeColumn

)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @IR-04101545-0,

You have noted that the correct date is in SharePoint after saving the record, so the issue would not appear to be the Update of the Data Card, rather either the DefaultDate of the Date Picker or the Item of the Form not updating after the save. Can you please post (in Text) these two values. If the DefaultDate is Parent.Default, what is the Default of the Data Card. If the Item of the Form is a variable, how and when is this updated.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Vish WR 3,748 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

I don’t see anything wrong with how you are saving the data. The issue is with the Modern Date Picker control.

The date is saved correctly in SharePoint, but when the form reloads, the Modern Date Picker doesn’t show the saved value.

This might be a known limitation with the Modern control.

You only need to change two things. In your DataCard Update property, use this:

Coalesce(ThisItem.MyDateTimeColumn, Now())

This will:

Keep the existing value if it already exists

Only set the date the first time

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @IR-04101545-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No