Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 44l9qvFnufgH/XStlewWtn
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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,089 Most Valuable Professional

Leaderboard
Loading started