How to set a SharePoint date column back to blank

(1) Share

Report

Posted on by SPCloudguy

115

Hi,

Has anyone managed to set a SharePoint date field back to blank with the Update item SharePoint connector action? I receive the error "must be 'Datetime' whenever I try. Setting either a variable or directly to %''% doesn't help either.

I was hoping I could copy a blank value by using Get Item, but the element doesn't exist when the date is blank.

BTW, the categories option only allowed process advisor or Licensing so I couldn't pick an appropriate category for this post.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

creativeopinion 10,508 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

You need to insert an expression using the null function.

You might also be interested in this YT Tutorials:
How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks
Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate. I’ll cover some common use cases and concepts that can help you to build better Power Automate flows.
Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.
IN THIS VIDEO:
✅ 4 Date Functions You Need to Know
✅ How to use the Convert Time Zone Action
✅ How to Get a Future Date
✅ How to Get a Past Date
✅ How to Return SharePoint Items Due in a Number of Days
✅ How to Return SharePoint Items Due within a Date Range
✅ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days
✅ How to Calculate the Number of Days between Two Dates
✅ How to Check for a Birthdate and Anniversary Date
✅ How to work with Dates and Times in Excel
✅ How to use a Manual Trigger with Date Input
✅ How to Output Dynamic Text with an Expression
✅ How to Check if a Date Falls on a Weekend

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,968 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

What Creative said, but in some rare cases it doesn't work. (so please mark theirs if it works)

If it doesn't work, create a Compose, but the expression null in the Compose

Then in the value you want to make null, put the outputs('ComposeName')

And it will work

If this helps you please mark this answer as the answer.

Was this reply helpful? Yes No
Suggested answer

CA1105 545 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I've seen where you can add String('') using dynamically value but it is same as null. But worth to try.

Was this reply helpful? Yes No