Skip to main content

Notifications

Announcements

No record found.

Customer Service forum
Suggested answer

Contentlevels: export

Posted on by 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:
  • Suggested answer
    Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    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

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans