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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Cannot write more byte...
Power Automate
Answered

Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600.

(1) ShareShare
ReportReport
Posted on by 184
Hi,
 
I am connecting to dataverse table to get values through power automate.
 
But I am encountering an issue 'Http request failed as there is an error: 'Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600.'.'
Issue
 
So please let me know if I am making any mistake here
 
Regards,
 
Sudheer
Categories:
I have the same question (0)
  • Suggested answer
    Tomac Profile Picture
    4,053 Moderator on at
    @NS-10041416-0 I'm assuming this table has a significant number of columns, yes?
     
    You'll need to use Select Columns to only get the columns you want to work with, as well as maybe filter a bit more to cut down on the number of rows returned or use Row Count to limit the number of rows you get back.
     
    The issue is the amount of data that's being returned by your query is too large for the Power Automate cache to store.
  • lbendlin Profile Picture
    8,690 Super User 2026 Season 1 on at
    100 MB is a hard limit for message size, for some reason.
     
  • NS-10041416-0 Profile Picture
    184 on at
    Hi @Tomac,
     
    Thanks for the response.
     
    Now I have specified the column in the List of Rows as below
     
     
    But I am getting an error as
    Regards,
     
    Sudheer
  • lbendlin Profile Picture
    8,690 Super User 2026 Season 1 on at
    Column titles should ideally not have spaces.  You need to encode that via _x0020_
  • Suggested answer
    Tomac Profile Picture
    4,053 Moderator on at
     
    As @lbendlin said, you'll need to encode the space character in your column name if it does indeed have a space, like so:
    Primary_x0020_Email
     
    If this resolves your issue, please remember to mark the helpful comment(s) as the answer.
  • NS-10041416-0 Profile Picture
    184 on at
    Hi,
     
    I have updated the same but no luck
     
    Regards,
     
    Sudheer
  • lbendlin Profile Picture
    8,690 Super User 2026 Season 1 on at
    The actual field name may be different from the display name.
  • Verified answer
    Michael E. Gernaey Profile Picture
    53,976 Moderator on at
     
    You would not put the name with encoding as its dataverse. The display name does not mean anything (at all) as it relates to accessing it.
     
    You need to go to the Table definition and grab the logical name, in all lower case.
     
    So go to the Table, click Advanced, grab the logical name, which is all lower case and place that there.
     
    The Label isn't what you ever use in dataverse, except in a Canvas app as it auto maps it to the proper logical name .
     
    its most likely something like
     
    prefix_primaryemail, where prefix is your solutions prefix.
     
    P.S. There are also ways to increase the max bytes so its greater than what you see in your error. Not saying you should but you can.
     
    Cheers

    If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

    Thank you!
    Sincerely, Michael Gernaey

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 711

#2
Vish WR Profile Picture

Vish WR 691

#3
Haque Profile Picture

Haque 525

Last 30 days Overall leaderboard