Expression - Security Filter for Hierarchical View.

[jaichith]

Dear Friends, 

I am suck with a issue. I want to switch columns name dynamically according to the view name column value in Hierarchical Menu TABLE.

Need : Filtering the rows in the Hierarchical based on the values present in USER PERMISSION TABLE. If the returning value is "NO ACCESS", then particular row should not shown to the user. 

If this is achieved I could restrict the appearance of certain rows (View names) If the particular user is doesn't have access.

I have used the below Lookup () expression in the security filter of Hierarchical Menu TABLE, It gives me some error. Due to [View Name]  in lookup function.

IF(
    "no access" <> Lookup(
                    Lookup(useremail(), "users", "username", "user role"), 
                    "user permission", 
                    "user role", 
                    [view name]
                  ),
    True,
    False
)

Error : Function 'LOOKUP' must be passed constant values for its tableName, lookupColumn, and returnColumn parameters: LOOKUP(lookupValue, tableName, lookupColumn, returnColumn). Consider wrapping the constant parameters in double quotes to ensure correct parsing

Guide me - How to achieve my need. 

[jaichith]

I wish your kind attention here 

@AleksiAlkio @Suvrutt_Gurjar @Trevwiller @MultiTech