Answered

Dynamics 365 Joined Entity fields

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I'm building a flow connected to Dynamics 365 in which I want to list (via LIST RECORDS) all the closed opportunities from the Opportunity entity, and then email said as an HTML table.

All is working except for selecting my fields I want in the HTML table. When I try using the account field from opportunity, it will only give me the GUID linked to the actual account entity.

So I joined the accoun entity via the EXPAND line, yet I'm still not able to select any account entity field, only opportunity.

Fields listed in the picture are only from the Opportunity entity, when I research for Account fields, nothing shows up.

Any idea how to fix this? Is there something I'm doing wrong?

Thank you for you help.

All responses (22)

Answers (2)

abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: Dynamics 365 Joined Entity fields

Hi @Anonymous

Thanks for the update.

Could you please mark this as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search.

Thanks
Verified answer

Community Power Pla... on at

Like (1)

Report

Re: Dynamics 365 Joined Entity fields

Hello @abm,

I ended up following this solution https://2die4it.com/2019/02/07/schedule-daily-email-with-summary-of-opportunities-from-dynamics-365-ce-in-flow/ and it seems to work perfectly now.

Thank you for your help!
abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: Dynamics 365 Joined Entity fields

Hi @Anonymous

Please have a look at this post

https://powerusers.microsoft.com/t5/Building-Flows/Confused-about-CSV-table-output/td-p/70987

Let me know the results.

Thanks
Community Power Pla... on at

Like (0)

Report

Re: Dynamics 365 Joined Entity fields

Hello @abm

Still the same error unfortunately. Could this be because of the type of data?

Would it be possible to have headers from the opportunity entity and account entity at the same time?

Thank you for your help!
abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: Dynamics 365 Joined Entity fields

Hi,

That's strange. Try to delete the Create HTML table action. Save the flow. Add the same action step again and try it.

Thanks
Community Power Pla... on at

Like (1)

Report

Re: Dynamics 365 Joined Entity fields

Hello @abm ,

Here are the screenshots of the flow:
Test results:
We can see that there is some data getting out but somehow it's still not working.

Thank you again for your support in all of this, I appreciate it!
abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: Dynamics 365 Joined Entity fields

Hi @Anonymous

Append array looks ok. Check the flow step "Create HTML Table" set the Columns Automatic.

Thanks
Community Power Pla... on at

Like (0)

Report

Re: Dynamics 365 Joined Entity fields

Hello @abm ,

I can't seem to get this right unfortunately... I get this error message when I try to add the fax field (I added it in the expand query first)

Thank you for your help
abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: Dynamics 365 Joined Entity fields

Hi @Anonymous

This is what you need to do

Extend the Append Array step

For the above Fax mapping expression is as follows:
items('Apply_to_each')?['parentaccountid']?['fax']

Below is my test results:

Thanks
abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: Dynamics 365 Joined Entity fields

Hi @Anonymous

Try push the new values into the array. See my earlier screenshot how we mapped the name in Append Array step.

Thanks