If a date picker is linked to a date column in a data source that is non mandatory, you can set a date but can't then clear it again. The only way is to remove it in the SharePoint list directly.
Can you not set it to Blank()?
This is true of Excel data sources, too.
I find that in most of my apps, this kind of functionality is necessary. Pretty much any time you have a date picker (unless it's for a date of birth), you need to be able to clear the date entirely.
I am trying so many workarounds but those workarounds have ripple effects that destroy other functionality within the app and I'm coding in circles.
Strangely enough, datepickers were completely ignored in the null/blank values blog post at the end of March.
I've created a PowerApp that has multiple datepicker controls. This is a training request form. I want the trainer to be able to choose a toggle to choose which of the submitted dates that person's training is scheduled, fill the Control for "Approved Training Date" with the date chosen. I have done all of that, but if the Trainer wants to "Clear Out" the training dates, they cannot delete the Date from the field.
The goal was to on each toggle, "OnUncheck" set the "Approved Training Date" to blank or Null. I have not been able to figure it out, and this thread looks like the appropriate spot to add my vote!
I cannot get a the date time picker to get a Null datetime2 to save to sql, this is essential for our app
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.