Filter List lookup on multi-value column

  • 13 March 2019
  • 1 reply
  • 1 view
A
Badge +1

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

946i9665E50E5B148F7D.png

 

But Area List is not getting filter.

 

My list setp is explained in below images

 

941i8E5054DEEFB62266.png942iDFEEFABCC42B655A.png943iD773CC2CEC8955C2.png940i514C29B8D0BA8293.png945i322729EE63121ECF.png

Please help me

1 reply

E
Userlevel 5
Badge +14

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

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings