cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pkorbellu
Regular Visitor

Upload Excel Data into SQL Table using Power Automate Flow

Hi Everyone,

 

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

pkorbellu_0-1661868256739.png

 

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

pkorbellu_1-1661868510575.png

 

 

Can anybody help me tackle this error?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Srini84
Helper II
Helper II

Hi @pkorbellu 

 

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

Please close this thread by marking as solution

 

Thanks

View solution in original post

5 REPLIES 5
Srini84
Helper II
Helper II

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
Regular Visitor

Hi @Srini84 

 

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

Srini84
Helper II
Helper II

@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
Regular Visitor

@Srini84 

 

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

Can help me with alternate solution?

Srini84
Helper II
Helper II

Hi @pkorbellu 

 

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

Please close this thread by marking as solution

 

Thanks

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,005)