cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

list lookup requires relation check against itself, why?

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.

list_lookup.jpg

Does anybody know a solution?

Thank you.

Labels: (1)
Reply
9 Replies
christopheraucq
Nintex Newbie

Re: list lookup requires relation check against itself, why?

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

0 Kudos
Reply
Not applicable

Re: list lookup requires relation check against itself, why?

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?

0 Kudos
Reply
christopheraucq
Nintex Newbie

Re: list lookup requires relation check against itself, why?

Daniel,

What is working for a item based workflow?

Regards,

Christophe

0 Kudos
Reply
Not applicable

Re: list lookup requires relation check against itself, why?

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:

list_lookup_item_based.jpg

0 Kudos
Reply
christopheraucq
Nintex Newbie

Re: list lookup requires relation check against itself, why?

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

0 Kudos
Reply
Not applicable

Re: list lookup requires relation check against itself, why?

Hi Christophe,

yes for sure.

query.jpg

0 Kudos
Reply
christopheraucq
Nintex Newbie

Re: list lookup requires relation check against itself, why?

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

0 Kudos
Reply
Not applicable

Re: list lookup requires relation check against itself, why?

Hi Christophe,

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

0 Kudos
Reply
christopheraucq
Nintex Newbie

Re: list lookup requires relation check against itself, why?

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

0 Kudos
Reply