cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TesDA
Level: Powered On

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

TesDA
Level: Powered On

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.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,728)