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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Default Locale

(0) ShareShare
ReportReport
Posted on by 234

My language seems to be set to UK English everywhere, in Windows, in Office, in Chrome and Edge, in SharePoint, etc all OK

Power Automate Format Number returns $0.00 where I want £0.00

I can go through and change the locale on all my Formated Numbers but I don't really want to do that. Is it possible to default the locale for Formated Numbers to my system default locale or is that too much to ask?

Thank you for your help.

Guy

Categories:
I have the same question (0)
  • ChristianAbata Profile Picture
    8,951 Most Valuable Professional on at

    hi @GuyBoswell did you have configured like this?

     

    engb.png

  • Guy Boswell Profile Picture
    234 on at

    Hi @ChristianAbata 

    I could go through all my format number statements and set the local to en-GB, that does work.

    But I don't want to!

    I have told my computer I am working in the UK.  Do I really have to go through and tell each variable that I am working in the UK?  Can't that be my default?

    What happens if I want to share the flow with somebody who uses a different currency?  It should automatically work for them in their own prefered currency format, without me having to duplicate the whole system and edit all the format numbers in the duplicate with a different locale.

    SharePoint, PowerApps, Excel, Outlook, etc all seem to be quite happy to take it as read that I am in the UK - is Power Automate not able to do the same?

    Thank you for your help,

    Guy

  • ChristianAbata Profile Picture
    8,951 Most Valuable Professional on at

    See the think is that some actions that are using convertions needs to know what is going to be the converted resulta. So as you said in the time PA is not able to convert somethig by using your pc config or Outlook or other Platform. 

  • Suggested answer
    NsL Coder Profile Picture
    475 Super User 2025 Season 2 on at
    Power Automate "exists" in the "cloud", not your local computer, so it is not affect by your local computer setting.
     
    If you simply "output" the dynamic content of a "number", it will only show the number: 11111.11
     
    If you want it to look "good", you will need to do the formating specific for what you want to do, as Power Auotmate does not know if 11111.11 is a currency or just a decimal number. It doesn't know if you want $11,111.11 or 11,111.11 or Â£11,111.111
     
    That said, what you want to "globally set" is not available on power automate. The easy thing to do instead of using the "format number" action for each number you want to display is to use the formatNumber() expression.
     
    Say you want to send an email that shows 5 numbers in currency of UK format, you don't need 5 format number actions, just in the send email action, instead of directly adding the dynamic content for the 5 numbers, use formatNumber(the_1st_number, 'C', 'en-GB')
    formatNumber(the_2nd_number, 'C', 'en-GB')
    formatNumber(the_3rd_number, 'C', 'en-GB')
    formatNumber(the_4th_number, 'C', 'en-GB')
    formatNumber(the_5th_number, 'C', 'en-GB')

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

Forum hierarchy changes are complete!

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

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard