I have a user table with User emails assigned to ID. Subsequent tables linking User IDs to records. RLS is working great by matching USERPRINCIPALNAME() to email.
I am wanting to return no records if the USERPRINCIPALNAME() in not found in the user table emails.
Is this possible?
Solved! Go to Solution.
Based on the DAX condition you have setup, if the value returned by USERPRINCIPALNAME() doesn't exist in the table, the condition won't be satisfied which means no records will be returned and hence the user won't be able to see anything from that table.
In other words, what you are wanting works by default.
Based on the DAX condition you have setup, if the value returned by USERPRINCIPALNAME() doesn't exist in the table, the condition won't be satisfied which means no records will be returned and hence the user won't be able to see anything from that table.
In other words, what you are wanting works by default.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
32 | |
25 | |
19 | |
16 | |
15 |