web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps - Building Power Apps Null value for Date Va...

Power Apps - Building Power Apps

Answered

Null value for Date Variable

(1) Share

Report

Report

Posted on by fless1

55

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

Categories:

General Questions

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (3)

Report

Re: Null value for Date Variable

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.

Was this reply helpful? Yes No
fless1 55 on at

Like (0)

Report

Re: Null value for Date Variable

Thanks loads

Was this reply helpful? Yes No
cbrazenec 10 on at

Like (1)

Report

Re: Null value for Date Variable

Instead of "", use Date(Blank(),Blank(),Blank()). Sets it to null value, but in a date format.

Was this reply helpful? Yes No
takolota1 4,946 Moderator on at

Like (3)

Report
Re: Null value for Date Variable

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.

Was this reply helpful? Yes No

Join the conversation