{"id":1520,"date":"2021-11-19T15:57:56","date_gmt":"2021-11-19T15:57:56","guid":{"rendered":"https:\/\/365stack.in\/?p=1520"},"modified":"2022-01-12T14:26:37","modified_gmt":"2022-01-12T14:26:37","slug":"how-to-add-dynamic-attachments-in-power-automate-send-email-action","status":"publish","type":"post","link":"https:\/\/365stack.in\/index.php\/2021\/11\/19\/how-to-add-dynamic-attachments-in-power-automate-send-email-action\/","title":{"rendered":"How to add dynamic attachments in Send Email\/Approval Action"},"content":{"rendered":"\n

In some scenarios, we may need to add attachments while sending emails to businesses, Some times the attachment files will be dynamic and it will be changed based on users or scenarios.<\/p>\n\n\n\n

We may get the files from SharePoint, Onedrive, Azure, or any HTTP request, In all cases we can follow the below steps. In this example, we get the files from SharePoint.<\/p>\n\n\n\n

Declare an array variable to hold the file content in JSON format, get the required file reference from SharePoint.<\/p>\n\n\n\n

\"\"
Get file reference from the library<\/figcaption><\/figure><\/div>\n\n\n\n

Pass the output to Apply to each, get the file content by passing the current record identifier.<\/p>\n\n\n\n

\"\"
Get file content<\/figcaption><\/figure><\/div>\n\n\n\n

Apply to Each => Append the JSON to an array variable<\/p>\n\n\n\n

\"\"
Append to an array variable<\/figcaption><\/figure><\/div>\n\n\n\n

Outside apply to each => Pass the array variable to send email action.<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Approval<\/h4>\n\n\n\n

This works perfectly well for Email action, But if the attachments need to be added in an “Approval<\/strong>” action. The JSON for the array has to be formatted slightly different like below.<\/p>\n\n\n\n

\"\"
JSON Format<\/figcaption><\/figure><\/div>\n\n\n\n
{\n  \"Name\": \"@{items('Apply_to_each')?['DisplayName']}\",\n  \"content\": {\n    \"$content-type\": \"@{body('Get_attachment_content')['$content-type']}\",\n    \"$content\": \"@{body('Get_attachment_content')['$content']}\"\n  }\n}<\/code><\/pre>\n\n\n\n
Please post your queries in the comment section. Happy Building \ud83d\ude42 <\/p>\n","protected":false},"excerpt":{"rendered":"
In some scenarios, we may need to add attachments while sending emails to businesses, Some times the attachment files will be dynamic and it will be changed based on users or scenarios. We may get the files from SharePoint, Onedrive, Azure, or any HTTP request, In all cases we can follow the below steps. In this example, we get the […]<\/p>\n","protected":false},"author":2,"featured_media":1523,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[8,32,4],"tags":[46,9,10,30],"class_list":["post-1520","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-automate","category-power-platform","category-sharepoint","tag-microsoft-365","tag-powerapps","tag-powerautomate","tag-sharepoint"],"jetpack_publicize_connections":[],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-131.png?fit=1047%2C653&ssl=1?v=1637336922","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1435,"url":"https:\/\/365stack.in\/index.php\/2021\/09\/11\/import-data-from-excel-to-dataverse-sharepoint-list\/","url_meta":{"origin":1520,"position":0},"title":"Import Data from Excel to Dataverse\/SharePoint List using Power Automate","author":"Hemanthkumar Rajan","date":"September 11, 2021","format":false,"excerpt":"One of the most common requirements in any business use case is to read the excel from an external system via Email or direct upload by a user. In Power Platform it can be implemented in multiple ways. Data flows Dataflows are a great way to transform data and import\u2026","rel":"","context":"In "Dataverse"","block_context":{"text":"Dataverse","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/powerapps\/dataverse\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/09\/Screenshot-45.png?fit=1200%2C470&ssl=1%3Fv%3D1631363241&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1220,"url":"https:\/\/365stack.in\/index.php\/2021\/07\/05\/a-complete-guide-for-migration-to-power-platform-pre-development-analysis-part-1\/","url_meta":{"origin":1520,"position":1},"title":"A Complete Guide for Migration to Power Platform: Pre-Development Analysis – Part 1","author":"Hemanthkumar Rajan","date":"July 5, 2021","format":false,"excerpt":"If the application is going to be created from a new requirement, we can focus only on the Power Platform by analyzing the use cases of the requirement and a feasibility study should suffice for common scenarios like approval, functions, references, CRUD operations, integrations, performance, limitations has to be taken\u2026","rel":"","context":"In "Power Platform"","block_context":{"text":"Power Platform","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/"},"img":{"alt_text":"Pre Development Analysis","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/07\/Requirement-Anlaysis-scaled.jpeg?fit=1200%2C829&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1527,"url":"https:\/\/365stack.in\/index.php\/2021\/11\/21\/how-to-create-custom-attachment-control-in-powerapps\/","url_meta":{"origin":1520,"position":2},"title":"How to create custom attachment control in PowerApps","author":"Hemanthkumar Rajan","date":"November 21, 2021","format":false,"excerpt":"Attaching a file along with the form is a common requirement, By default PowerApps does not provide any attachment control. But if the SharePoint list is added as a datasource automatically the attachment control will be generated along with the controls. But if multiple attachment control has to be shown\u2026","rel":"","context":"In "Canvas Apps"","block_context":{"text":"Canvas Apps","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/powerapps\/canvas-apps\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-143.png?fit=1200%2C467&ssl=1%3Fv%3D1637483532&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2404,"url":"https:\/\/365stack.in\/index.php\/2022\/01\/06\/trigger-flow-when-a-folder-is-created-in-the-sharepoint-library\/","url_meta":{"origin":1520,"position":3},"title":"Trigger flow when a folder is created in the SharePoint library","author":"Hemanthkumar Rajan","date":"January 6, 2022","format":false,"excerpt":"There are many triggers available for SharePoint list and libraries but in some cases, the flow should be triggered only a folder is created or a file is created inside the library, there are no direct triggers available but with the help of conditions we can trigger the flow when\u2026","rel":"","context":"In "Power Automate"","block_context":{"text":"Power Automate","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/power-automate\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2022\/01\/Screenshot-714.png?fit=1043%2C763&ssl=1%3Fv%3D1641471039&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1636,"url":"https:\/\/365stack.in\/index.php\/2021\/11\/29\/how-to-add-rows-in-excel-online-using-power-automate\/","url_meta":{"origin":1520,"position":4},"title":"How to add rows in Excel online using Power Automate","author":"Hemanthkumar Rajan","date":"November 29, 2021","format":false,"excerpt":"Adding rows to an excel file or exporting the data in \".xlsx\" format, which can be sent to users or other applications as data feed can be a common scenario. In this example, we used the \"Excel online business\" connector to add rows to the excel file, Previously we already\u2026","rel":"","context":"In "Power Automate"","block_context":{"text":"Power Automate","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/power-automate\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2021\/11\/Screenshot-214.png?fit=997%2C551&ssl=1%3Fv%3D1637930822&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1456,"url":"https:\/\/365stack.in\/index.php\/2021\/09\/17\/powerapps-print-form-to-pdf\/","url_meta":{"origin":1520,"position":5},"title":"How to Print Scrollable Screen to PDF in PowerApps","author":"Hemanthkumar Rajan","date":"September 17, 2021","format":false,"excerpt":"One of the common requirements in any application is to print the data either to save the form as PDF or print the form. PowerApps provides Print() function to print the screen in a printable format, but the limitation is the screen height cannot be greater than 2164px. If a\u2026","rel":"","context":"In "Canvas Apps"","block_context":{"text":"Canvas Apps","link":"https:\/\/365stack.in\/index.php\/category\/power-platform\/powerapps\/canvas-apps\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/365stack.in\/wp-content\/uploads\/2020\/10\/background1.jpg?fit=1200%2C675&ssl=1%3Fv%3D1623349406&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts\/1520","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/comments?post=1520"}],"version-history":[{"count":4,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts\/1520\/revisions"}],"predecessor-version":[{"id":2431,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/posts\/1520\/revisions\/2431"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/media\/1523"}],"wp:attachment":[{"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/media?parent=1520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/categories?post=1520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/365stack.in\/index.php\/wp-json\/wp\/v2\/tags?post=1520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}