web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get row in excel Limit
Power Automate
Unanswered

Get row in excel Limit

(0) ShareShare
ReportReport
Posted on by 27

I have a flow that has to get many values from one row in Excel to populate a word document.

 

I get this error message:

 

The dynamic schema response from API 'excelonlinebusiness' operation 'GetTable' is too large, only schemas with at most '1024' properties are supported.

 

Any workarounds to be able to get more values. Thinking in the line of spliting the data into two separate rows and read both rows. Would that be possible?

Categories:
I have the same question (0)
  • TYL Profile Picture
    1,091 Super User 2024 Season 2 on at

    Do you only need one row of the table? Or the whole table? From what I read in your post, a Get a Row action would fit more I think.

  • JensaM Profile Picture
    27 on at

    Thank you for your answer!

     

    I am not trying to get rows from a table but rather trying to get one row containing around 1400 columns and there seems to be a limitation to the number of columns I can retrieve (max 1024).

     

    So I tried to split the table into two tables with around 700 columns per table and that worked.

     

    Thanks for youtr help!

     

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 248 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 207 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 101 Super User 2026 Season 1

Last 30 days Overall leaderboard