PowerApps is a global product. You can build and use apps in many different languages and regions.
Both while building and running apps, the text displayed by PowerApps has been translated into a variety of languages. You will see menu items, dialog boxes, ribbon tabs, and other text in your native language. Typing in and displaying dates and numbers is also adapted for your particular language and region. For example, some regions of the world use "." as a decimal separator while others use ",".
When using the native studio or a native player, the language used is provided by the host operating system. For Windows, this can be controlled under "All Settings" and then "Time & language" settings. Windows also allows you to specify the characters to use for the decimal separator, overriding the language setting.
When using the web experiences, the language used is provided by the browser. Most browser default to the host operating system's setting with some also providing a way to set the language manually.
The authoring environment adapts to the language setting of the author. The app itself is stored in a language agnostic manner, so that authors using different languages can edit the same app.
Most elements in formula are always in English:
As the authoring experience is localized, control and other object names will appear in the native language of the author. In Spanish, some of the control names appear as:
When you insert one of these into your app, their name will default to English. This is done for consistency with the control property names and the rest of the formula. For example, Casilla listed above is inserted as Checkbox1.
After a control is inserted, you can change the name to whatever you like. While selected, the far left hand side of the "Content" ribbon displays the name of the control. Selecting this name drops down a text box where you can edit the name:
If you like, here you can rename the control to Casilla1. The red squiggly, in this case displayed by a browser, is because the name is not a Spanish word and is of no concern.
You can use whatever names you like for:
Some separators and operators will shift based on the decimal separator of the author's language:
|Author's language decimal separator||PowerApps decimal separator||PowerApps list separator||PowerApps chaining operator|
|. (period)||. (period)||, (comma)||; (semi-colon)|
|, (comma)||, (comma)||; (semi-colon)||;; (double semi-colon)|
The change in the PowerApps list separator is consistent with that happens to the Excel list separator. It impacts:
For example, consider the following formula in "en-US":
In a language where "," is used for the decimal separator, this will appear in the authoring experience as:
Note that the property selection operator . in Slider1.Value is always the same, no matter what the decimal separator is.
Internally the formula does not change, all that changes is how it is displayed and edited by the author. Two different authors using two different languages can view and edit the same formula, with each seeing the appropriate separators and operators for their language.
The app you create can adapt to different languages, providing a great user experience for your users around the world.
The Language function returns the language tag of the current user. For example, this function returns "en-GB" for users in Great Britain and "de-DE" for users in Germany.
Among other things, you can use Language to display translated text for your users. Your app can include a table of translated values in your app:
And then use a formula such as the following to pull translated strings from the table:
Be aware that translated strings in other languages could be significantly longer than they are in your language. In many cases, the labels and other elements that display the strings in your user interface will need to be wider to accommodate.
For more information, see the documentation for the Language function.
Numbers, dates, and times are written in different formats in different parts of the world. The meaning of commas, decimals, and the order of month, date, and year vary from location to location.
The Text function formats numbers and dates using the language setting of the user.
Text requires a format string to know how you want to format the number or date. This format string can take one of two forms:
The "[$-en-US]" on the front of the custom format string tells Text in which language to interpret the custom format string. This is inserted for you and defaults to your authoring language. Normally you will not need to change this. It is useful when authors from different languages are editing the same app.
The third argument to Text specifies which language to use for the result of the function. The default is the language setting of the current user.
For more information, see the documentation for the Text function.
There are four functions for reading numbers, dates, and times provided by the user:
If you have used Excel, all of these functions are combined in the single Value function. They are broken out here since PowerApps has separate types for date/time values and numbers.
All of these functions have the same arguments:
Among other things, use these functions to provide a Dropdown control with a list of choices.