web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Issue with Decimal Sep...
Power Automate
Unanswered

Issue with Decimal Separator in Excel to PDF Conversion in Power Automate (One Drive Connector)

(0) ShareShare
ReportReport
Posted on by

Hello,

We are using the OneDrive - Convert file action in Power Automate to convert an Excel file to PDF. The conversion works correctly, but we have noticed an issue with numerical values.

In the original Excel file, numbers are formatted with a comma (",") as the decimal separator (e.g., "1.234,56" in Spanish format). However, after conversion to PDF, the decimal separator changes to a dot ("1,234.56"), which does not match the regional formatting of the Excel file.

We have already checked:


  • The regional settings in OneDrive (set to Spanish - Spain).

  • The Excel formatting before conversion (numbers correctly formatted with a comma).

  • Manually exporting the Excel file to PDF from Excel Online, which keeps the correct format


  •  

It seems that the Convert file action is applying an incorrect locale during conversion. Could you confirm if there is a way to specify the regional settings in this action or if there is a workaround to ensure the decimal separator remains consistent?

Thank you for your support.

Categories:
I have the same question (0)
  • KB-26030855-0 Profile Picture
    2 on at
    Having the exact same issue here. Setting the language and regional options for the user executing the flow does change the behavior.
     
    The XML call of the conversion action looks like this:
     
    {
      "type": "OpenApiConnection",
      "inputs": {
        "parameters": {
          "id": "@item()?['Id']",
          "type": "PDF"
        },
        "host": {
          "apiId": "/providers/Microsoft.PowerApps/apis/shared_onedriveforbusiness",
          "connection": "shared_onedriveforbusiness",
          "operationId": "ConvertFile"
        }
      }
    }
     
    I was unable to find documentation on this call. I was hoping to find additional parameters one could add, like "region": "DE-de" or similar. No luck so far.
     
    Any chance to fix this?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 840

#2
Valantis Profile Picture

Valantis 661

#3
Haque Profile Picture

Haque 589

Last 30 days Overall leaderboard