Others

How to Automatically Email a Sender When a SharePoint Item Is Created

Elise Williams Oct 21, 2026 868 views

Question details

The user needs to set up an automated email confirmation to notify a customer or sender immediately after they submit a new item into a SharePoint ticketing list.

How to Automatically Email a Sender When a SharePoint Item Is Created

Product: SharePoint and Power Automate
Device & OS: not provided
Scenario: Managing a SharePoint ticketing system where automated communication is required to confirm that a user's request or list item has been successfully received.
Observed behavior: The user wants to configure a workflow that triggers an automatic email populated with dynamic content corresponding to the newly created list item.

Before you start

Ensure you have list management permissions for your SharePoint site and an active Microsoft 365 license that includes Power Automate capabilities.

Solution 1Recommended

Configure a Power Automate Flow from SharePoint

Use the built-in Power Automate integration within your SharePoint list to quickly set up a flow that triggers an email whenever a new list item is generated.

Power Automate provides standard templates designed specifically for SharePoint list triggers. By using dynamic content, you can automatically extract the sender's email address and specific item details to personalize the confirmation message.

Access Power Automate Integration

Open your target SharePoint list in your web browser. On the top command bar, click on 'Integrate', hover over 'Power Automate', and select 'Create a flow'.

Select the Appropriate Template

A panel will appear on the right side of the screen. Look for and select the template named 'Send a customized email when a new SharePoint list item is added'.

Verify Connections

Confirm that your account has valid connections to both SharePoint and Office 365 Outlook (or your designated email provider), then click 'Continue'.

Configure the Email Recipient

In the flow editor, expand the 'Send an email' action card. Click inside the 'To' field and use the dynamic content menu to select the 'Created By Email' field or the specific column where your customer's email is stored.

Customize the Email Message

Fill out the 'Subject' and 'Body' fields using plain text combined with dynamic values from the SharePoint item (like 'Title' or 'ID'). Once finished, click 'Save' and run a manual test by adding a new item to your list.

Configure a Power Automate Flow from SharePoint

Tip: If you are managing a ticketing system for external users who aren't authenticated in your organization, make sure your SharePoint list contains a mandatory text column for their 'Email Address' and map the 'To' field to that specific column instead of 'Created By'.

Free Microsoft Office alternative

Boost Your Productivity with WPS Office

While complex automated workflows require specialized tools like SharePoint and Power Automate, managing the actual document data, reports, and ticketing spreadsheets doesn't have to be expensive. WPS Office is a powerful, lightweight alternative to Microsoft Office that covers all your daily document needs without heavy subscription fees.

1. Download the Installer: Visit the official WPS website and download the free version suited for your operating system.
2. Install WPS Office: Run the setup file and follow the brief on-screen instructions to complete the installation.
3. Open Your Spreadsheets: Launch WPS Office and directly open your exported list data or standard Office files to begin working immediately.

Seamlessly compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Easily track and manage tabular ticketing data as an alternative to complex online lists.Lightweight architecture ensures lightning-fast startup even on older devices.Familiar tabbed user interface allows for immediate adoption with zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Can I CC or BCC other team members in the automated email?

Yes. In the Power Automate 'Send an email' action card, click 'Show advanced options'. You can manually type email addresses or insert dynamic content into the CC or BCC fields, separating multiple addresses with semicolons.

Why is the 'Created By Email' dynamic value missing in my flow?

This usually happens if the SharePoint list settings allow anonymous submissions or if the column isn't configured to track creator data. Ensure 'Created By' is visible in your list, or use a custom 'Email' column built into your SharePoint form.

Does this automated workflow require a premium Power Automate license?

No. Triggering a flow from a SharePoint list creation and sending an email via Office 365 Outlook uses standard connectors, which are included in most base Microsoft 365 enterprise or business subscriptions.

Office Quick Solutions