cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ICM
Level: Powered On

Make a CDS date field blank on edit/update

Is it possible to write back a CDS date field as blank/null value?

 

I can edit/update a text field as "" to clear it's value when I'm editing a form, but I don't seem to be able to blank a date field in any way.

 

I've tried UPDATECONTEXT({TempDate: Blank()}), using TempDate as the UpDate field for the Data Card, but this won't write back to the data source, it keeps the original value. When I set TempDate to any valid date it works, so I know it's not an issue with using TempDate. I guess this will also be true for any numerical value too, but I don't have any numerical fields on my form other than dates.

 

For the record, Blank() won't work for Text field Data Cards either when I Submit the form, which is why I use "" as mentioned above. At least I can clear the text fields using this method, but I'm at a loss as to how to achieve the same with dates.

 

Any assistance would be genuinely appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Make a CDS date field blank on edit/update

Hi @ICM,

 

We don't support setting the date picker to blank or editing inline yet, this is a good feature reuqest, consider to post this idea in the PowerApps Ideas forum, so it might be considered for future releases.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

You can however, set the DefaultDate – The initial value of a date control unless the user changes it.

https://docs.microsoft.com/en-us/powerapps/controls/control-date-picker

 

Regards,

Mona Li

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: Make a CDS date field blank on edit/update

Hi @ICM,

 

We don't support setting the date picker to blank or editing inline yet, this is a good feature reuqest, consider to post this idea in the PowerApps Ideas forum, so it might be considered for future releases.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

You can however, set the DefaultDate – The initial value of a date control unless the user changes it.

https://docs.microsoft.com/en-us/powerapps/controls/control-date-picker

 

Regards,

Mona Li

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ICM
Level: Powered On

Re: Make a CDS date field blank on edit/update

rickykenny
Level: Powered On

Re: Make a CDS date field blank on edit/update

@ICM@v-monli-msft

 

This is now enabled with the "Formula-level Error Management" experimental feature Cat Happy

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

 

Kudos to @Anonymous