Answered

reset date field

(0) Share

Report

Posted on by Madeleine

I would like to reset a date field with a button. At the moment I just have Reset(Datacardvalue3) - this is Datacard of the date I want to reset.

I have set the date default to today()+1 so I believe when reset it should reset the date to tomorrow, right?

Some backstory:

Modified SharePoint list form.

OnNew: I have added the date field and set the default date to today()+1 (It should actually be 365, but need to test) - works

OnEdit: I have the same date value but have set to view only (brings up correct date). Included a save button in the end with Submitform( editform1); Reset(Datacardvalue3)

The story behind it is that this item should be reviewed once a year. So built a flow to remind user to review item. User opens item, edits it and changes values (or not), then selects save which should reset the date field and tehy'll get another reminder next year)

Anything else I can try?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Madeleine ,
The issue I believe you have from what you describe is that a control can only be reset from within the form itself, which of course the SharePoint Integration OnSave function is not.
To test this, put a button in the card (you will need to unlock it) with the Reset and see if this changes the date to what you need.

Please click Accept as solution 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 giving it Thumbs Up.

Was this reply helpful? Yes No
Madeleine 26 on at

Like
a
(0)

Report
Copy link

Link copied!

I have added a button in the date card with OnSelect property set to Reset(datacardvalue3) but the button does nothing.

I'm quite happy with the button remaining here - can I perhaps set the date to today's date with that button? Still don't know how to...

I feel like I need something after the datacardvalue (Like if its a choice field you have datacardvalue.selected.value, and text fields you have datacardvalue.text, what do you use for dates?)

Was this reply helpful? Yes No
WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Madeleine ,
If you have this button on the date card with the OnSelect (change to your name)
Reset(YourDateCardName)
and the Default of this control is
Today()
and change the date to something else and reset, it works as below.

Please click Accept as solution 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 giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Madeleine ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution 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 giving it Thumbs Up.

Was this reply helpful? Yes No
Madeleine 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Warren,
Your post actually led me to uncover all sorts of other concerns. Such as realizing that my default was giving incorrect outputs. I eventually took out the default and used the button to set to a value that I needed.
So in my new form I set the review date with a formula to today +365 and on my edit form I have a button that sets that date to today +365. And it seems to work fun now.
I have one last issue with this form but will try one more thing on Tuesday and if that doesn't work I'll reach out to this forum again.
Thanks again for all your help!

Was this reply helpful? Yes No
WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Madeleine,
Please consider Accept as Solution to close the item and assist other to more easily find it.
Happy to help with your issue - I have plenty of time at the moment. Note timeline currently 8:30pm Saturday in Australia so allow for this on Tuesday.

Was this reply helpful? Yes No