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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Push Excel Data to SQL...
Power Automate - Building Flows
Answered

Push Excel Data to SQL Server - Error - inner exception: We couldn't convert to Number.

(0) ShareShare
ReportReport
Posted on by TesDA 611

I trying to push data to sql server from excel. I'm getting a convert to number error although I'm not trying to convert anything to a number... There are no numbers in this export. Anyone know what Im doing wrong? Ive included a snapshot of the flow and the error.

 

I have an excel doc with the following columns:

AccountGUID

End Customer

Segment

Account

AccountGUID

 

In SQL Server I have:

End Customer or Department (maps to End Customer)

Segment (maps to segment)

Account (maps to account)

OneView Account (maps to AccountGuid)

ID (autoincrement rows/ primary key)

Flow Issue - sql to excel 12-13-19.png

Flow Issue - sql to excel 12-13-19 - 2.png

I have the same question (0)
  • Verified answer
    v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Push Excel Data to SQL Server - Error - inner exception: We couldn't convert to Number.

     

    Hi @TesDA ,

     

    I think the content of the configuration you configured in the Row Id field is problematic.

    As far as I know, the Row id needs to be a field of type number, and the GUID you are using is not the expected type.

     

    Whether you set the identifier column in the SQL table, the Update row action requires the row id to update the specified row.

     

    If you have set a similar id column, you need to filter the rows by the relationship between the column in the Excel table and the column in the SQL table.

     

    Configure Get rows and Filter Query to get the eligible rows and update it.

     

    Best Regards,

  • TesDA Profile Picture
    TesDA 611 on at
    Re: Push Excel Data to SQL Server - Error - inner exception: We couldn't convert to Number.

    For anyone checking this for help with their flow configuration: 

     

    I had an auto-incrementing primary key, which did not have a connection with the excel table.  I had to delete the auto-incrementing key and making the AccountGUID the primary key.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 691 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 431 Moderator

#3
developerAJ Profile Picture

developerAJ 266

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans