Create a flow to send email at person in a list according to a date

[corinne37]

Hello

I’m a beginner in power automate, I need your help.

I have a list with a column person and a column date

I want to create a flow that send an email to the person 7 days before the date

I don’t know how to get the email of the person

*The condition is : addDays(utcNow(),-7)

[David_MA]

If your field name is Mail, look for the item in the dynamic content that contains Mail Email. For example, I have a people field named Contact. In the dynamic content, it contains all of these values from the people field:

I assume the first action after the recurrence is a Get items action. If so, I would use a filter query on the get items action instead of using a condition in your flow to get the items that meet your criteria. This will be more efficient, and your flow will run faster when the list gets large. Be sure to index the date column you are using.

Here is a good post on the web that shows you how to use filter queries: How to Use Power Automate Get Items Filter Query + 8 Examples - Enjoy SharePoint.

[royg · Accepted solution]

Your flow should work as is. You might want to compare the dates after formatting them (on both sides of your equation). Something like

formatDateTime(addDays(utcNow(),-7), 'yyyy-MM-dd') = formatDateTime(item()?['your date column'], 'yyyy-MM-dd')