Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Unable to create new column // problem with base64 image length

(0) ShareShare
ReportReport
Posted on by

Hello,

I'm having problems completing the build of an app from another developer.

 

The app has a rich text editor, which sends to a dataverse table the htlm text and, if there is an image, the base64 code for it.

When the RichTextEditor .HtmlText is greater than 100000, the Patch function fails.

aorro933_0-1695209830745.png

I had thought about creating a new column with document format, but I am not allowed to create or edit columns. Can anyone give me an idea?

 

Another idea is to somehow create the images in sharepoint and get the url of this to save it in the dataverse column.

 

Thank you very much

 

 

 

  • aorro933 Profile Picture
    aorro933 on at
    Re: Unable to create new column // problem with base64 image length

    There was already a Document column in the dataverse table. So, sending the text to that column it's working perfectly. 

  • aorro933 Profile Picture
    aorro933 on at
    Re: Unable to create new column // problem with base64 image length

    Thanks for the replies. 

     

    The issue is relate to the text length:

    "body": {

        "error": {

          "code": "0x80044331",

          "message": "A validation error occurred.  The length of the 'notetext' attribute of the 'annotation' entity exceeded the maximum allowed length of '100000'.",

    Here the column setting:

    aorro933_0-1695228372415.png

     

     

     

  • FLMike Profile Picture
    FLMike 31,242 on at
    Re: Unable to create new column // problem with base64 image length

    We can also add error handling to validate if there is more information, but the Monitor will probably tell us right away.

  • FLMike Profile Picture
    FLMike 31,242 on at
    Re: Unable to create new column // problem with base64 image length

    Hello,


    Can you do the below steps and see if we can get a better error/information from the Patch

     

    Step 1. Close your App (stop it running)
    Step 2. Click the Stethoscope in the Top Right
    Step 3. On the bottom click Open Monitor
    Step 4. Once Monitor is running go back and run your app
    Step 5. Cause your issue to happen
    Step 6. Close the app
    Step 7. Go to the Monitor and Filter (top right) based on Error, or key word. Find the error line and look at the information Monitor has for why it failed.

     

    This should give us better information in the Response part of the error output
    Cheers
    If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • aorro933 Profile Picture
    aorro933 on at
    Re: Unable to create new column // problem with base64 image length

    Hi, 

     

    The error is "Error when using the Patch function: The requested operation is invalid."

     

    I counted the number of characters sent in RichTextEditor .HtmlText , and when it is less than 100000 the error does not appear.

     

    Thanks.

  • FLMike Profile Picture
    FLMike 31,242 on at
    Re: Unable to create new column // problem with base64 image length

    Hi,

     

    Can you share the error please

  • aorro933 Profile Picture
    aorro933 on at
    Re: Unable to create new column // problem with base64 image length

    Hi, 

     

    The limit size of the column was the first that I checked and it's set to 1073741823, much more than the  htlm text size. ¿Could be a limitation of the Patch function?

     

    Thank you. 

  • FLMike Profile Picture
    FLMike 31,242 on at
    Re: Unable to create new column // problem with base64 image length

    Hello,

     

    Just curious what is the size limit in Dataverse and column type? I know you can't change it, just curious to make sure no other weird issue.

     

    Personally myself, yes I prefer to store either in blob storage or SharePoint
    Cheers
    If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey and put the link in Dataverse. That being said, I do not know the security concerns around the data, how you would need to secure it in SharePoint / Blob storage, so the basis is sound. Just the devil is in the details.

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics