Answered

Reset Date in Datepicker (in a form) with Button

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

My app shows the date at which a client was invoiced inside a date picker on a form and that date is stored in a Sharepoint list.

I would like to have a button that resets the datepicker to a blank value.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

all about date picker by April Dunnam
https://www.sharepointsiren.com/2019/05/powerapps-restricting-date-picker-options/

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(11)

Report
Copy link

Link copied!
Hi @Anonymous ,

You have to add a Reset button in the DatePicker DateCard, if you want to only reset the datepicker control instead of the whole form.
And please refer to the following steps
1. Unlock the DatePicker DateCard, and Add a button named Rest in it.
2. Set OnSelect property of button as below
UpdateContext({resetdate:true});Reset(DataCardValue1)
3. Set DefaultDate property of DatePicker as below
If(resetdate,Blank(),Parent.Default)
4. Set OnSuccess, OnRest, OnFailure property as below to causes the default value to be displayed the next time the form is opened
UpdateContext({resetdate:false})
Once click the reset button, the DatePicker would return blank value.
If you also want to update the Blank value of DatePicker to sharepoint list, you also need to turn on a New Feature setting: Formula-level error management
You can find it from File – App Setting – Advanced Setting – Formula-level error management.
Best regards,
Sik

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

Like
a
(0)

Report
Copy link

Link copied!

This worked perfectly! Thank you so much!

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

Like
a
(0)

Report
Copy link

Link copied!

Hi,
This works as explained in my test App (to test the reset) but when I copied the code over to my production App I started to get really odd behaviour.

After spending several hours trying to figure out why my production App failed I found that enabling "Formula-level error management" kills your connection to Flow (I use Flow to pull data from a stored procedure on Azure SQL database).

Not sure if there is a fix for this - anyone had the same problem and fixed it?

If not it looks like I'll need build a separate app just to clear dates (back to NULL).

Was this reply helpful? Yes No
arasbane 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-siky-msft ,

I have followed your guidance on this poste, and at first it appears as though this solution works.

Then I noticed that each reset button I created on my form will delete all of the date on all of the datepickers within the form.

In the OnSelect field for each button I added, I made sure I identified only the datacardvalueX pertaining to the datepicker I want each separate button to reset. I assumed that would ensure that one button only resets the date to the assigned datepicker. This is not the case. Unfortunately it deletes all dates.

Would you know the solution to this?

Thanks

Aaron

Was this reply helpful? Yes No
arasbane 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-siky-msft ,

When using multiple reset buttons on a single form with multiple date pickers, how do you follow your solution and prevent any one button from deleting the date on all of the date pickers?

Thank you.

Aaron

Was this reply helpful? Yes No
SpoTechGeek 63 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you. This saved me a lot of heartache.
Note that when resetting a combo box you need to reset DefaultSelectedItems instead of Default. Per your example:
DefaultSelectedItems =
If(resetdate,Blank(),Parent.Default)

Was this reply helpful? Yes No
geddb 109 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @v-siky-msft .

I can't believe that the simple process of clearing a control can be so complicated. Nevertheless, your solution worked perfectly for me. Thank you so much. 🤘

Was this reply helpful? Yes No
WorkingRicardo 878 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @v-siky-msft ty for your answer here. I almost managed to do everything here.
However, I'm stuck on this: "4. Set OnSuccess, OnRest, OnFailure property as below to causes the default value to be displayed the next time the form is opened"

Where are those properties? I can't find them in my PowerApps in any place 😕

Was this reply helpful? Yes No
cardinalnight 212 on at

Like
a
(0)

Report
Copy link

Link copied!
@WorkingRicardo - I've just required this solution and implemented it into my editForm. The EditForm is populated by a selecting an item in a gallery.
Step 4 from @v-siky-msft wasn't necessary for me. I added this:
UpdateContext({resetdate:false})
to the select item button in my gallery. This works for me.

Was this reply helpful? Yes No