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?
Solved! Go to Solution.
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
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
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!