Clear date value

(0) Share

Report

Posted on by sbgoh

284

Hi,

I have a date field with datepicker in the edit form. I can clear the datepicker but when I clicked submit, the date field is not blank.

I tried to patch but it is not working too. I used "Blank()" as advise by user in the forum also not working. Any advise?

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

eka24 20,923 on at

Like (0)

Report

Fields in the Editform pick it source from the database. So if the connected table in the database for the date is not blank, then the DatePicker cannot be blank in Editform.

If however clearing means changing the form mode from Edit to new, then in the Default Date put;

If(EditformName.Mode=FormMode.New,Blank(),Parent.Default)

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
sbgoh 284 on at

Like (0)

Report

Hi @eka24 ,
I can clear on the datepicker but I cannot save the blank value in my sharepoint list.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Can you Display the formula you are using. Is the date column in Sharepointlist required?

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
sbgoh 284 on at

Like (0)

Report

Hi @eka24,

The field is a date column in Sharepoint and it is not mandatory field. I didn't have any specific formula.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Your initial Post states you are using an edit form. Does it mean the DatePicker is not part of the form?

Can you show a screenshot of the form

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (3)

Report

Hi @sbgoh ,

Delete the date text from the Date Picker control doesn't mean to clear the selected date.

To implement your needs, you have to add an extra Remove button in the data card to clear the selected date. Please refer to the following steps.

1. Unlock the data card, insert a Cancel icon

2. Set Icon.OnSelect: Set(vardate,Blank())

3. Set DatePicker.DefaultDate: If(IsBlank(vardate),vardate,Parent.Default)

4. Set DatePicker.OnChange: Set(vardate,1)

5. Enable the "Formula Level error management" in Advanced Setting. (Important!)

Hope this helps.

Sik

Was this reply helpful? Yes No
sbgoh 284 on at

Like (0)

Report

When I enabled the "Formula Level error management" in Advanced Setting, my other dropdown list behave very weird. It is save properly or changed when I edit a record.

Was this reply helpful? Yes No
BPNJMC1 72 on at

Like (1)

Report
@sbgoh,

After turning on the Formula-Level Error Management experimental feature as you suggested, I was able to save empty/null dates after doing only the following:
Clear out DatePicker.InputTextPlaceHolder
Set DatePicker.IsEditable = True
I didn't need to create a cancel icon.

J

Was this reply helpful? Yes No
Zaki89 13 on at

Like (1)

Report

I had the same issue before. i just turned on "Formula-level error management" then it worked. Please try it

Was this reply helpful? Yes No
DrummingAddict 19 on at

Like (0)

Report

I would just like to append this response with adding Set(varDate,1) to the OnVisible property of the page the date picker is on so it will populate the default on initial rendering of the page.

Was this reply helpful? Yes No