How to sent email with an Excel attachment filtered by "List rows present in a table"

Question

I am a beginner in Power Automate.

I want to make a cloud flow that filters an Excel file with "List rows present in a table" and sends the filter result as an email attachment.

I cannot make out what I should enter as the "Content - 1" of "Send an email (V2)".

I would appreciate it if someone could support me.

Answer 1

Here are result:

1.Create an excel file named result in the SharePoint document library.

2.Create a flow as following pictures show.

Result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

You only could send the filter excel table as html table in the email.

Here is an example:

Result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

(Deleted )