Send email with excel data after filtering

[NicoleOuyang]

Hello, I have a folder to stored some raw data every day. Every monring,I need to open the latest raw data and do some filtering then get a new list. Then I need to send this list to a specific mail box. Could I set flow to make this process automatically? I want to send the new list in email body or as an excel attachment. Now I have set up the filtering criteria in Power BI and get the new list in it. However, I don't know how to trigger email to send this list. Thanks!

[v-alzhan-msft · Accepted solution]

Hi @NicoleOuyang ,

Could you please share a screenshot of your current flow?

You could add a "Create Html table"  action and send the table in the email as screenshot below:

 

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NicoleOuyang]

Hi~ Thank you so much for your reply. I am sorry that I don't create any flow currently. I only set up the criteria in PowerBI. And I am new to use this function, could you please share more about how to add a "Create Html table"? Besides, how can I sent the new list as an excel attachment in email? For example, I have an excel table with columns "City" and "Sales Volume". This table will be updated every morning. Now I want to send a list which "City"="Shanghai" as an excel attachment via Email automatically. Could I achieve this? Thanks!