Clear DateTime Field using MS Flows | CloudFronts

Clear DateTime Field using MS Flows

Introduction:

 

We had a requirement, where using MS flows, we had to set the field named Outreach which was a datetime field as blank.

For a  date time field,null expression cannot be directly set and so we could not clear the existing Date in this field

When I tried to set null, it failed with an error “Minimum value for date can be 01/01/1753”.

 

Solution:

We used the below work around.

Add a step Convert Time Zone, add base time as Null.

Since we are not actually converting from any time zone, we can keep source and destination time zone as same.

For the record on which we want to set date as null, configure run after as below.

For the date, now set converted time instead of null

Conclusion: The date will be cleared and set to blank.


Share Story :

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close