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

Notifications

Announcements

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard