Forum Discussion

ray_codex's avatar
ray_codex
Icon for Resolver II rankResolver II
1 year ago
Solved

RLS on different hierarchy levels

Hi,   I have this RLS question that I can't solve. In our organisation, because of complaincy, we want users to be able to see their own submitted hours but not the hours of other users. But, and t...
Need Help
  • v-csrikanth's avatar
    v-csrikanth
    1 year ago

    Hi ray_codex 
    Sorry for the late response.
    Could you try the below suggested that might resolve your issue effectively.
    ***********************************************************************

    VAR CurrentUser = USERPRINCIPALNAME()
    VAR UserPermission =
    LOOKUPVALUE(SecurityTable[Permissiontype], SecurityTable[Email], CurrentUser)
    VAR CurrentUserID =
    LOOKUPVALUE(SecurityTable[UserID], SecurityTable[Email], CurrentUser)
    VAR DistinctUsersInContext = CALCULATE(DISTINCTCOUNT(factHours[UserID]), ALLSELECTED(factHours))

    RETURN
    IF (
    UserPermission = "All",
    TRUE(),
    IF (
    DistinctUsersInContext = 1,
    factHours[UserID] = CurrentUserID,
    TRUE()
    )
    )
    ***********************************************************************

    If the above information helps you, please give us a Kudos and marked the Accept as a solution.

    Best Regards,
    Community Support Team _ C Srikanth.

v-csrikanth's avatar
v-csrikanth
Icon for Community Support rankCommunity Support
1 year ago

Hi ray_codex 

It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

Best Regards,
Community Support Team _ C Srikanth.