web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate / do an...
Power Automate
Answered

Power Automate / do an Excel query and send the result with an new excel file via outlook

(0) ShareShare
ReportReport
Posted on by 2

hey, i‘m new here and also power automate is new for me. So this is the situation… i get a csv file every day. I open the file, set a few filters, copy the displayed data into a new Excel file and then send it with outlook. This process is repeated a few times until I have sent everyone the data they need. I would now like to automate this with Power Automate. How does this work?

Categories:
I have the same question (0)
  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @Rayk3008 ,

     

    You could try:

    1\List all rows in Excel table

    2\Use the filter action to filter rows

    3\Use the create CSV table to convert the array to CSV string

    4\Send an Email

    vbofengmsft_0-1667439195219.png

     

     

    If you want to send multiple users with different filters, you can repeat steps 2-4 multiple times.

     

    Best Regards,

    Bof

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 251 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 239

#3
Expiscornovus Profile Picture

Expiscornovus 220 Most Valuable Professional

Last 30 days Overall leaderboard