Power Platform Community Forum Thread Details

Flow to select and send onedrive file as an attachment in email

Hello Experts!

Is it possible to get a specific file saved in OneDrive and send it as an attachment via email (based on an item from SP list)?

I have a first flow that creates a PDF letter and saves it in my OneDrive and I would like to create a second flow that runs and send an email to a specific person included in the SharePoint list with the PDF letter as an attachment.

I have a choice column in my SP List with the values "Sent", "Pending" and "To be sent". Once the column is marked as "To be sent" my second flow will run. The trigger is "When an item is created or modified". Now I am trying to find a way where I can select a specific letter from my OneDrive based on the item selected in the trigger and attach it in the email.

I tried by saving the "Id" generated when I created the PDF file from the first flow in the "Title" column from the SharePoint list in order to use this code in my second flow to know which letter to select, but it did not work.

I am using this approach because I noticed that after I saved a PDF in my SharePoint list "attachment", I got an error when opening (see image below).

I really appreciate any guidance on how to create a rule to identify which PDF file to be selected from the OneDrive and attach it in the email. I was thinking of creating a rule that looks for a specific file name in the OneDrive but has not been able to achieve it. 🙂