Unanswered

Date picker not resetting date

(0) Share

Report

Posted on by lagonz

I have a multi-tab form tied to a Sharepoint list that tracks work items.

"Latest Status Date" is a date column on Sharepoint that has a date picker in the custom form. It defaults to Today's date when the ImputForm is in New mode, and to the existing value when in Edit mode (Parent.Default).

I want to add a "Set Today" button so the user just has to click on it to update the date on the column to Today. What variable should I configure for this to happen? I tried OnSelect: Reset(DataCardValue16), but that only works when testing the form -I guess that's because on test the form is set to New and it uses Todays date. How can I "pass" today's date to the DataCardValue16?

Also, is there a better solution, like including a "Today" button or link within the date picker itself?

Thanks!

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-chengfen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

HI @lagonz ,
Do you want it to display today's date?
Try setting the DefaultDate property to Today()

Best Regards
Cheng Feng
lagonz 2 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried that before and just tried again following your message. The problem is that when the user tries to Edit the record, the date gets immediately overwritten.

The same happens with records that don't have data in the Latest Status Date field: the user goes to Edit and the field gets immediately overwritten with Today's date.

The intent is that the field gets updated only when the user has a material update, no by just going to Edit mode. I didn't find a way to add a "Today" box to the date picker, so added this button.

The button has the following action OnSelect: Reset(DataCardValue16)
The data card hast the following default: If(InputForm.Mode=New,Today(), ThisItem.'Latest Status Date')