How to use the OOTB Attachments Tables in Dataverse

(0) Share

Report

Posted on by schuess3

353

Objective

I want to save and retrieve attachments to a Dataverse Table with the Attachments capability enabled. (fig.1).

(I hope to interact with them using Power Automate Flows and Canvas Apps, not Model-Driven Apps )

*Figure 1

Background

My understanding is that the attachments are stored in one of the OOTB Attachment Tables (fig.2)
My initial attempt was to use an "add a new row" action in flow to one of the attachments tables (fig.3, fig.4), but do not understand how to connect the saved file to the table with attachments enabled. (I know this is a Power Apps community, but I need to understand how Dataverse attachments tables work)
I am aware that if you add a OOTB Form control to a canvas app, for a table with the attachments property enabled, the form will expose a data card with an attachments control.

Attachment Entities.png

*Figure 2

*Figure 3 - ActivityMimeAttachment

*Figure 4 - ActivityFileAttachment

*Figure 5 - Notes (annotation) table/entity reference

Table References

Flow saves attachments inconsistently to Dataverse

Summary

Am I misunderstanding that if you store an attachment to a record on a table, using the table attachments property, it gets saved to one of the attachments tables?
Should I be using the Note or Annotations Table instead?
Any help is much appreciated.

#PowerAddicts #PowerAppsCC #FlowNauts #LessCodeMorePower

Thanks

schuess

Categories:

I have the same question (0)