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

How to multiple filter list lookup?

Hi all,

I have a form where i'm trying to filter the list lookup. I have to filter data between two SharePoint list so this would require multiple layer of filter.

On Control Settings - List Lookup, i can only filter the data once whereas i need multiple filter.

Is there any other way to do this?

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

Re: How to multiple filter list lookup?

So this post will not help you ?

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: How to multiple filter list lookup?

or if so haven't setup your lists in a way that support cascading lookups and can not change it anymore, have a look on this  

however, cascaded lookups should be preferred approach

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: How to multiple filter list lookup?

Hi there,

Thanks for your reply. I'm not trying to cascade drop down.

I have tried to describe the issue below.

List 1

List 2

List 3 (Nintex Form)

What i have done:

  • In Nintex Form, I have setup the Batch No. as lookup list which grabs Batch No. from List 1.
  • Default value of Date = Current Date.

What i am trying to do:

  • Filter the Batch No. where Product Line AX = OME and (Product Code(List 1) = Item Code(List 2)) and Item Group (List 2) = Finished Good.

Expected Result

In Nintex Form, Batch No. drop down should only show "BN12345".

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: How to multiple filter list lookup?

so I understand it this is a static filter, ie. filter doesn't change on other form controls values.

then I'd suggest to create a view on list with all these filtering conditions an then configure lookup control to filter by 'Source view'

0 Kudos
Accept as Solution Reply