cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mjsmartins
Level: Power Up

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
Community Support Team
Community Support Team

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
Community Support Team
Community Support Team

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

mjsmartins
Level: Power Up

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

mjsmartins
Level: Power Up

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

Dev_Nikhil
Level 8

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
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 66 members 3,492 guests
Please welcome our newest community members: