Problem creating month column in SharePoint

[Joao3]

Hello, everyone.

First I want to say, I do not know if this is the proper site so I can publish this my question.

I need to create a calculated column that returns to me the month of each new item inserted in the list. Within the list are already separated by group. What I need is to create this column, But I can not, I do not know if it is the problem of the anvegador, because the sharepoint of the company is in Portugues, and I believe that the formula does not recognize this.

I'm using the standard formula, I create a column that references "Date and Time", and after that I create a column called Month, it is the calculated in which I use " =TEXT([StartDate], "mmmm")" but points to some syntax error that I do not know how to solve.

Can you help me, please?

I thank you!

[poweractivate · Accepted solution]

@Joao3 

Power Apps should support your scenario, here are some details.
From https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text

Global apps

The Text function is globally aware. For a wide array of languages, it knows how to properly write out dates, times, currencies, and numbers. To do its job, it needs two pieces of information:

• The language of the custom format: For makers, how should a custom format be interpreted? The separator characters (. and ,) have different meanings in different languages. If you specify a custom format, you can include a language placeholder or take the default value, which reflects the language to which your device is set. Even easier, you can use one of the predefined date/time formats, which are language agnostic.
• The language of the result: For users, in what language should the function result appear? Names of months and weekdays must be in the appropriate language for the user of the app, which you can specify by adding a third, optional argument to the Text function.

For both, you specify the language by using a language tag. To see the list of supported languages, type Text( 1234, "", ) in the formula bar or the Advanced tab of the right-hand pane, and then scroll through the list of locales suggested for the third argument.

---

So why is it not working in your case?

Try to check it with 

Language()

formula from the app defined almost anywhere in a mock label or somewhere. If the anvegador* (navigator/browser) and Host OS have the proper region configured, this will show in the result of above formula. Maybe checking with the above formula may help. If the above formula returns the wrong region, it could be hint that the anvegador* (navigator/browser) or the host OS is not set to the right region.

Please in next reply provide what does above formula Language() return in your case? Then we can check and see if we can better help you.

If it is returning the wrong language, you can try to do a quick shortcut fix, by forcing the right language in the Text function on the third argument of the Text function (see following link and also the details below for more info):

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text

Language placeholder

To specify the language of the custom format, use:

LANGUAGE PLACEHOLDER

Placeholder	Description
[$-LanguageTag]	LanguageTag is a language tag as returned from the Language function. It can specify just the language (such as [$-en] for English), or it can also specify the region (such as [$-en-GB] to further specify Great Britain).

The language placeholder can appear anywhere in the custom format but only once.

If you specify a custom format without a language placeholder and the format is ambiguous from a global standpoint, the language tag for your current language is inserted automatically.

[$-en-US] is assumed if this placeholder isn't present when your app is run.

 Note

In a future version, the syntax of this placeholder may change to avoid confusion with a similar, but different, placeholder that Excel supports.

Result language tag

The result of Text includes translated strings for months, weekdays, and AM/PM designations, as well as the appropriate group and decimal separators.

By default, Text uses the language of the user running the app. The Language function returns the language tag for the current user. You can override this default value by supplying a language tag for the third argument to Text.

Syntax

Text( NumberOrDateTime, DateTimeFormatEnum [, ResultLanguageTag ] )

• NumberOrDateTime - Required. The number or the date/time value to format.
• DateTimeFormat - Required. A member of the DateTimeFormat enumeration.
• ResultLanguageTag - Optional. The language tag to use for the result text. By default, the language of the current user is used.

Text( NumberOrDateTime, CustomFormat [, ResultLanguageTag ] )

• Number - Required. The number or the date/time value to format.
• CustomFormat - Required. One or more placeholders enclosed in double quotation marks.
• ResultLanguageTag - Optional. The language tag to use for the result text. By default, the language of the current user is used.

Text( AnyValue )

• AnyValue - Required. Value to convert to a text representation. A default format is used.

---

---

---

and for language tags see (only the strings as examples what a Language tag is - this is to be used for third argument in Text function)

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-language

 

Language tags

A language tag can be in one of three formats:

LANGUAGE TAGS

Return value	Description
"lg‑RE"	lg is the two character abbreviation for the language and RE is the two character abbreviation for the region. This is the most common return type. For example, "en-GB" is returned for Great Britain.
"lg"	lg is the two character abbreviation for the language. This is the format used when Power Apps has information about the language, but does not have information for the specific region.
"lg‑scrp‑RE"	lg is the two character abbreviation for the language, scrp is the four character abbreviation for the script, and RE is the two character abbreviation for the region.

Syntax

Language()

Examples

User's locale

It is assumed that the host operating system and/or browser are using the default locale for the location.

USER'S LOCALE

Formula	Location	Return Value
Language()	Lisbon, Portugal	"pt-PT"
Language()	Rio de Janeiro, Brazil	"pt-BR"
Language()	Atlanta, USA	"en-US"
Language()	Manchester, Great Britain	"en-GB"
Language()	Paris, France	"fr-FR"
Language()	Roseau, Dominica	"en"
Language()	Belgrade, Serbia	"sr-cyrl-RS" or "sr-latn-RS", depending on the user's system settings

---

* (anvegador, or the "browser" - P.S. we actually do not know very much Spanish / Portugese, we just happen to know that specific word anvegador usually means something like "navigator" or for computers, a contextual meaning would be "browser" in this case when translated from the base language to English)