Forum Discussion
Phishdawg
Jan 22, 2025Brass Contributor
Generate Dollar Signs in Word Template
I am using a Word template to create and invoice with Power Automate.
I have two tables in the Word template. Two of the columns in each table should display numbers as
currency, specifically dollars.
The generated template only shows the content as numbers. Can I correct this, and if so how?
- AlexEncodianCopper Contributor
You could format string values in your JSON and populate the table with "$3.26" instead of 3.26 floats. But would require some manipulation of your data inside your flow.
You can use formatters in your template using Encodian as an alternative (allows you to format pretty much anything including currencies, dates, numbers, strings, etc):
Expression Results and Formatting – Currency Formatters
There's a Template Design community forum where the Encodian support team helps fix your templates.
- Charles_KenyonBronze Contributor
I am confident there is a method, but I know nothing about Power Automate. I added a tag for that to your question.
If I had to do it and was in a hurry, I would add ("in $") to the column heading.