HTML Table Designer for Dynamics 365 & Power Apps
An easier solution to format email and document templates with tables using data from Microsoft Dynamics 365 or Power Apps
Easily build and edit rich text templates for any entity and record.
Simplifies the process to include custom tables and apply aggregate functions.
Apply triggers to automatically run templates in Dynamics 365.
Demonstrating HTML Designer for Dynamics 365
Video Transcriptopen transcript close transcript
The benefits of this solution are that it enables you to create HTML design using information coming from Dynamics or fr…
The benefits of this solution are that it enables you to create HTML design using information coming from Dynamics or from the Common Data Service. It pulls field data from the database and puts it in a nice format, which is then presented in email designs or documents that you might send out as part of a report, that can get converted to a PDF if you need to.
For this video I am going to trigger this solution off an order, as an email going out from an order as a table of information on products. For this to work, we give you a HTML Design entity, which is made up of FetchXML query. We can help you design this, and we have a second video on how this works if you have FetchXML expertise in your organisation and you want to have a look at that.
Under the “Design” tab, you can see what the email would look like, based on the FetchXML query and the information that we will be pulling into the email. Under “Advanced Design”, elements such as colour and font can be customised. Under “HTML Attribute Mapping”, you can track where all the table fields are being mapped from. We’ve set up this HTML mapping area if you need to review that and this is covered in further detail in our second video.
Once all of that is in the system, we’ve then created in the background a workflow that once triggered will grab that information and put it in an email. When on the order record, you can see the products table displaying the order, and you can click the three dots option at the top ribbon, find the “Flow” option, click the relevant workflow and trigger the process of creating an email.
This trigger can be set to automatically run the flow, if you don’t want to start it manually, and this can be on any entity required.
After all that is done the workflow will run and effectively grab the HTML design, put it in the body of an email and send this out to the client. Refresh the page, and you will see the email will be under the timeline, which you can expand to view the email content.
The benefit of doing this, compared to just attaching a document to the email, is that recipients don’t have to click and load up the attachment as the information will be in the email. If this is a daily occurrence such as reports, timesheets, list of opportunitiess or activities, this would make it easier to just flick through the emails.
As mentioned before, it can also go into a document as packaged up information. It’s just a good option for when you want templates to make things easier.
Thanks for watching. If you’re interested in this solution, it is part of our Managed Service offering. We do have a second video which is regarding the FetchXML query and the HTML Attribute Mapping, so do watch it if you want any more detail on that.
Example Uses for HTML Table Designer
To send reports, quotes and other notifications, there is often a need to present data in a tabulated format. Using the default Dynamics 365 controls, these design options can prove restrictive, resulting in additional cost to create bespoke reports.
That's why Preact has developed this HTML TableDesigner solution to simplify the process for formatting templates with Dynamics 365 data and tables, and precisely define each layout. Combined with automation capabilities, this enables professional looking templates for timesheets, project summaries, service reports, job summaries and many other routine notifications to be easily delivered and managed.
How the HTML Designer Works
- Create a new HTML Design record where field mappings between HTML parameters and Dynamics / Dataverse fields are automatically created.
- The General tab will reference each fields that will be used and is shown in a FetchXML structure.
- Use the Design tab to set the template layout using rich text controls and apply these fields.
- Apply HTML controls and formatting, including colours, using the Advanced Design tab.
- Configure Attribute Mapping records for each field type including date / time, decimal and money formats. For example, using a decimal field type set aggregate functions to sum, average or count these values in the template.
Watch a detailed demonstration of the HTML TableDesigner to find out more.
How to Deploy the HTML Table Designer
HTML Table Designer Pricing
The HTML Designer for Dynamics 365 is one of many solutions that are available at no additional cost as part of Preact's Elevate 365 Managed Service. This can also be purchased using our Solutions 365 subscription from £8.25+VAT per user / month which provides full access to all the packaged products in Preact's Solutions Hub.
Further solutions which can be deployed using either of these subscriptions include:
Bank Account Validation
Drag & Drop Sub Grids
Editable Quick Forms
Price List Manager
Current Date Setter
Parent Visual Lookup
Contact us today to find out more and deploy the HTML Designer in your environment.