Export to Excel with child record

(0) Share

Report

Posted on by Dy365Fan

Hello

Is there an easy way for an Excel export for contacts and their associated data (related data comma separated)? Specifically, I'm looking for contacts and the associated web roles.

The Export should be like the following example:

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Bipin D365 28,985 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

OOB it can not be possible.

You can create new custom field in your Contact entity and write workflow/plugin to append/remove web role name in your custom field as in when web role is associated and diassociated from contact.

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

Hi Dy365Fan,

There is no OOB way to do this. If you are familiar with python, you could send REST request to contacts and loop their web role. Finally, export them to excel.

You can also create a flow in Power automate to do this:

1. List all contact records and web roles.

2. Initialize an Array type variable

3. Loop contact records and loop current contact record's web roles to add them to array variable.

4. Add a row in the excel with current contact record's fullname and all web roles.

5. Clear array variable.

Result:

Was this reply helpful? Yes No
Dy365Fan on at

Like (0)

Report
Copy link

Link copied!

Thank you Steve Zhao, this work good for me.

Was this reply helpful? Yes No