Create complex Word and Excel documents from templates in Microsoft Power Automate, Azure Logic Apps, and PowerApps

Anton Khritonenkov
Plumsail
Published in
2 min readJun 7, 2018

Plumsail Documents is a set of actions that allow you to generate various types of documents from templates, convert and process them in Microsoft Power Automate, Azure Logic Apps, and PowerApps.

It just got two new powerful actions for document generation:

Now, in addition to dozens of other useful actions, you can easily generate DOCX and XLSX documents from templates.

Easy and yet powerful syntax

We use the templating engine that utilizes a different approach than most other document creator solutions. It uses a minimal amount of syntax to make your work done.

For example, this is how template and result document look when you generate a table with names of employees:

And this is how it could look in other document generation solutions. That is not the way we want you to maintain your document templates:

Actually, you can do even more by doing less. You can create the whole table from a single tag like this:

Advanced scenarios

While being quite simple, the templating engine gives you a lot of power.

You can find all Word demos and Excel demos in the documentation. Below are just a couple of documents that you can easily generate from a template.

Sales invoice from Word template

You can find the detailed description of implementation in this article.

Reports with charts on multiple Excel worksheets

You can find the template for this example in the documentation.

Getting started

If you haven’t used Plumsail Actions yet, here are just two steps to get started:

--

--

Anton Khritonenkov
Plumsail

Co-founder of https://plumsail.com, Office 365 and SharePoint expert. Passionate about design and development of easy to use, convenient and flexible products.