Attachments missing in Dataverse table

[gumgih]

Hi Team,

I am creating flow to get the attachments from my Dataverse table using powerAutomate to patch it further with Azure DevOps, but while using "Download file or Image" connector, I'm receiving "No file attachment found for attribute : new_attachments" error message. could you please help me to know where the actual attachments sits for my Table. I read few blogs where they mentions "Attachements, are saved to the entity Annotations" but i didn't find that column for my Table.

[dpoggemann]

Hi @gumgih ,

If you have enabled Notes and Attachments on your Dataverse table then, yes, these are stored in the Annotations table and you will not see a column on your source table for this.  The Annotations table will have an ObjectId field on it which will actually contain your entity's unique ID. 

The following article discusses and has a link to the Annotation Table Reference as well.  https://docs.microsoft.com/en-us/powerapps/developer/data-platform/annotation-note-entity 

[Prakash4691]

Hi @gumgih ,

It looks like there are no record with attachment for new_attachments field and you are trying to retrieve those value using "Download file or Image" connector.

Make sure to add that field in the main form and upload file to that record then trigger power automate for that record it will run successfully.

I hope it answers your question. Kindly give kudo and accept it as solution.

Regards,

Prakash