Skip to main content

Notifications

Community site session details

Community site session details

Session Id : iTjcatNUWX7kzkrbkUIZ1u
Power Automate - Building Flows
Unanswered

Attaching specific worksheets or rows from excel to an email

Like (0) ShareShare
ReportReport
Posted on 21 Jul 2021 10:51:07 by 22

Hi! 

 

I'm trying to attach parts of an excel file to an email and I'm not sure how to approach it. The reason for dividing it up is to send different pieces of information to different people. The file consist of one sheet (main) with all info and then separate sheets based on the value of a column in the main sheet. It is these separate sheets I want sent out to different people. 

 

There are two "ways" for me to divide up this information, one is to attach the different sheets of the excel file to different emails, the other is to attach specific rows, based on column values in the main sheet, from the excel file to different emails. I would prefer if I could use the column from the main sheet to divide the information, but I'm open to all ways to go about it. I have tried using the Get tables function and this allows me to get different parts of the excel file but I haven't figured out to attach the table as a file, sending it out in the body of the email as a HTML table is unfortunately not an option. 

 

Does anyone have any idea on how I can approach it? Would be very happy for any input as I'm a bit stuck and not really sure how to proceed onwards. 

 

Best regards,

Elin

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 212 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 208 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 182

Overall leaderboard
Loading started