I want to make an export of contacts (portal contacts) and which content level they have attached to it. However, I cannot find what table the content levels are stored with the link to the portal contact.
The contact table and the content access level table are in a many-to-many relationship.
Unable to find this relationship in the view editor.
Content access levels for contacts can be retrieved through Power Automate Flow and exported to a CSV file.
The flow is below.
Step1:Initializes an array to store the contact and its content access level data stored as an object.
Step2:Retrieves the fullname and emailaddress1 fields for all contact records and the adx_description field for the associated content access level entity.
Step3:Append each object containing the contact and associated content entity level data to the array.
If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more. If you have further questions, please feel free to contact me . Best Regards, Dengliang Li
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.