Saving a Blank Date on a date comlumn it's impossible.

[FacundoGorla]

Hello!

I have a powerapps of a SharePoint list Form and I've tried every possible thing that comes to my mind to be able to edit an element and change the value of a date column (that contains a date) into blank, null or empty and then save it.

Whenever I save it just keep the former value on the element.

Here's the closer I've got, this is on the DatacardValue of the Date Datacard. I need to become empty whenever I select an option in a Selection button.

If(
    Radio1.Selected.Value = "Desaprobado"; DateValue(Blank()); Parent.Default
    )

I know it puts the Blank() in the DatacardValue because I can see the example text, but when I save it nothing happens to the element and if click edit again it still has his old value.

I can provide Images if necessary.

THANKS!

[v-xida-msft · Accepted solution]

Hi @FacundoGorla ,

Do you want to write a Null value back to the Date type column in your SP list using PowerApps form?

It is an known issue within PowerApps, we could not write a Blank value back to Date type column in SP List directly. As an alternative solution, please take a try with the following workaround:

Firstly, you need to turn on the "Formula-level error management" option within Advanced settings of App settings of your app. Then configure the Date fied data card in your Edit form (SharePointForm1) as below:

Set the DefaultDate property of the DatePicker control within the Date field data card to following:

If(Radio1.Selected.Value="PowerApps", Blank(), Parent.Default)

On your side, you may type following:

If(Radio1.Selected.Value = "Desaprobado"; Blank(); Parent.Default)

Please take a try with above solution, check if the issue is solved.

Please check and see if the following blog would help in your scenario:

https://powerapps.microsoft.com/en-us/blog/new-feature-error-handling-and-writing-null-values-to-dat...

Best regards,

[FacundoGorla]

That formula was the first I tried and didn't work but with the "Formula-level error management" enabled it worked perfectly.

Thanks for the suggestion, I wont be able to figured out. 

BTW what does that option actually do? If you don't mind explaining me.