Insert row from Google Sheet to MSSQL

[fatmanmclone90]

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

[v-yamao-msft]

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