web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power AUTOMATE IN DATA...
Power Automate
Unanswered

Power AUTOMATE IN DATAVERSE

(0) ShareShare
ReportReport
Posted on by

hey everyone

 

i need assistance with powerautomate 

 

i want to create a flow that send attachment to email

I have power portal that has form connected to nomination table , 

and attachment field that submit files to Note table once the information is submitted ,

 Note table is  a child table that is related to nomination table and their relationship is 

new_nominationform_Annotations , I want that attachment to be attached on approval as wellScreenshot 2024-02-19 124511.png

 

 

Categories:
  • Expiscornovus Profile Picture
    33,997 Most Valuable Professional on at

    Hi @swelihle,

     

    There should be an attachments array section in the Start and wait for an approval action which you can use. Make sure you convert the contents of the document to binary first before you attach it though, like mentioned in this thread:

    https://powerusers.microsoft.com/t5/General-Discussions/Need-help-how-to-retrieve-attachment-from-notes-dataverse-and/td-p/1889819

     

    Below is an example

    Btw, I also added a Filter Rows query (objecttypecode eq 'account') to avoid that the flow is also being triggered by the notes of the Approval step itself, that process also uses the notes table 😂

     

    1. Use the filename in the Attachments Name field

     

    triggerOutputs()?['body/filename']

     

     

    2. Use the documentbody in the Attachments content

     

    base64ToBinary(triggerOutputs()?['body/documentbody'])

     

     

    notes_organization.png

     

    The test result should look like the below 

     

    testresult_approvalattachments.png

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 445

#2
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 300

Last 30 days Overall leaderboard