Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Sales updates!Learn about the key capabilities and features of Dynamics 365 Sales and experience some of the new features.
Download overview guide | Watch Sales video
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Hello all, and apologies if this is an old question but I cannot seem to get anywhere with it.
I have a document which basically comprises two parts. The first is an account summary section which is basically just account name and the content of the description field. The second part is what's causing my problem. We have a custom object called 'Advice' where we store all the consulting advice we have given our customers. This obviously will be different numbers of records for each customer. What we want is to pull the template for the account, have it fill the summary section (which it does) and then repeat the Advice section for each related record. What it actually does is simply return the most recent one.
Is there a way to do this? I'm happy to do it either in Dynamics template or Power Automate (or even write a macro if I have to, but I don't relish the thought of that!). What we definitely don't want to do is copy out the records to the customer document by hand, which feels like might be where we're going at the moment.
Thanks in advance for any help you can offer!
You can do this with a document template. Follow my images. Settings > Document Templates.
Then, new, I picked Word below, choose entities.
Next page pick your relationships, then download the word template.
Developer tab > XML mappings.
When done you upload this and it should be available on the main entity records(accounts in my images)
Thanks Mike for the prompt and thorough response. I really do appreciate it.
The problem is, that's exactly what I did. As I say it filled the main object stuff nicely, but only returned the first of the related records. Is there something I have to do in the Word document to make it read the full set?
Was it inside of a table? See this article, I've seen it done, by a friend, so I asked him if he did anything special.
Thanks Mike. I'm beginning to suspect there's no way to do what I want to do, which surprises me.
What I really want to do is have a separate page for each of the related records, producing a kind of catalogue of advice. Here's a screenshot of a very basic first draft of the page:
Obviously that's not a table in the sense you meant above (although that is very helpful for other use cases, so thank you for that!). I fear I'm going to have to do something hideous with scripts in Word to achieve what I need :-(.
Business Applications communities