Update Sharepoint Listitem and set datetime column to null

Like (0) Share

Report

Posted on 6 May 2024 14:12:31 by MB29

Hey Community,

i have a Flow which cycles through a get listitems and updates those listeitems.
Problem is that i have a date column which shall be set to null in the update items action.
Normally, what i found in the Forums and Copilot :), setting the Date column to null should do the job

But when i do so i get the following error

Any ideas or hints what i am doing wrong?

thx in adv.

manni

All responses (3)

Answers (2)

MB29 67 on 07 May 2024 at 09:58:39

Like (0)

Report

Re: Update Sharepoint Listitem and set datetime column to null

thx much, that did the job.

The other side effect was that that switching from new to old designer emptied all the fields in my other condition path for the creation process 😂.

but at least it now works as expected.

cheers 🍹
Verified answer

v-yetonggu-msft on 07 May 2024 at 01:51:09

Like (1)

Report

Re: Update Sharepoint Listitem and set datetime column to null

Hi @MB29 ,

I just tried updating the date column to null in Classic Designer,the flow works fine without errors.

Please switch to classic designer and re-create Update item control,then try again.

Best Regards,

Sunshine Gu
Verified answer

rzaneti 4,096 Super User 2025 Season 2 on 06 May 2024 at 14:50:21

Like (1)

Report

Re: Update Sharepoint Listitem and set datetime column to null

Hi @MB29 ,

Have you tried to disable the new designer? Sometimes the new interface has some issues with the null expression.

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/