Forum Discussion

NJ81858's avatar
NJ81858
Helper IV
2 years ago

Row Level Security Returning Error

Hello,   I am trying to configure a role that will show data depending on where the user falls on the company hierarchy, but I am receiving an error when I combine the statements into one.   My e...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago
var cu = USERPRINCIPALNAME()
return
IF( LOOKUPVALUE(User[Role], User[Email], cu) = "Tier1", User[Email] = cu, 
IF( LOOKUPVALUE(User[Role], User[Email], cu) = "Tier2", User[Tier2Email] = cu,
true()
))

 

However - the User table would need to participate in the data model which doesn't seem to be the case as you are using LOOKUPVALUE.   You may need to show more of your setup.