How to multiple filter list lookup?

  • 11 July 2017
  • 4 replies
  • 33 views
A
Badge +1

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?

205461_pastedImage_2.png

4 replies

W
Userlevel 3
Badge +8

So this post will not help you ?

E
Userlevel 5
Badge +14

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

A
Badge +1

Hi there,

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

I have tried to describe the issue below.

List 1

205493_pastedImage_5.png

List 2

205490_pastedImage_2.png

List 3 (Nintex Form)

205491_pastedImage_3.png205492_pastedImage_4.png

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".

E
Userlevel 5
Badge +14

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'

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings