cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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

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?
Capture.PNG
thanks
 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
New Member

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

New Member

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?print.jpg

Highlighted
Advocate III
Advocate III

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 

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (4,173)