cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
schuess3
Kudo Kingpin
Kudo Kingpin

How to use the OOTB Attachments Tables in Dataverse

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 )

 

TableAttachments.png

*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

 

ActivityMimeAttachment.png

*Figure 3 - ActivityMimeAttachment

 

Activityfileattachment.png

*Figure 4 - ActivityFileAttachment

 

Notestable.png

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

 

Table References

 

Related Posts

Add attachments to your Common Data Service entities 

Flow saves attachments inconsistently to Dataverse 

 

Summary

  1. 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?
  2. Should I be using the Note or Annotations Table instead?
  3. Any help is much appreciated.

 

@Pstork1 @faustocapellanj @RezaDorrani @R3dKap @mdevaney 

#PowerAddicts #PowerAppsCC #FlowNauts #LessCodeMorePower

 

Thanks

schuess

 

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User II
Dual Super User II

@schuess3 

If you need to add attachments directly to a Table (which is not defined as Activity) you should use the Notes and choose IsDocument = Yes.

 

If you need to add attachments to a Table (Defined as Activity) like Email, you need to use the attachments Table.

This blog article explains how to add attachment to email:https://onlinemgblog.wordpress.com/2021/03/24/save-and-retrieve-dataverse-email-attachments-in-a-can...

 

File Attachments are used for column types of type Image or File, This blog article explains about file attachments https://onlinemgblog.wordpress.com/2020/08/14/power-automate-get-attachment-from-a-file-field-type-i...

 

Hope this could sort out the confusion a little bit!

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

2 REPLIES 2
Mira_Ghaly
Dual Super User II
Dual Super User II

@schuess3 

If you need to add attachments directly to a Table (which is not defined as Activity) you should use the Notes and choose IsDocument = Yes.

 

If you need to add attachments to a Table (Defined as Activity) like Email, you need to use the attachments Table.

This blog article explains how to add attachment to email:https://onlinemgblog.wordpress.com/2021/03/24/save-and-retrieve-dataverse-email-attachments-in-a-can...

 

File Attachments are used for column types of type Image or File, This blog article explains about file attachments https://onlinemgblog.wordpress.com/2020/08/14/power-automate-get-attachment-from-a-file-field-type-i...

 

Hope this could sort out the confusion a little bit!

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
dpoggemann
Super User
Super User

Hi @schuess3 ,

 

Check out the following post and reply for working with attachments in your canvas app.  https://powerusers.microsoft.com/t5/Building-Power-Apps/Attachments-field-in-Canvas-app-for-Datavers... 

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,679)