Sharepoint list to email, including specific date range

[JosephYates92]

Hello!

I have a situation where employees utilize a Microsoft Form that I currently have a flow populating to a Microsoft/Sharepoint list.
I would like to take responses from the past week and have them emailed on a recurring basis to our supervisor team.

I've played around with this a bit and succeeded in getting the email to go out, but it ended up blank. I'm having trouble getting the email to go out and contain the data (either in HTML or attachment).

Ideally, this can be HTML table or an Excel attachment.
My apologies, I changed the flow around some in testing and don't have my original. I did try a couple different combos, including the following

[AnthonyAmador · Accepted solution]

Hi @JosephYates92 

You can use the action "Create HTML Table" and attach it to the email. For example, I have this list. 

The flow should look like this. 

And this is the email that I received. 

Now to filter the items and get only the ones created in the last week you can use this Filter Query in the "Get items" action. 

Created ge 'formatDateTime(addDays(utcNow(),-7),'yyyy-MM-dd')'

Should look like this. 

Hope this helps. 

Kind regards. 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.