Upload Excel Data into SQL Table using Power Automate Flow

[pkorbellu]

Hi Everyone,

I am Creating a Flow to Upload Excel Data into SQL Table.

And, Once I run the Flow, it successfully uploads the Excel Data into SQL Table but I get an error as shown below....

Can anybody help me tackle this error?

[Srini84]

Hi @pkorbellu 

Can you check the excel that, is there any null values?

If you have null values then you might have to make those into 0 first then you may try

By seeing the error the value required is integer / Int64, So if there are any null values then it can't convert to Integer / Int64

[pkorbellu]

Hi @Srini84 

No, I don't have Null Values for the PartID Column.

[Srini84]

@pkorbellu 

Refer to https://powerusers.microsoft.com/t5/General-Power-Automate/The-runtime-value-quot-quot-to-be-convert... link, it has the similar issue, by passing an if condition it got resolved

Thanks,

Srini

[pkorbellu]

@Srini84 

It doesn't work for my instance....

Can help me with alternate solution?

[Srini84 · Accepted solution]

Hi @pkorbellu 

So, we tried making the PartID column to Number Format and it worked

Please close this thread by marking as solution

Thanks