Unanswered

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

(0) Share

Report

Posted on by aorro933

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.

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Michael E. Gernaey 53,928 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
aorro933 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Michael E. Gernaey 53,928 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you share the error please

Was this reply helpful? Yes No
aorro933 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Michael E. Gernaey 53,928 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Michael E. Gernaey 53,928 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
aorro933 on at

Like (0)

Report
Copy link

Link copied!
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:

Was this reply helpful? Yes No
aorro933 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No