Answered

How do I access attachments through inputs in Excel Power Automate flow?

(1) Share

Report

Posted on by JD-03091828-0

Hi friends!

I am building a power automate flow within an Excel workbook. In this flow, I want a user to automatically to send information in a selected row to a compensation partner for their action. This includes four inputs in the trigger for the compensation partner email (email input) and 3 file inputs for supporting documentation. I've put a screenshot of the trigger below:

My intent from here is to send a email with a Microsoft Forms link to the compensation partner with the buyout document attachments attached for their review/action, and then have the row in Excel update once the forms response is submitted. I know how to set this up. What I am unclear on is how do I attach the files uploaded in the trigger to the email? They are not saved in OneDrive or Sharepoint (to my knowledge) and all of the tutorials give great instructions on that...but what are the steps to obtain the files uploaded in the trigger and then attach these files to an email in power automate? Thanks in advance for your help!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

MarkRahn 1,351 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi @JD-03091828-0,

For your file inputs from the trigger, they are probably internally named "file", "file_1", and "file_2".

I created a flow with a manual trigger to work with the file inputs.

I then added a "Send an email (V2)" Action and set it up as follows:

To get the file name, the syntax is:

triggerBody()['file']['name']

To get the contents, the syntax is:

triggerBody()['file']['contentBytes']

You enter that as Dynamic Content like this:

I found this video from Reza Dorrani pretty useful based on what you are doing:

https://www.youtube.com/watch?v=JCvuixuu1Yo&t=710s

Though he is not doing exactly the same thing with the files being inputs - it might give you some other ideas. He updates a column in the spreadsheet when the email is sent. He also pulls attachments from a SharePoint list based on a lookup to an Order Number column.

Hopefully this helps you out and gets you moving forward.

This community is supported by individuals freely devoting their time to answer questions and provide support. They do it to let you know you are not alone. This is a community.

If someone has been able to answer your questions or solve your problem, please click Does this answer your question. This will help others who have the same question find a solution quickly via the forum search.

If someone was able to provide you with more information that moved you closer to a solution, throw them a Like. It might make their day. 😊

Thanks
-Mark

Was this reply helpful? Yes No
JD-03091828-0 75 on at

Like (0)

Report
Copy link

Link copied!

This logic worked - thank you! Just had to put the question marks into the expression.

Was this reply helpful? Yes No
trice602 16,164 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Great answer @MarkRahn

Was this reply helpful? Yes No