Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Cannot update a Date field to an empty value?

I have a flow set up to update a SharePoint list, specifically to reset the status of all entries. However, in order to do that, I need to reset the date field to a blank value; attempting to do that gives the error 'String was not recognized as a valid DateTime.' Searching on the forum gives the suggestion that Numbers cannot be marked null; is it the same for DateTime fields?


For the record, the two calculations I'm using to reset date fields:

"@blank()" for the first

"@adddays(startofmonth(adddays(utcnow(),31)),-1,'yyyy-MM-dd')" to get the last day of the current month

Advocate IV
Advocate IV

Is the column "required" in your list settings? Can you create a new form instead of trying to reset forms that have already been submitted?

Community Support
Community Support

Hi @daniel_arm,


Can you please send us the detailed configuration of this flow? 




Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


Frequency: Day

Interval: 1





If No, Do Nothing

If Yes:


Get Items


Apply to each

Select an output from previous steps: [sharepoint item] value


Sharepoint: Create Item


Sharepoint: Update Item

Site Address: [same as sharepoint item]

List Name: [same as sharepoint item]

*Id: [sharepoint item] ID

*Task: [sharepoint item] Task

Category: [sharepoint item] Category

Completed: No

Completion date: "@blank()"

Due Date: "@adddays(startofmonth(adddays(utcnow(),31)),-1,'yyyy-MM-dd')

The specific error message that occurs when trying to run using this configuration is:

{ "Title": "Close out due MOCs", "Completed": false, "emvr": "@adddays(startofmonth(adddays(utcnow(),31)),-1,'yyyy-MM-dd')" }

String was not recognized as a valid DateTime.


This indicates to me that the cause of the error is a lack of interpretation of @ commands within the Update Items function; when I tried using the Create Items function, the calculated values are reflected in the new item, but it lacks the Person or Group field that is absolutely vital for usability.


At this point, I have attempted both routes I can think of to get this working in Flow; unless there are changes on the horizon, I will need to search out a separate piece of software to get this scheduled refresh working.

New Member

click dynamic content, choose expression in popover dialog, in Fx box type null, click ok. this should set date to null

Thanks @alok91, setting to Null worked for me to clear out my date field!

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,335)