Help: Send email remainder to specific groups of people on sharepoint list combination

Occasional Contributor

Hi! I'm new to power automate.

 

Aim: To create a workflow that is able to send reminder XXX days before deadline to specific groups of people based on the different criteria combination.

 

I'm getting stuck on creating a workflow to be able to send email remainder automatically to specific groups of people based on the different criteria combination selected on the sharepoint list.

 

I have already created a flow in a way where once a specific combination on sharepoint list is selected, it will send email to the specific groups of people to kickstart the work.

 

Help needed: on creating the flow to send reminder back XXX days before deadline to these group of people that the deadline for completion is close.

 

1. How my sharepoint list currently looks like

Bessie1335_1-1670220998819.png

 

2. Power Automate workflow for sending email to specific group of people to kickstart work

Bessie1335_0-1670220960658.png

 

Thank you!

Bessie

5 Replies

@Bessie1335 

 

Create a new scheduled cload flow, which runs once a day.
That get's all items and check the date. If date is within X number of days send email :)

 

Screenshot 2022-12-05 103229.png

@NicolasKheirallah 

 

I have tried and gotten the email message below

Bessie1335_0-1670310331959.png

This is the flow that I have created based on your suggestion. Target is to send email reminder to specific group of people 7 days before the dateline indicated in sharepoint list hence I have included the expression of addDays(utcNow(),7,'yyyy-MM-dd').

 

Bessie1335_1-1670310441178.png

Bessie1335_2-1670310528380.png

 

You don't need pararell Apply for each. Just have one and have the condition come after one and other :)

Error you're getting is because you have probably choosen the wrong field in the second send email. It's from the wrong loop :)
Your filter query doesn' have a closing apostrophe after the expression.