I’ve noticed a recurring question in various online forums regarding the creation of Word documents using data from a SharePoint list. While one approach involves using Quick Parts, as I’ve previously discussed, this blog post aims to provide an alternative method using an HTML template.
In this process, we’ll start by generating an HTML file. Subsequently, we’ll leverage the ‘Convert File‘ action within Power Automate to transform this HTML file into the final document format, whether it be in Word or PDF.
In the example provided below, which serves as a template for an offer letter, I’ve modularized the HTML file into multiple components. This approach allows for the conditional application of employment clauses, enhancing the flexibility of the offer letter generation process.
My SharePoint list has a column “WFH” which if set to Yes will add a Remote working clause to the offer letter.