cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ben_SIPP
New Member

Automate: How to set up a weekly report that - Extracts Rows from Excel Spreadsheet within Date-range then emails an embedded table/report.

Hello!

 

I am trying to set up a manually triggered flow that

  1. - button pressed
  2. - extracts rows created in Excel Spreadsheet within last 168 hours (7 Days)
  3. - presents the rows as table
  4. - either directly transposed into an email (preferred) or an attached document to an email
  5. - email to be sent to multiple but specific people.

 

Would someone be able to guide me through the triggers and connections. 

I have connected all the necessary channels, MSO365 & Outlook.

I have set up other flows, that auto-trigger by input into forms/single operation outcome.
I need to generate a simple report from existing data for a specific past date range.

Thank you in advance. 

0 REPLIES 0

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,035)