Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

google sheet get rows exceeds grid limits

(0) ShareShare
ReportReport
Posted on by 2

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?

  • Renan5D Profile Picture
    2 on at
    Re: google sheet get rows exceeds grid limits

    Resolvido para min, gratidão

  • PotterMother Profile Picture
    3 on at
    Re: google sheet get rows exceeds grid limits

    This is the correct way to do it! Thanks a lot!

     
  • Ciurik Profile Picture
    3 on at
    THanks!

    Yes, indeed, that is the solution.
    I had this problem trying to insert row.
    Added an empty column at the begining - didn't work.
    Added an empty column at the end - it worked.
    Thanks!
    Ended one hour of cruel unsuccess.

  • chrismrea Profile Picture
    5 on at
    Re: google sheet get rows exceeds grid limits

    confirming that adding the empty column resolved this issue for me

  • jackewans Profile Picture
    20 on at
    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.

  • stevesanda Profile Picture
    3 on at
    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...

  • suhailalistream Profile Picture
    2 on at
    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.

  • v-xida-msft Profile Picture
    on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492