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 : yOhfxs9ODgUxaIFu9fmv/o
Power Automate - Building Flows
Suggested answer

Default Locale

Like (0) ShareShare
ReportReport
Posted on 20 Jul 2020 14:56:49 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

I have the same question (0)
  • Suggested answer
    NsL Coder Profile Picture
    473 Super User 2025 Season 2 on 17 Feb 2025 at 05:24:44
    Default Locale
    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')
  • ChristianAbata Profile Picture
    8,949 Most Valuable Professional on 21 Jul 2020 at 12:10:23
    Re: Default Locale

    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. 

  • Guy Boswell Profile Picture
    234 on 21 Jul 2020 at 10:54:04
    Re: Default Locale

    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,949 Most Valuable Professional on 20 Jul 2020 at 18:21:54
    Re: Default Locale

    hi @GuyBoswell did you have configured like this?

     

    engb.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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 736 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 396 Moderator

#3
Power Apps 1919 Profile Picture

Power Apps 1919 339

Last 30 days Overall leaderboard
Loading complete