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

All responses (14)

Answers (0)

PowerBack19 679 on at

Like (0)

Report

Re: How to Clear a date field in CDS using Flow

@MaxPP - The screen shot you provided is the list of actions and not the list of connectors. The list of connectors is above the actions. Below is an example. There are 2 listed. However, if you hover over the second one you will see it's named "Common Data Service (current environment)"
John Holmes 10 on at

Like (0)

Report

Re: How to Clear a date field in CDS using Flow

tried all that - couldn't get it to work so reverted to a Workflow
Jcook 7,779 Most Valuable Professional on at

Like (0)

Report

Re: How to Clear a date field in CDS using Flow

@John_Holmes99
Please try the recommendation from the blog I shared above.

—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
John Holmes 10 on at

Like (0)

Report

Re: How to Clear a date field in CDS using Flow

Still get an error using this expression
converttimezone(null,'GMT Standard Time','GMT Standard Time')

InvalidTemplate. Unable to process template language expressions in action 'Clear_Fields' inputs at line '1' and column '2988': 'The template language function 'converttimezone' expects its first parameter to be a string that contains the time. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#ConvertTimeZone for usage details.'.
Jcook 7,779 Most Valuable Professional on at

Like (0)

Report

Re: How to Clear a date field in CDS using Flow

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
John Holmes 10 on at

Like (1)

Report

Re: How to Clear a date field in CDS using Flow

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.
MaxPP 10 on at

Like (0)

Report

Re: How to Clear a date field in CDS using Flow

My Original flow was created inside the solution. What is the expression syntax you are using to set the null?
Jcook 7,779 Most Valuable Professional on at

Like (0)

Report

Re: How to Clear a date field in CDS using Flow

@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
MaxPP 10 on at

Like (0)

Report

Re: How to Clear a date field in CDS using Flow

@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
PowerBack19 679 on at

Like (0)

Report

Re: How to Clear a date field in CDS using Flow

@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.