News and Announcements icon

Dynamics 365 CommunityForums Customer Service forum Contentlevels: export

Customer Service forum

Suggested answer

Contentlevels: export

(1) Share

Report

Report

Posted on by RobbertMeijer

36

Hi there,

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.

Regards,

Robbert

Categories:

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Dengliang Li Microsoft Employee on at

Like (0)

Report

Contentlevels: export

Hi,

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.

Expression：items('Apply_to_each')?['adx_ContactContentAccessLevel']?[0]?['adx_description']

Create a csv file using this 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

Helpful resources

News and Announcements

Just out! June 2024 Dynamics 365 Community Newsletter

Community forum and blog attachments are now available!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 284,877 Super User

#2

Martin Dráb 225,425 Super User

#3

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans