Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

How to use the OOTB Attachments Tables in Dataverse

(0) ShareShare
ReportReport
Posted on by 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 )

 

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

 

  • Drew Poggemann Profile Picture
    Drew Poggemann 9,278 on at
    Re: How to use the OOTB Attachments Tables in Dataverse

    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-Dataverse-table/td-p/1226502 

  • Verified answer
    Mira Ghaly Profile Picture
    Mira Ghaly 11,409 on at
    Re: How to use the OOTB Attachments Tables in Dataverse

    @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-canvas-app-and-power-automate-saving-attachments-part-2/

     

    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-in-cds-and-send-as-email/

     

    Hope this could sort out the confusion a little bit!

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics