Answered

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

(0) Share

Report

Posted on by 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

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-yamao-msft on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
mjsmartins 6 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
mjsmartins 6 on at

Like (0)

Report

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

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?

Was this reply helpful? Yes No
Dev_Nikhil 225 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No