web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Excel to Word Template format output as currency

(0) ShareShare
ReportReport
Posted on by 266

I've created a flow that populates a Word doc. template with data from Excel.  Everything works great except the output of some of the fields needs to be as currency type.  In Excel, they have the currency format and displayed as $45.10, when it gets to the Word doc. it's displayed as 45.1.  I've read several threads and tried the Compose then Number Format; have tried expressions such as add(items('Apply_to_each')['MILAGE COST'],variables('InvoiceItemsArray')), as well as other, but just can't make it work.  FYI- I'm a novice when it comes to Power Automate.  It could also be it not in the correct position/line-up of my Flow.  Below is a snippet of what's working without trying to convert it to currency.  

12.png

I have the same question (0)
  • ChristianAbata Profile Picture
    8,949 Most Valuable Professional on at
    Re: Excel to Word Template format output as currency

    hi @Mike44  try using this acction before append your array. Then use the output in your array.

     

    curren.png

  • Mike44 Profile Picture
    266 on at
    Re: Excel to Word Template format output as currency

    I appreciate the help.  There are no options for Excel output.  Any other suggestions?

    5.PNG

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 535 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 348 Moderator

#3
developerAJ Profile Picture

developerAJ 262

Last 30 days Overall leaderboard