Dynamics Community Forum Thread Details

Hello MohammedAfeef,

You can access attachment files in Dynamics 365 (Dataverse) from your Power Apps or Power Automate flows using a combination of Dataverse connectors and specific actions. Here's a breakdown of the methods and considerations:

Understanding Attachments in Dataverse:

Annotation Entity: Attachments are stored within the annotation entity in Dataverse.
DocumentBody Field: The actual file content is stored in the documentbody field of the annotation record.
MIME Type: The mimetype field indicates the file type (e.g., application/vnd.openxmlformats-officedocument.wordprocessingml.document for .docx).
Object ID: The objectid field links the annotation to the related record (e.g., a Contact, Account, or Case).

Accessing Attachments in Power Apps:

Add a Dataverse Data Source:
- In your Power App, add the Dataverse data source and select the annotations table.

Retrieve Attachments:
- Use the Filter() function to retrieve the attachments related to a specific record.
- Example:
- Filter(
Annotations,
objectid = ThisItem.Id // Replace ThisItem.Id with the ID of your record
- )

Display or Download Attachments:
- Display Images: If the attachment is an image, you can use an Image control and set its Image property to:
- "data:image/" & ThisItem.mimetype & ";base64," & ThisItem.documentbody
- Download Files: For other file types (like .docx), you'll need to use a combination of techniques:
  - Convert the documentbody (base64) to a binary format.
  - Use a custom connector or a service like Azure Blob Storage to facilitate the download.
  - Alternatively, you can create a flow that is triggered from the powerapp, that will send the email with the attachment.

Launch Function:
- The Launch function can be used to launch a URL. This can be used in combination with a cloud flow to download the file.

Accessing Attachments in Power Automate:

Dataverse Connector:
- Use the Dataverse connector's "List rows" action to retrieve annotation records.
- Filter the results based on the objectid and any other relevant criteria.

Get File Content:
- Use the "Get a row by ID" (Dataverse) action to retrieve the specific annotation record.
- The documentbody field will contain the base64-encoded file content.

Convert Base64 to Binary:
- Use the base64ToBinary() expression to convert the documentbody value to binary.

File Operations:
- Create a File: Use the appropriate connector (e.g., SharePoint, OneDrive, Azure Blob Storage) to create a file with the binary content.
- Send an Email: Use the "Send an email (V2)" (Outlook 365) or similar action to send the file as an attachment.
- Store in a Variable: You can store the binary content in a variable for further processing.

Example Power Automate Flow:

Trigger: (e.g., "When a row is added, modified or deleted")

List Rows (Dataverse):
- Entity Name: annotations
- Filter Rows: objectid eq '<record GUID>'

Apply to Each:
- For each annotation record:
  1. Get a row by ID (Dataverse):
    - Row ID: Annotation ID (from the "List rows" action_
  2. Compose:
    - Inputs: base64ToBinary(outputs('Get_a_row_by_ID')?['body/documentbody'])
  3. Create File (SharePoint/OneDrive/Email attachment):
    - File Name: Annotation Subject (from the "Get a row by ID" action) + file extension.
    - File Content: Output from the "Compose" action.

Important Considerations:

Permissions: Ensure that the Power App user or Power Automate flow has the necessary permissions to access the annotation entity.
File Size Limits: Be mindful of file size limits in Power Apps and Power Automate
Performance: Retrieving and processing large attachments can impact performance.
Security: Handle attachment data securely, especially if it contains sensitive information.
File Extensions: When creating files, ensure you add the correct file extension based on the mimetype.

By following these guidelines, you can successfully access and process attachment files from Dynamics 365 (Dataverse) in your Power Apps and Power Automate flows.

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more. If you have further questions, please feel free to contact me.

My response was crafted with AI assistance and tailored to provide detailed and actionable guidance for your Microsoft Dynamics 365 query.

Regards,

Daivat Vartak