Forum Discussion

Bayan000's avatar
Bayan000
Copper Contributor
Nov 03, 2023

Sending a PDF file as an email attachment with Power Automate corrupts attachment

I have followed this great tutorial for creating and sending digital certificates to event participants (https://techcommunity.microsoft.com/t5/educator-developer-blog/send-digital-certificate-to-eve...
Microsoft Flow
PowerApps
sharepoint
BufMobile's avatar
BufMobile
Copper Contributor
Dec 14, 2024

I had to switch to the old editor.

  1. Manually trigger the flow
  2. List Rows Present in a Table
    a. Excel file with table that has email address, other details needed for the email, and a list of the pdf file names generated with a cmd prompt "dir /b/o *.pdf > flist.txt" and pasted into the proper rows for the person indicated
  3. For Each (Value)
  4. Get Metadata Using Path
    Use the concat() function to put together the file path and the file name
  5. Get File Content using id from above
  6. Send an email (V2)
    a. Attachment File Name from Metadata
    b. File Content from Get File Content

This worked great.  Sent 62 emails with pdf file attachments of around 64K in about 90 seconds.

 

Resources