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
Hi @fatmanmclone90,
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.
Best regards,
Mabel Mao
User | Count |
---|---|
88 | |
40 | |
23 | |
20 | |
16 |
User | Count |
---|---|
130 | |
50 | |
48 | |
35 | |
26 |