Help with "Move rows from a Google Sheet to a SQL DB" template

[mjsmartins]

Hi,

I'm trying to use the "Move rows from a Google Sheet to a SQL DB" template, but when I choose the fields from the spreasheet in the dynamic content, into the insert row, an error rises:

"This output is an array. A foreach cannot be nested inside of another foreach.

Any clues how to solve this?

thanks

[v-yamao-msft · Accepted solution]

Hi mjsmartins,

Please try to start the flow from blank without using the template.

You could configure the flow with the trigger “Recurrence”, then the action “Google sheet – Get rows”, then the action “SQL – Insert row”.

When you configure the action “Insert row” with the dynamic content from the spreadsheet, an Apply to each will be added automatically and you won’t get the error message.

Please try it on your side to see if it will work for you.

Best regards,
Mabel Mao

[mjsmartins]

Hi Mabel,

 IT worked! Thanks for the fast reply.

Using this template was a kind of desperate measure because of another more complex flow I'm working in, and had a similar problem. I'll try to solve the flow with this steps. if I can´t solved it, can I ask you help again?

Regards

Mário

[mjsmartins]

Hi Mabel,

I just can't solve the problem with the real flow I'm working in. The flow seem's easy, it should take a Json from a REST service, parse it, and in the second level of that json take the project records and insert them into an SQL Server Database. Problem is that I can´t reach the project level to get the fields, or we I some how can, the error message is "

This output is an array. A foreach cannot be nested inside of another foreach"

Can you help me?

[Dev_Nikhil]

Hi @v-yamao-msft

is there any Other way besides create a Flow From blank/Mannualy, Because i have tried both, However, in every case i am not able to get the Data from the Google Sheets it Continuously throws error of Bad Gateway or Row Limit Exceedes etc 

It would be really helpfull if you can Provide some Idea about solving these, I am  really stucked into it from last 2 days and i am desperetly need this Functionality because there is no other way or  approach that can Fullfill my Requirement.

Thanks in Advance