cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gunjan
Level: Powered On

Not able to save null value into date field(CRM DYNAMICS instance).

date-issue.pngdateTime-issue2.pngsaved_date.png

Need to store the QuestionDue Date field , based on codition if it is modified new value and if no change in value keep the same value, but this is not happening, i have tried if(condition,'new value',null/''), but if i am not putting the value into the field '' the json on save shows "field_questionduedate":null, please help. 

I believe this is a bug with the microsoft Flow for DateTime fields.

7 REPLIES 7
Community Support Team
Community Support Team

Re: Not able to save null value into date field(CRM DYNAMICS instance).

Hi @gunjan,

 

Could you please share a full screenshot of your flow's configuration?

 

I have made a test and the issue is confirmed on my side. Currently, we could not save a null value into a Date column of Dynamics 365 entity, because the null expression would be converted into a empty string ("")  within flow and then typed into the Date column of Dynamics 365 entity.

 

I afraid that there is no way to save a null value into a Date column of Dynamics 365 entity using Microsoft Flow currently. If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gunjan
Level: Powered On

Re: Not able to save null value into date field(CRM DYNAMICS instance).

Thanks for your kind reply & try on this case, 

even i have tried to pass null through JSON- Object still not able to pass the null 

{

"Mydate":null

}

but still its not in good situation. If possible can you please raise a bug / ticket for the same topic ???

scott_mckenzie
Level: Power Up

Re: Not able to save null value into date field(CRM DYNAMICS instance).

I have run into the same problem. I fixed it by exporting the flow, manually updating the inputs and then re-importing.

 

The reason it happens is because the inputs are wrapped by the @ character and curly braces.  The result of this is always a string.  Refer to the Schema reference for Workflow Definition Language in Azure Logic Apps.

 

In your case you will probably find the input looks something like this:

 

"body": {
    "fedcap_proposalduedate": "@{items('actionname')?['Proposal_Due_Date']}",
    "fedcap_questionsduedate": "@{items('actionname')?['Questions_Due_Date']}",
    "fedcap_receivedfromemail": "@{items('actionname')?['Received_From_Email']}",
    "fedcap_rfptoreleasedate": "@{items('actionname')?['Rfp_To_Release_Date']}",
    "fedcap_taskordernumber": "@{items('actionname')?['Task_Order_Number']}",
    "fedcap_taskordertitle": "@{items('actionname')?['Task_Order_Title']}"
}

I have highlighted the curly braces which you need to delete so that it looks like this:

 

"body": {
    "fedcap_proposalduedate": "@items('actionname')?['Proposal_Due_Date']",
    "fedcap_questionsduedate": "@items('actionname')?['Questions_Due_Date']",
    "fedcap_receivedfromemail": "@items('actionname')?['Received_From_Email']",
    "fedcap_rfptoreleasedate": "@items('actionname')?['Rfp_To_Release_Date']",
    "fedcap_taskordernumber": "@items('actionname')?['Task_Order_Number']",
    "fedcap_taskordertitle": "@items('actionname')?['Task_Order_Title']"
}

 

 

Highlighted
Steveo1
Level: Powered On

Re: Not able to save null value into date field(CRM DYNAMICS instance).

Is there a proposed solution for this?  This is an issue for us as well.

gunjan
Level: Powered On

Re: Not able to save null value into date field(CRM DYNAMICS instance).

We have implemented in Way around in following steps,

1) Added a old date (ex 02/02/1902) and inserted into Dynamics for the values where no / invalid date/ null date was supposed to be inserted.

2) Using business rule if the date is 02/02/1902 clear the fields.

 

scott_mckenzie
Level: Power Up

Re: Not able to save null value into date field(CRM DYNAMICS instance).


@Steveo1 wrote:

Is there a proposed solution for this?  This is an issue for us as well.


Export the flow, remove the curly braces, import the flow.

gunjan
Level: Powered On

Re: Not able to save null value into date field(CRM DYNAMICS instance).

@scott_mckenzie 

please, 

Just need to confirm can we save Dyanamics 365 Date field with null value ???

 


@scott_mckenzie wrote:

@Steveo1 wrote:

Is there a proposed solution for this?  This is an issue for us as well.


Export the flow, remove the curly braces, import the flow.


 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 404 members 4,509 guests
Please welcome our newest community members: