Answered

PA one email only to all recipients when CAR due date

(1) Share

Report

Posted on by takoye

Hi,

I have a sharepoint list to monitor audit findings (CAR) due date. It contains the audit details, CAR number, due date, To (company email recipients) and Cc (company email recipients).

How to create a Power Automate to automatic send ONLY one email 7days before CAR due date to all recipients listed in To and CC columns by row?

Looking forward for a solution from forum. Thank you.

Takoye

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Haque 3,188 on at

Like (1)

Report
Copy link

Link copied!
Hi @takoye,

Trigger: Use the Recurrence trigger to run the flow daily (every day, specific time).

Get Items: Add the Get items action to retrieve all rows from your SharePoint list.

Filter Items by Due Date: Use a Filter array action to filter the items where the Due Date is exactly 7 days from the current date. Use an expression like: formatDateTime(addDays(utcNow(),7),'yyyy-MM-dd') to compare with the Due Date field (make sure to format the Due Date similarly).

Apply to Each: Loop through the filtered items, the items those are candidates to receive emails.

Shoot Email: Inside the loop, add a Send an email (V2) action:

To: Use the "To" column value from the current item.

Cc: Use the "Cc" column value from the current item.

Subject: Something like "Reminder: CAR Due Date Approaching for CAR #[CAR Number]"

Body: Include audit details, CAR number, due date, and any other relevant info.

Ensure Single Email per CAR: Since the flow runs daily, to avoid duplicate emails, you can add a flag Yes/No or true/false column in your SharePoint list called "ReminderSent". After sending the email, update the sharepoint list item to set "ReminderSent" to Yes/True. Modify the filter to only include items where "ReminderSent" is No/False.

Please let me know if this helps - please mark as answered and hit the like button if it resolves the issue.

Was this reply helpful? Yes No
takoye 22 on at

Like (1)

Report
Copy link

Link copied!

I tried flow iaw below chatgpt link but still cannot get it right. Appreciate assistance from this community.

https://chatgpt.com/share/699c361d-311c-8009-8c12-31fe7c3d3bbc

Was this reply helpful? Yes No