web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Unable to Save Blank D...

Power Apps

Unanswered

Unable to Save Blank Date in Dataverse Using SubmitForm Function, where Date field is Time zone independent

(0) Share

Report

Report

Posted on by Viswanath

30

Hello Techies.

I have a Date field with Format "Date Only" ("Time zone independent") in Dataverse (Dynamics CRM). [ scrheenshow below].

and as this is already in use in prod, i cant recreate this field with "Date Only" in the Time Zone adjustment.

-> From Power Apps When i use the "SubmitFrom" function, the date of the birth is filled with a default date (12/31/1899) instead of blank.

I have already gone thorugh this This Link which didnt work out for me.

Thanks in advance.

Categories:

Microsoft Dataverse with Power Apps

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

Ram Prakash Duraisamy 5,891 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @viswa

You can try the code like below

If( IsBlank(DatePicker1.SelectedDate), Blank(), DatePicker1.SelectedDate )

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com
Viswanath 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rampprakash ,
Thanks for reply!
But for SubmitForm(form1), we dont need to pass any individual columns right. I can use the Patch function but in that case, Form's OnSuccess function wont get trigger and filed mandatory validations also i have to make it manual.
TuongDoan 573 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Try to set the default value of the datetime picker of your form to Blank()

---------------------------
If the solution I provided assisted you in resolving this issue, kindly select "Accept as solution" This will help others in finding the solution more expediently 😄Also, a Thumbs up would be a great compliment!

Join the conversation