Solved

List lookup (Sharepoint) Nintex forms - multiple filters

  • 23 November 2023
  • 3 replies
  • 154 views

Badge +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?

icon

Best answer by oysteinbruce 24 November 2023, 09:50

View original

3 replies

Userlevel 6
Badge +22

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.

Badge +3

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.

Badge +5

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 

Reply