Answered

Attachment file or image column

(2) Share

Report

Posted on by gates78

Good evening everyone,

I have experienced a little issue when creating attachment column in Dataverse, automatically it turns Read only column. So, I couldn't patch updates to this attachment column knowing that patch function go through without any error.

I created edit form including many items from the Dataverse table + attachment field. All new data are submitted as updates to the row in Dataverse except the attachment.

Security role is Administrator. I am the owner of my environment. Also, I am member in a new role with permissions of read, write .... append on all Dataverse table + Annotation permission as well.

Please help.

Thank you.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Michael E. Gernaey 53,928 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @gates78

Please share what you have (don't simply explain it) as we need to validate your configuration, table, expressions, you name it.

Also for attachments are notes etc enabled?

Was this reply helpful? Yes No
gates78 16 on at

Like (0)

Report
Copy link

Link copied!

Yes, the notes / attachments are enabled on this dataverse table. the issue is , I am not able to edit the column Attachments because it is read only as follow:

Was this reply helpful? Yes No
Verified answer

SwatiSTW 807 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Your issue is because Dataverse's Attachment column is stored in the Annotation table, which is a system table that stores file attachments separately from the main record. This results in the attachment field appearing as read-only in Power Apps, preventing direct updates using the Patch() function.

Further, your security role should include Create, Read, Write, Delete, Append, and Append To permissions on the Annotation table.

Since the Patch() function does not work with attachments, you should use a PowerApps Form to handle file uploads.

Other way round is using Power Automate to upload the file and link it to your record. You may call the Dataverse API to create an Annotation record and link it to your row.

Was this reply helpful? Yes No
Verified answer

Michael E. Gernaey 53,928 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @gates78

If you want to update an Image / File Column you can in fact use Patch.

But you will need to get the content (whether its the image, or its the file). The best and easiest way to do this is to use the Attachment control, to add the image you want to store (or file).

Then grab the Content and Filename from the Attachment Control, NOT to submit it from the Control.

So essentially you end up with something like this

Attachment Control called MyAttachments and I'll just assume you have 1

Patch(MyTable, Defaults(MyTable), { MyAttachmentColumn: { FileName: First(MyAttachments.Attachments).Name, Value: First(MyAttachments.Attachments).Value } } );

Now you can do it without the Control but it does make it easier. Again same for if its a picture but you could be using the Camera Control for instance to grab the data from.

But as the previous poster stated Attachments is different beast (as actual "notes attachments")

Was this reply helpful? Yes No