Get row in excel Limit

(0) Share

Report

Posted on by JensaM

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:

General topics

I have the same question (0)

All responses (2)

Answers (0)

TYL 1,091 Super User 2024 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
JensaM 27 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No