cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Multiple filter in lookup function on Nintex Form

Hi Nintex Gurus,

Can we have two filters in one lookup function like filter on Title and Created columns in lookup function on Nintex Form

lookup("Test", "Created", Current Date "Title" )

lookup("Test", "Title", Title, "Title" )

can we combine above both filters in one lookup function.

Pseudo query will be return Title from a sharepoint list where Title is strSomeString and Created  is equal to Current Date. 

Labels: (2)
0 Kudos
Reply
4 Replies
Workflow Hero

Re: Multiple filter in lookup function on Nintex Form

Hi,

it depends what you want to do with the result. Both lookup functions return text so you can combine it in a formula control:

lookup("Test", "Created", Current Date "Title" ) + lookup("Test", "Title", Title, "Title" )

will put both text values right after another. You can place a space in between by doing this:

lookup("Test", "Created", Current Date "Title" ) + " " + lookup("Test", "Title", Title, "Title" )

Is this helpful?

Best regards

Enrico

 

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Multiple filter in lookup function on Nintex Form

Hi Enrico i don't have combine output of both formula. I am looking for solution to add both filters in one lookup function, have a look at above Pseudo query.

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Multiple filter in lookup function on Nintex Form

You mean something like this?

lookup("Test", "Created", Current Date, lookup("Test", "Title", Title, "Title"))

 

Never tried it but it should work.

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Multiple filter in lookup function on Nintex Form

Hi Enrico,

I want to get Title if both created date = Current Date and Title = entered value

0 Kudos
Accept as Solution Reply