Multiple filter in lookup function on Nintex Form

[mhashmi]

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. 

[praios81]

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

[mhashmi]

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.

[praios81]

You mean something like this?

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

Never tried it but it should work.

[mhashmi]

Hi Enrico,

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

[bejeweledone1]

Is there an answer to this?   I am looking at a need for the same thing.