

If the custom format includes a period, for example, the language-format placeholder specifies whether the period is a decimal separator (ja-JP) or a thousands separator (es-ES). In this string, the language placeholder specifies the language in which to interpret the other placeholders. Power Apps supports a subset of the placeholders that Microsoft Excel does. A custom format, which comprises a string of placeholders that define, for example, whether numbers show a decimal separator and dates show the full name of the month, the month as an abbreviation, or the month as a number.

For dates and times, this approach is preferred as it automatically adjusts to each user's language and region. A predefined date/time format, which you specify by using the DateTimeFormat enumeration.The Text function formats a number or a date/time value based on one of these types of arguments: Converts any value and formats a number or date/time value to a string of text.
