cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Get Rows from Google Sheets and insert in a SQL Table

Hello, 

 

I'm want to get rows from a Google Spreadsheet and insert in a SQL Table. It's 1k rows, but my flow gets just the first 256 rows. What's the problem? How can I handle that?

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Get Rows from Google Sheets and insert in a SQL Table

Hi thiagogouveiar,

 

I tried to reproduce your issue but it seems that I cannot get the sheets now:

Capture.PNG

 

I will try it later.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Anonymous
Not applicable

Re: Get Rows from Google Sheets and insert in a SQL Table

Hi  Mona,

 

Thanks. I appreciate your help. 

 

Follow bellow a screenshot of my spreadsheet. The last column __PowerAppsId__ stops in the 256th row and I don't know why or how to handle with this issue.

 

print.PNG

 

 

 

 

Highlighted
Anonymous
Not applicable

Re: Get Rows from Google Sheets and insert in a SQL Table

Can anyone help me?

Highlighted
Anonymous
Not applicable

Re: Get Rows from Google Sheets and insert in a SQL Table

The default number of rows is 256. This can be changed in advanced options in MS Flow, Google Sheets, get rows.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Users online (6,634)