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.
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
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.
You mean something like this?
lookup("Test", "Created", Current Date, lookup("Test", "Title", Title, "Title"))
Never tried it but it should work.
Hi Enrico,
I want to get Title if both created date = Current Date and Title = entered value
Is there an answer to this? I am looking at a need for the same thing.