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'))
But Area List is not getting filter.
My list setp is explained in below images
Please help me
unfortunatelly lookup() function doesn't return a value that could be directly used as a filter input in this scenario.
replace(replace(lookup('Application Users','ID',1,'Allowed Area Name'),"\[\]",""),",",";#")