Forum Discussion
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?
2 Replies
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):
https://support.encodian.com/hc/en-gb/articles/360020648597-Expression-Results-and-Formatting#h_01J4HN722RSVFWS4MNJZ3N3HTC
There's a https://support.encodian.com/hc/en-gb/community/topics/18049574288796-Template-Design community forum where the Encodian support team helps fix your templates.
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.
