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

sak 20 Reputation points
2024-04-12T03:41:11.9633333+00:00

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.

User's image

SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
545 questions
0 comments
Accepted answer
  1. Emily Du-MSFT 43,511 Reputation points Microsoft Vendor
    2024-04-15T08:17:21.3866667+00:00

    Here are result:

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

    2.Create a flow as following pictures show.

    1

    2

    Result:

    3

    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.

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Du-MSFT 43,511 Reputation points Microsoft Vendor
    2024-04-12T09:47:29.98+00:00

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

    Here is an example:

    0

    1

    2

    3

    Result:

    4

    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.

    1 person found this answer helpful.
  2. sak 20 Reputation points
    2024-04-12T09:54:36.2766667+00:00

    (Deleted )

    0 comments