Skip to main content
Nintex Community Menu Bar
Solved

List lookup (Sharepoint) Nintex forms - multiple filters

  • November 23, 2023
  • 3 replies
  • 382 views
  • Translate

Forum|alt.badge.img+3

Hi!

 

I want to lookup information from a Sharepoint list in Nintex Forms. I am using the ‘List Lookup’ form control. The problem is that I want to filter based on two columns, and it seems that the ‘New Responsive Designer’ only makes it possible to filter on one.

 

Are there some workaround to be able to achieve my objectives?

Best answer by oysteinbruce

I've discovered the solution!

 

The key is to create a combined column, which is calculated using two separate columns. Then, apply a filter to this specific column instead. 

 

Hence, filtering on several columns.

View original
Did this topic help you find an answer to your question?

3 replies

SimonMuntz
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • 2464 replies
  • November 23, 2023

Hi @oysteinbruce,

At the present time, only one filter can be applied to List Lookup controls.
The only thing close to this would be to configure Cascading Dropdowns.

Translate

Forum|alt.badge.img+3
  • Author
  • Rookie
  • 8 replies
  • Answer
  • November 24, 2023

I've discovered the solution!

 

The key is to create a combined column, which is calculated using two separate columns. Then, apply a filter to this specific column instead. 

 

Hence, filtering on several columns.

Translate

Forum|alt.badge.img+5
  • Rookie
  • 22 replies
  • February 26, 2024

How do you apply that filter with a workflow task? Every time I’ve tried this, I get an error saying the {combined column name} is not available to use 

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings