We had designed a power automate flow and used the List rows action step. While running the flow, we received the below error.
BadRequest. Http request failed as there is an error: 'Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600.'.
Screenshot of the error below.
This happens because there is a 100 MB Message Size limits in Power Automate.
Solution
- Allow Chunking if it is supported by the action.
- Or be specific with the columns you want to return. In the List Rows action, update the Select columns to limit the data returned.
- Temporarily update the data in the system so that fewer rows are returned. For example, if your condition is to return all the rows where field_name does not contain data. Say this is return 5000 rows. Now update few rows with some sample data and run the flow so that it returns limited rows for processing. (This is not recommended in production, but could be a quick fix if the client agrees to it).
Hope this helps!
