Making a flow that sends an automated email with previous week's info

[MattConn]

Hi,

I have some experience making flows but I've never created one with this specific function.

I need to send out an automated email that gets items from a SharePoint list but only information from the last 7 days.

(Additional: If I could get it to only get items that are 'pending' from the last 7 days that would be even better!)

For context, the SharePoint page is used to track approvals so we want to know which are outstanding and update our team with these emails every week. Below is an image of the 'choice' column I created in my SharePoint list for approvals:

If I could automatically send the last 7 days of pending approvals on weekly emails that would be fantastic! Any help is appreciated.

Thanks!

[v-qiaqi-msft · Accepted solution]

Hi @MattConn,

Do you want to send email every week with the pending Items in the last 7 days?

Here is a simple demo, please check for reference:

addDays(utcNow('yyyy-MM-dd'),-7)

Here is the testing result.

[MattConn]

Thank you for this demo. Most of this appears to work. The only error I've noticed when debugging it is the filter query. Since sending the original post. I now need to include two options from that column. One for 'Pending' and another for 'Requested'. I haven't changed my SharePoint and for some reason it says status doesn't exist. Whenever I test and use that filter query, it says the below:

Am I doing something wrong?

[v-qiaqi-msft]

HI @MattConn,

In your scenario, you do not have the Satatus column but you have this Approval column, replace the Status with Approval column.

[MattConn]

Thank you Qi! This is working now! 🙂 So if I wanted to filter other options in my approval column in the future. How would I do that? What if I wanted to get 'pending' and 'requested' items? 

Also, is there a way to make this look nicer on the email and just have the words pending/requested rather than all this text?

[MattConn]

Hi Qi, I actually figured that first part out myself: 

I just need help getting rid of the unnecessary text in the above response so the email looks nicer and easier to read for the team. I may have done something incorrect at this step:

Thank you for your support!

[MattConn]

Hi Qi, I just need the text above to disappear so it only shows 'pending'. Once I've fixed that this flow is complete. 🙂 Thanks, Matt

[v-qiaqi-msft · Accepted solution]

Hi @MattConn,

Sorry, I should remind you of that at the very beginning.😅

First of all, make sure that your Approval is a Choice column.

Then the expression you set in the Filter query is correct, howeve, you should modify your item() function if your Approval column is Choice type:

item()?['Approval/Value']

[MattConn]

Thank you for all your help Qi. This flow is now up and running as intended! 😁