Log Auto-Reply Events to SharePoint (pt.2)

Hi there,

This is a continuation of my previous project where I triggered auto reply mail from outlook to the sender's mailbox when certain conditions are satisfied using Power Automate.

In this project, I will be logging my auto-reply events to a SharePoint site.

• Navigate to your SharePoint site and create a new list named "Email Auto-Reply Logs", (You can name your list any name that's okay for you).

• Add the following columns:

1. Sender Email (Single line of text)
2. Subject (Single line of text)
3. Received Time (Date and Time)
4. Reply Sent (Yes/No)

This list will serve as a centralized log for all auto-reply events, making it easy for tracking and auditing.

• Next is that you will update Your Power Automate Flow, the flow called "Email Automate" which was created in the previous post.

Enhance your existing flow to include a step that logs each auto-reply event to the SharePoint list:

1. After the "Send an email (V2)" action, add a new step: "Create item" in SharePoint.
2. Configure the action:

• Site Address: Your SharePoint site URL.
• List Name: "Email Auto-Reply Logs".
• Sender Email: Use dynamic content to insert the sender's email.
• Subject: Use dynamic content to insert the email subject.
• Received Time: Use dynamic content to insert the received time.
• Reply Sent: Set to "Yes".

This enhancement ensures that every auto-reply is recorded, providing a clear audit trail.

• Test and Validate

1. Send a test email to your Outlook inbox.
2. Verify that:

• The auto-reply is sent successfully.
• A new entry is created in the SharePoint list with accurate details.

Thank you.