Reset SharePoint-List after Due Date without Failing Condition

[rekli2000]

Hallo,

i am working on a SharePoint-List which displays who is ill and till when.

In someway it works for now, but at the end its always a failure.

I want the workflow to reset the Date to Null if its passed.

As a Trigger i have a Recurrence ever Day at 6:00.

Here is my Flow:

Every Day it checks a Sharepoint list at the colum "bis..." if its over the due date. If yes it changes it to null.

This is my Problem:

It resets the Sharepoint-List as intended, but with an Error " cant equal with Null".

How can i solve it?

is there a way i can tell him to ignore the ones with null?

Thanks for the help and have a nice Day. 🙂

[jnernst]

I don't fully understand your situation and with no offense intended, I had trouble reading some parts of your post. What statement is trailing under the "If no" condition? If you left it empty, try placing a "Terminate - cancel" there.

Let me know how it goes!

Josh

[rekli2000]

Hey,

thank you for your answer.

If the condition is no, i want it to do nothing.

This is the important Part of the List.

This List shows how long somebody is ill.

My Intention was to make a Flow, which resets the colum  "bis..." if its expired. 

Everyday at 6:00 the Flow checks every single Line if its expired or not.

The Problem is if "bis..." is empty or Null it cant compare. The Result is an error for all empty ones.

How can i fix it to work without an Error?

[rekli2000]

[jnernst]

I would try to use the Terminate control. It forces your flow to stop. A type of break. So nothing would happen and it stops your flow from Erroring out.