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

google sheet get rows exceeds grid limits

I'm querying a google sheet with only 100 rows of data but 32 columns and I'm getting the following error:

 

Range (PINBasedExtract!AG2:AG) exceeds grid limits. Max rows: 1000, max columns: 32 clientRequestId: 79a87ed2-23e4-4582-9f79-c1423491390c

 

I can't reduce the number of columns. Is there a way around this limitation?

5 REPLIES 5
Community Support Team
Community Support Team

Re: google sheet get rows exceeds grid limits

Hi @suhailalistream,

 

Could you please share a screenshor of your flow's configuration?

 

The error message told that you are specifying a range that is larger than that the sheet (grid) currently is, please check if you have specified a range is larger than that within current sheet (grid). You could consider take a try to expand the columns wihtin your Google Sheet.

 

More details about the limitations of Google Sheet, please check the following article:

Google Sheet limits

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
suhailalistream
Level: Power Up

Re: google sheet get rows exceeds grid limits

 

The google sheet is not beyond the limits described in the google limits document. I've simplified my flow below to show the error and that it can be easily replicated:

googlelimit.jpg

 

Here's the last column of the google sheet:last column of google sheet.png

 

 

Another service is creating and populating the google sheet and that same process when it has a smaller number of columns the google sheet get rows action is able to read the google sheet just fine. I've tried with just a dozen rows and a little over 1K rows with the same error so the number of rows isn't the issue.

Highlighted
stevesanda
Level: Powered On

Re: google sheet get rows exceeds grid limits

Did this ever get resolved? I have the same issue with creating a new data source. My sheet has 27 columns and only 2 rows of data (I reduced the total number of rows to 200, which made no difference). This small amount of cells is not exceeding the limits...

jackewans
Level: Power Up

Re: google sheet get rows exceeds grid limits

Have just experienced this with one of my flows - I believe the issue is that the process is trying to create a "__PowerAppsId__" column and can't do that within the specified range (if you have entered header values into all columns on your sheet). 

 

The solution is simply to create a new, empty column which the process will then populate automatically.

chrismrea
Level: Power Up

Re: google sheet get rows exceeds grid limits

confirming that adding the empty column resolved this issue for me

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: 179 members 4,611 guests
Please welcome our newest community members: