list lookup requires relation check against itself, why?

[#1]

Hello together,

I´m new to the product and im struggling with the problem that I´m unable to get a list lookup to work. I am now searching for a long time, but I could not find an answer.

I´m trying to get the field "ReminderDate" from my list and to check it against the current date. So if the "ReminderDate" is equal today is should send a mail to the person which is defined in the send notification.

But the problem is, I don´t know how to define the "ReminderDate = today". In the SharePoint workflow designer it´s simple to create a lookup for the field and to check it against the current date.

Why do i always get the relation function twice? I only want to use this date (not to check the date itself) and to check it against the current date.

Does anybody know a solution?

Thank you.

[christopheraucq]

Hi Daniel,

In your red rectangle, check 'Use Date when action is executed' and equals (ignoring time) if available to you.

It should work but I have tried it out without success.

You can also in your case use less or equals, just set-up when your workflow runs, accordingly.

If you really need the date only, you can also read this blog post

Regards,

Christophe

[#3]

Hi Christophe,

thanks for your reply. I tried it, but It doesn´t work. if the ReminderDate is today or tomorrow nothing happens. If I try the same with a item based workflow it works.

Is it possible to run the list workflow for the whole list as a scheduled task? Or do I have to configure this in  another way?

[christopheraucq]

Daniel,

What is working for a item based workflow?

Regards,

Christophe

[#5]

The workflow works if I build it up for an intem based run. But not if I build it as a siteworkflow.

Here the item based condition check:

[christopheraucq]

Can you share a screenshot of your query in the Site Workflow?

[#7]

Hi Christophe,

yes for sure.

[christopheraucq]

Daniel,

What I can tell you is that I have tried also using the List Lookup in the action Run If and it does not work as expected (I have created this post some hours ago). Maybe good to contact Support.

Regards,

Christophe

[#9]

Hi Christophe,

thank´s for your info. I will give a reply if i find a sollution.

[christopheraucq]

Hi Daniel,

Did you contact Support for that issue?

Other persons think that it can be a issue.

So if you did not report it, I'll do.

Regards,

Christophe