Active Directory - User properties

[OmeloP]

I've got a connection to our AD but I cannot find a table which lists the User property information. The User table only provides a list of user accounts. I am hoping to see the user email address and Location/Office fields because this will help me filter another set of data which lists users by email addresses only. 

Can someone help me find the correct data please?

[GilbertQ · Accepted solution]

Hi @OmeloP 

If you refer to my blog post below, you will be able to navigate all of the AD properties, you might need to try different area's to find the properties you are after.

Dynamic Row Level Security is easy with Active Directory Security Groups - Reporting/Analytics Made ...