• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Technology
    • Development
    • Hardware
    • Intune
    • Microsoft
    • Office
    • Office 365
    • Security
    • SharePoint
    • Software
    • SQL server
  • Personal development
    • Blog
    • Career
    • Freelancer
    • Knowledge
    • NEWS
    • Private
    • Thoughts
  • Consulting services
  • Contact me

Not only IT

About life, IT and other things...

Home » Technology » SharePoint » Null value in date field – SharePoint designer 2013

Null value in date field – SharePoint designer 2013

August 23, 2013 By Tomasz Szulczewski Leave a Comment

Checking for a NULL Date Field in SharePoint Designer Workflow it can’t be done with some strict operation. I create workflow for SharePoint online with SharePoint designer 2013. It’s nothing fancy, many of us making such things, but finally I faced problem without solution. Client wants to limit direct operation on Workflow task list. If the item has been updated in proper way task should be mark as complete by workflow itself. It’s easy to achieve with Visual Studio, there’s on element “workflow item change”, but how to do this with SharePoint designer? Well, it’s not so difficult, we can use list action ”Wait for Field Change in the Current Item”. It works.

image

We will have a problem when the field is date type. Default behavior for this action is that field has to be equal specific value, but there’s no condition for “is not null”. So what to do? I’ve seen many complicated solutions, but I prefer something simple. So here’s…

The SharePoint designer 2013 finally has loop option. It’s very useful and for example if you write workflow with visual studio you probably used it. Anyway we need declared variable to exit the loop. So let’s create one:

image

And in first step of the workflow let’s initialize it with value equal 1. Now we have to add loop step. We have two possible loops, one of them runs n times and the second one runs until condition is true. We will use the second one. As you can see I use workflow variable which equals 1 and until it will be equal 1 it will run. Now the loop waits until date field will be greater than 1901-01-01, which in my case means that user enter new date to the field. When it will happen also loop exit variable will be set to 0, which create condition to exit the loop.

image
[adblockingdetector id=”5770e6ed85560″]
And finally we can mark task as complete.

Related

Filed Under: SharePoint Tagged With: SharePoint

About Tomasz Szulczewski

I've got more than 20 years of IT experience. IT is my passion and I am still increasing my skills. I work as a SharePoint, Office 365 and Azure architect.

Reader Interactions

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Join the Newsletter

Social media

  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
  • YouTube

Search this site

Sign up for Wise accounts

Signup and earn $25

payoneer
payoneer

My latest achievement

Microsoft 365 Certified: Enterprise Administrator Expert
Microsoft 365 Certified: Enterprise Administrator Expert

Tags

Azure Azure Active Directory BizSpark Blog career Certification cloud conference edge freelance Freelancer Hardware home office InfoPath Intune Knowledge licensing Microsoft Microsoft 365 News Office Office 365 Personal development Power virtual agent Private security SharePoint SharePoint designer SharePoint online Software SQL server upwork Windows Windows 365 yammer

Footer

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2022 Tomasz Szulczewski