Announcements
setting varDate=datepicker.selecteddate but want to set varDate to be blank if a tick box "No date required" is selected
but set(varDate,"") comes up with "imcompatible type" error
Hi @fless1,
check this out https://powerusers.microsoft.com/t5/General-Discussion/Update-blank-Null-value-to-fields-Date-User-Choice-field-etc-in/m-p/116448/highlight/false#M41488
it may be the answer you are looking for. If it works, please mark this thread as solved.
Instead of "", use Date(Blank(),Blank(),Blank()). Sets it to null value, but in a date format.
None of these answers worked for me and I really did not want to recreate the date columns in separate text columns.I had to use this formula on the submit button:
SubmitForm(Form1); If(Or(IsBlankOrError(DataCardValue8.SelectedDate), IsBlankOrError(DataCardValue9.SelectedDate)), RecordsRetentionSetNullDates.Run(RecordsRetentionList.Selected.ID, IsBlank(DataCardValue8.SelectedDate), IsBlank(DataCardValue9.SelectedDate)), "");
And set up a corresponding flow to input those null values in the date fields.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 1,070
Valantis 639
11manish 608
