How can I automatically update and send an excel report using Power Automate?

Benjamin Water 20 Reputation points
2026-09-16T05:11:44.2666667+00:00

I have an Excel file stored in OneDrive that contains a list of technical support requests and their current statuses. I would like to use Power Automate to check the file every morning, filter the requests with a “Pending” status, and send a summary email to the assigned support engineers.

How can I configure the flow to read the Excel table, filter the relevant rows, and format them in an email? Additionally, how can I prevent the flow from sending an email when there are no pending requests?

Microsoft 365 and Office | Excel | For business | Windows
0 comments
Answer accepted by question author
Kien 1,625 Reputation points Independent Advisor
2026-09-16T05:15:01.9866667+00:00

Dear Benjamin Water,

Regarding your question about automatically update and send an excel report using Power Automate, please reach out to Microsoft Power Platform Community Forum Thread. The reason I am asking you to post a new discussion is that in the Questions – Microsoft Q&A, we have limited resources and very few resources to test this feature and in Microsoft Power Platform Community Forum Thread, you will get the most qualified group of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction. 

Thank you for your cooperation and understanding. Feel free to post your questions in the Microsoft community and we'll always do our best to help you! 

Have a good day! 

Was this answer helpful?

3 people found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.