How to Clear a date field in CDS using Flow

(0) Share

Report

Posted on by MaxPP

Hi,

Is there a way clear a date field in CDS using flow?

Use Case:

Book due Date = 2/24/2020

I need to clear the date and set it back to blank (---)

Thanks for the help

Max Tampa

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (0)

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

Hi,
Do you have a flow already setup?

Or did you need help creating the flow?

Basically just update the record with a space in the date field

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
MaxPP 10 on at

Like (0)

Report

@Jcook

Hi Josh,

I tried the space and got the following error

{"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, Minimum value supported: 01/01/1753 00:00:00",

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

@MaxPP
What about if you try to use the expression null?

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
MaxPP 10 on at

Like (0)

Report

@Jcook

Hi Josh, same error with null expression

Was this reply helpful? Yes No
PowerBack19 679 on at

Like (0)

Report

@MaxPP - I just tested using NULL from an Expression to clear the field and it works just fine...IF you use the newer Common Data Service (current environment) connector. The only way you can use this connector is to create the flow from a Solution.

Within Power Automate, click on "Solutions" on the left-hand side. Fill in all the appropriate information to create the Solution. Once created, open the Solution, then click "+New" at the top and choose "Flow". This will launch a new browser tab. In the search field when searching for connectors, type in "Common Data Service". You will see 2 listed...be sure to choose the one called "Common Data Service (current environment)".

By using this new connector, there are other things to be aware of, but that can be addressed if needed.

Was this reply helpful? Yes No
MaxPP 10 on at

Like (0)

Report

@PowerBack19

I am not sure why I do not see the (current Environment connector). I created a solution and then added a new flow from inside the solution.

Thanks
Max

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

@MaxPP
You wont be able to add the Flow to the solution..
The only way would be to create a New Flow inside the solution.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
MaxPP 10 on at

Like (0)

Report

My Original flow was created inside the solution. What is the expression syntax you are using to set the null?

Was this reply helpful? Yes No
John Holmes 10 on at

Like (1)

Report

Has anyone actually got this to work? It seems incredible that something so easily achieved in a Standard Workflow can't be done in Flow or Logic Apps.

I have (like others) tried all variants of Null including the Expression with the various CDS connectors and none of them seem to work.

Looks like I am going to have to resort to creating a Flow for part of my update then trigger a Workflow to clear the fields afterwards unless anyone can help.

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

Hello @John_Holmes99 , @MaxPP

Try this:
https://www.agileo365.com/2019/03/blanking-out-date-fields-in-dynamics.html?m=1

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No