Skip to content

Formats and Conversions in Power Automate

This article offers conversion tips and code templates for working with yunIO in Power Automate.

Leading Zeros

Data in SAP often uses leading zeros to maintain a 10 character convention, e.g., KUNNR, MATNR, COST_CTR, etc. yunIO also requires leading zeros for these parameters.

The following code adds leading zeros to a variable strValue:
concat(substring('0000000000', 0, sub(10,length(variables('strValue')))), variables('strValue'))

Date Conversion

When working with yunIO dates use the SAP format "yyyyMMdd".
The following code converts German ("dd.MM.yyyy") and US ("MM/dd/yyyy") dates to the SAP date format ("yyyyMMdd") for variable strDate:

Date Conversion
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
concat(
    substring(variables('strDate'), 6, 4),

    if(contains(variables('strDate'), '/'),
        concat(
            substring(variables('strDate'), 0, 2),
            substring(variables('strDate'), 3, 2)
            ),
        concat(
            substring(variables('strDate'), 3, 2),
            substring(variables('strDate'), 0, 2)
            )
        )
)

Syntax in Different Language Settings

The Power Apps coding syntax is dependent on the configured language settings. This impacts:

  • Arguments in function calls
  • Fields in a record
  • Records in a table

For more information, see Microsoft: Formula separators and chaining operator.

Author's language decimal separator Power Apps decimal separator Power Apps list separator Power Apps chaining operator
. (dot or period) . (dot or period) , (comma) ; (semi-colon)
, (comma) , (comma) ; (semi-colon) ;; (double semi-colon)

Example: the English ClearCollect(SAPData,yunIO_1.ReadCSKT()); becomes ClearCollect(SAPData;yunIO_1.ReadCSKT()) for German language users.

Last update: May 8, 2024