Formats and Conversions in Power Automate

This article offers conversion tips and code templates for working with Xtract Universal.iQ in Microsoft Power Automate.

Leading Zeros

Data in SAP often uses leading zeros to maintain a 10 character convention, e.g., KUNNR, MATNR, COST_CTR, etc. Xtract Universal.iQ 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 Xtract Universal.iQ 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:

 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.

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

Related Topics

• Integrate a Service with Microsoft Power Automate
• Sync Copilot with SAP using Power Automate and Xtract Universal.iQ