Dynamic RLS

[Akshata_10]

Access = IF (USERPRINCIPALNAME() = LOOKUPVALUE(VW_ROLE_ACCESS_EMAIL[COMPANY EMAIL ID], VW_ROLE_ACCESS_EMAIL[Datafrom],"XYZ"
,VW_ROLE_ACCESS_EMAIL[Role],"Super User",
VW_ROLE_ACCESS_EMAIL[COMPANY EMAIL ID],USERPRINCIPALNAME()),
TRUE (),
OR(
OR(
OR(
OR(
[L1_EMAIL] = USERPRINCIPALNAME (),
[L2_EMAIL] = USERPRINCIPALNAME ()),
[L3_EMAIL] = USERPRINCIPALNAME ()),
[L4_EMAIL] = USERPRINCIPALNAME ()
))) 

Hi, This Dynamic RLS is throwing an error "The end of input was reached."

can I please get help with This.

Thanks

[Anonymous]

Hi @Akshata_10 ,

There seems to be some problem with your expression, there is an extra or function. Remove it to get the correct expression:

Access =
IF (
    USERPRINCIPALNAME ()
        = LOOKUPVALUE (
            VW_ROLE_ACCESS_EMAIL[COMPANY EMAIL ID],
            VW_ROLE_ACCESS_EMAIL[Datafrom], "XYZ",
            VW_ROLE_ACCESS_EMAIL[Role], "Super User",
            VW_ROLE_ACCESS_EMAIL[COMPANY EMAIL ID], USERPRINCIPALNAME ()
        ),
    TRUE (),
    OR (
        OR (
            OR ( [L1_EMAIL] = USERPRINCIPALNAME (), [L2_EMAIL] = USERPRINCIPALNAME () ),
            [L3_EMAIL] = USERPRINCIPALNAME ()
        ),
        [L4_EMAIL] = USERPRINCIPALNAME ()
    )
)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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