
I`m trying to get this information using power automate, I basically want to look for an email in a table and see what web roles that user have? What dataverse table holds that information?
I had to create a fetch XML using Advanced Find, then use that with the List Rows action
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" no-lock="false"><entity name="contact"><attribute name="entityimage_url"/><attribute name="fullname"/><order attribute="fullname" descending="false"/><attribute name="parentcustomerid"/><attribute name="telephone1"/><attribute name="emailaddress1"/><attribute name="contactid"/><filter type="and"><condition attribute="emailaddress1" operator="like" value="%var('useremail')%"/></filter><link-entity name="adx_webrole_contact" intersect="true" visible="false" from="contactid" to="contactid"><link-entity name="adx_webrole" alias="aj" from="adx_webroleid" to="adx_webroleid"><filter type="and"><condition attribute="adx_webroleid" operator="eq" value="{9fba7903-3b3f-ed11-9db0-0022489c2a38}" uiname="var('WebRoleName')" uitype="adx_webrole"/></filter></link-entity></link-entity></entity></fetch>