Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 27

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.

 

 

viswa_0-1714068401294.png

 

Categories:
  • TuongDoan Profile Picture
    550 Super User 2025 Season 1 on at
    Re: Unable to Save Blank Date in Dataverse Using SubmitForm Function, where Date field is Time zone independent

    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!

     

     

  • Viswanath Profile Picture
    27 on at
    Re: Unable to Save Blank Date in Dataverse Using SubmitForm Function, where Date field is Time zone independent

    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.

     

  • Ram Prakash Profile Picture
    5,179 Super User 2025 Season 1 on at
    Re: Unable to Save Blank Date in Dataverse Using SubmitForm Function, where Date field is Time zone independent

    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

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.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 19

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 17 Super User 2025 Season 1

Overall leaderboard

Featured topics