formatDateTime(addDays(utcNow(),30),'M/dd/yyyy')
⚠️If you've never added in this kind of filter before, here's how:
- Type in EndDate eq ''
- Click between the two 's you've typed, then click on Expression on the box to the left (a tab). Paste in the formula formatDateTime(addDays(utcNow(),30),'M/dd/yyyy'). Press "OK"
ℹ️ What is the formula doing? The formula is taking "utcNow" to identify "hey, what day is it?". Working our way out of the brackets, the next thing we're doing is identifying "okay - we now know what "today" is - what is 30 days from now?". Once we have that, we need to change the date into a format that SharePoint will understand.
⭐Step 3 - Everything else is honestly magic - add in a "Send an Email" action. Click in the "To" field and click on "Add Dynamic Content" from the bottom right hand side of the field. All the email addresses available from your list will be there! Click on ContractContact Email. You will see the email action automatically turn into an "Apply to each", which just means - hey, if we check Today + 30 and there's more than one contract with an End Date of that, we're going to email for each one.
⭐Step 4 - Type out your email body, and, you're done! And you can use variables from the rest of your Get Item options -- the "Apply to each" that automatically applied makes it so it will always know which contract to pull the information from.
In the end, we have something like this:
Let me know if you have any questions.
Cheers,
Rhia
