Filter List lookup on multi-value column

[adnanmuscat]

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

But Area List is not getting filter.

My list setp is explained in below images

Please help me

[emha]

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'),"\[\]",""),",",";#")