Can anyone help with building a flow to connect Google Sheets to MSSSQL? I'm using the template "Move rows from a Google Sheet to a SQL DB", but I'm not sure how to configure.
So far I can get the insert to work if I specifynly a single column, but as soon as I try multiple it fails with "bad request". Picture of what I thought would be the correct configuration.
When testing I can see the data is being read from the Sheet, its the insert that is failing.
Thanks for sharing the detailed information.
In the action Insert row, please try to select corresponding dynamic content for each column.
I have made a test using the template you mentioned. Please check the following screenshot.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.