Dear community,
I am encountering this message error while trying to run a "Get a row" action on Power Automate.
Response context length '52477870' exceeds maximum value '52428800'.
You are trying to get a single row or all rows?
Get a Row only gets one row and by that i mean that there are too many columns in that specific row that the total size of the fetch is greater. there is no general limit on columns but rather the content of each column should not be more than the buffer size.
Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.
Thanks,
Rahber
Hello Rahber,
Thank you for your answer.
By "row is bigger than...", do you mean the row number? If so, which is the maximum number of rows which a table can contain in order to be able to use the action "Get a row" without getting any error?
I use "Get a row from Excel" (Business Excel) action to retrieve data from a table with around 200.000 rows and 14 columns. The Excel file is stored in a SharePoint document library and Power Automate access it.
This is because the row you are trying to get is bigger than the size Flow supports.
https://docs.microsoft.com/en-us/power-automate/limits-and-config
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-limits-and-config
Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.
Thanks,
Rahber
WarrenBelz
146,660
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,004
Most Valuable Professional