Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Word Template and excel template extraction

(0) ShareShare
ReportReport
Posted on by 55

Hi Everyone,

First of all thank you for the time taken of reading my questions.

I have two questions.

1. I am looking into setting up word templates. After figuring out how to get the dynamics data into my template and making sure that it is able that tables auto expand (depending on the amount of relating records) I was trying to get into some graphs that visualize the seen data. Does anyone have a tip how I can visualize my data (using Dynamics 365 xml) in a chart within word?

2. When you are on a specific record entity. For example account A you have not the ability to set up excel templates (as on standard it is only possible on views) I thought via workbench tool I would be able to add this feature to a single record aswell but without result so far. Does anyone know how to add the function/feature excel templates to a form (form of e.g. a single account record).

Thanks again for reading my message.

Have a good day!

Kind regards,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Word Template and excel template extraction

    1. For the first one, I believe that you should use an Excel template.

    2. Excel templates are made to make meaning of more than one record.

    Ruskin

    Apps4Rent

  • Suggested answer
    Henry J. Profile Picture
    Henry J. 5,237 on at
    RE: Word Template and excel template extraction

    Hello,

    1. For Word Templates, I'm not aware of a way to render a chart, unless you integrate an image that already exists.
    Have you checked out Excel Templates to integrate charts? 

    If your data model is a bit complex (i.e. would want to display the chart based on a child entity records), you could also consider creating reports
    You can either create new reports with a wizard or you can create completely custom reports that allow much richer rendering options.
    Reports can then be exported to Word or PDF formats (among others).

    2.  Excel Templates are indeed only available on list of records, as they don't necessarily make sense on a single record (your Excel file would have one row).
    I'm not aware of a way to achieve that in a supported manner, as the RenderTemplate API isn't documented.
    Custom reports could be a viable alternative.

    Henry

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans