Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.
The GETLABELTEXT function searches for a specific label to return a String value that represents the translation of the specified label in the specified language.
Syntax
GETLABELTEXT (label id, language)
Arguments
Label ID
label id: String or Label Id
The valid ID of one of the following label types:
- Electronic reporting (ER) label
- Microsoft Dynamics 365 Finance label
Usage notes
This argument can be defined only as a constant, by using one of the following supported patterns:
For ER labels:
@"GER_LABEL:<LABEL ID>""GER_LABEL:<LABEL ID>"
For Finance labels:
@"<LABEL ID>""<LABEL ID>"
Note
At design time, a validation error message is shown on the Formula designer page if no label can be found by using the provided label ID.
Language
language: String
A string that represents a language code.
Usage notes
This argument can be defined either as a text constant or as the path of a data source field that returns a String value.
Note
At design time, a validation error message is shown if no language code can be found by using the provided language argument when it has been defined as a text constant.
At runtime, the translation for the EN-US system language is returned for a specified label if no language code has been found by using the provided language argument.
Return values
String
The resulting text value.
Example 1: System label
The expressions GETLABELTEXT (@"SYS70894", "en-us") and GETLABELTEXT ("SYS70894", "en-us") return the English translation "Nothing to print" for the @SYS70894 application label.
Example 2: ER label
You start to edit an ER configuration that has been derived from the ISO20022 Credit transfer (DE) configuration, enter a new data source of the Calculated field type, and configure the expression GETLABELTEXT(@"GER_LABEL:VendorName", "de") for this data source. In this case, at runtime, the data source returns the German translation "Kreditorenname" for the @GER_LABEL:VendorName ER label that was initially configured in the base ISO20022 Credit transfer (DE) ER configuration.