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
Solved! Go to Solution.
Hi @fless1,
check this out https://powerusers.microsoft.com/t5/General-Discussion/Update-blank-Null-value-to-fields-Date-User-C...
it may be the answer you are looking for. If it works, please mark this thread as solved.
Hi @fless1,
check this out https://powerusers.microsoft.com/t5/General-Discussion/Update-blank-Null-value-to-fields-Date-User-C...
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
208 | |
98 | |
60 | |
51 | |
43 |
User | Count |
---|---|
258 | |
160 | |
85 | |
79 | |
57 |