Skip to main content
Community site session details

Community site session details

Session Id : gKd/K24S5H2SA9qgd015O/
Power Apps - Microsoft Dataverse
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 25 Apr 2024 18:14:16 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
    567 Moderator on 28 Apr 2024 at 07:20:17
    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 26 Apr 2024 at 08:11:06
    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,318 Super User 2025 Season 2 on 26 Apr 2024 at 07:02:51
    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 our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Featured topics

Loading complete