Hi Community,
I am working with Power Automate to automate a process where I need to extract information from an Excel spreadsheet and then populate that data into a Word template. The Word template has insert Plain text content controls to get the Excel cell. Afterward, I generate a document for each record and send it as an attachment in an email to the respective employee.
The issue I've encountered is with cells in Excel formatted as currency (e.g., "HKD 10,000") and percentages (e.g., "20%"). However, when these values are populated into the Word document, their formatting is lost: the currency is reduced to a number without the currency symbol (e.g., "10,000"), and the percentage changes from "20%" to "0.2". The cells format could not be change because there are many currency symbols.
The cells are shown as this:

But the Word document like this:

They should be shown as: 25%, 120%, 145%, HKD10,000
My flow is:



Does anyone know how to keep the Excel currency and percentage formatting intact when filling a Word template?