cancel
Showing results for 
Search instead for 
Did you mean: 
adnanmuscat
Nintex Newbie

Filter List lookup on multi-value column

Hi,

 I have SharePoint List “Area” and another List “Application User” having Column “Allowed Area Name”, where “Allowed Area Name” is multiple select lookup field.

 

I am trying to filter “Area” Dropdown based on “Application User” column “Allowed Area Name”, on Nintix Form, for that I created one List look up of Drop down list type and calculated value field where I am getting current user “Allowed Area Name”.

 

parseLookup(lookup('Application Users','ID',1,'Allowed Area Name'))

Result

6.png

 

But Area List is not getting filter.

 

My list setp is explained in below images

 

1.png2.png3.png4.png5.png

Please help me

Labels: (1)
0 Kudos
Reply
1 Reply
Automation Master
Automation Master

Re: Filter List lookup on multi-value column

unfortunatelly lookup() function doesn't return a value that could be directly used as a filter input in this scenario.

 

try following

replace(replace(lookup('Application Users','ID',1,'Allowed Area Name'),"\[\]",""),",",";#")
0 Kudos
Reply