Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

dynamic RLS

hello I have this table with the accesses that each user must have. furthermore i created this rule, however with use the maxx is only the last value is returned example: [email protected] should h...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Anonymous ,

     

    As the formula in the link you refer to you should create：

     

     

    Org Level 4 = LOOKUPVALUE (
    User[Email],
    User[Name],
    PATHITEM ( 'User'[Hierarchy], 4)
)

Org Level 3 = LOOKUPVALUE (
    User[Email],
    User[Name],
    PATHITEM ( 'User'[Hierarchy], 3)
)

Org Level 2 = LOOKUPVALUE (
    User[Email],
    User[Name],
    PATHITEM ( 'User'[Hierarchy], 2)
)

Org Level 1 = LOOKUPVALUE (
    User[Email],
    User[Name],
    PATHITEM ( 'User'[Hierarchy], 1)
)

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi v-deddai1-msft 

 

Thank you so much for your answer.


it solves the problem if I have a user for each access level. but if I want [email protected] and [email protected] to have AAA access level I get this error "A table of multiple values was supplied where a single value was expected."

 

Emailaccess levelNameParentHierarchy
[email protected]AAAAAA AAA
[email protected]AAAAAA AAA

 

can you help please?
thank you very much

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello v-deddai1-msft 
    I apologize for the delay in replying but I was on vacation so I didn't have access to my account.
    i understand i can't use looupvalue but what should i use. I need several users to have the same level of access. Please help me.
    thank you