Showing results for 
Search instead for 
Did you mean: 

Add the Ability to clear a Field mirroring the CRM workflow designers feature

In the existing CRM workflow designer we can choose a function to clear a field, Be it a lookup, text string or date field.  Basically setting it to Null in the db.  Presently there is nothing in flow which matches this that i can see or am aware of

In flow there is no clear way to do this. I can copy another date field using dynamic content and if the source is blank it will then set the destination as blank, i cannot gurantee the source is blank in this instance. 

Using a compose and setting to to NULL works for look ups and text stings when using the compose output as dynamic content. this will clear the target setting it to NULL. 

However for a date field the flow fails as the date field expects an inputw wiht in a specific date range rather then the 01/01/0001 which is tries to enter as NULL


odata.metadata=minimal\r\nOData-Version: 4.0\r\n\r\n{\"error\":{\"code\":\"0x80040239\",\"message\":\
"DateTime is less than minumum value supported by CrmDateTime. Actual value: 01/01/0001 00:00:00,
Minimum value supported: 01/01/1753 00:00:00\",\"innererror\":{\
"message\":\"DateTime is less than minumum value supported by CrmDateTime. Actual value: 01/01/0001 00:00:00,


The ability to celar a field if a condition is met is a sizable requirement on many workflows and there is not a clean way to do this presently with out some genuius temporary tables to contain blank date field which can then be used to set dynamic content


Status: New

Agreed! Newer feature.

New Member

you can try business rules on entity to achive this.

New Member

You can set a specific value like minimum date value by flow or set some specific condition then try to create business rule on entity which check you specific condition by flow and clear field value automatically. Yes I agreed it should be available under workflow but until that is available you can try this.