Power Automate: Set up an email notification for a new SharePoint row
With Power Automate you set up an automatic email notification for new SharePoint rows via the trigger 'When an item is created' from the SharePoint connector. Then link the 'Send an email (V2)' action from Outlook and use dynamic content from the trigger to show column values in the email. This way you immediately receive a notification when new data is added to the list, without manual checking.
In many BI environments it is important to be immediately informed when new data arrives. With Power Automate you can easily set up an automatic email notification that is sent as soon as a new row is added to a SharePoint list.
In many BI environments it is important to be immediately informed when new data arrives. With Power Automate you can easily set up an automatic email notification that is sent as soon as a new row is added to a SharePoint list. This article teaches you step by step how to set up this notification, so you can respond faster to new insights and data updates.
What you need
-
An existing SharePoint list to which new data is added
-
A Power Automate flow with access to the SharePoint connector
-
An email address to send the notification to
Step 1: Set up the trigger for a new SharePoint row
The first step is to set up the trigger that activates the flow as soon as a new row is added to your SharePoint list. This is essential for receiving real-time notifications.
Open the Power Automate portal and create a new automated flow. Choose “When an item is created” under the SharePoint connector as the trigger. Fill in the URL of your SharePoint site and select the correct list.
Step 2: Configure the email action
After the trigger, add an action to send an email. Choose the action “Send an email (V2)” from the Office 365 Outlook connector. Fill in the recipient’s email address, set a clear subject line, for example “New SharePoint row added”, and use dynamic content from the trigger to place relevant details in the email, such as the title or other column values of the new row.
Step 3: Test and activate the flow
Test your flow by adding a new row to the SharePoint list. Check whether the email is received correctly with the right information. If necessary, adjust the email content for more clarity or additional details. Once everything works, activate the flow so it continues to send automatic notifications.
Tips & common mistakes
-
Check the SharePoint list URL and name carefully to avoid errors in the trigger.
-
Make sure the email recipient is filled in correctly and that the email address is valid.
-
Use dynamic content to make the email personal and informative.
-
Always test the flow with a test item before taking it into production.
Example use case
A BI team uses a SharePoint list to collect feedback from users. With this flow, team members immediately receive an email notification when new feedback is added, so they can respond quickly and process the data in their reports.
Conclusion
With this simple but powerful Power Automate flow for an email notification for a new SharePoint row, you always stay informed of new data in your SharePoint lists. Set this up easily via the Power Automate portal and apply it directly in your daily BI work.
Our tip: Add a clear subject line to the email with a recognisable prefix, such as “Notification: new item in [list name]”. This makes the email immediately recognisable in the inbox and allows you to easily create an Outlook rule to automatically sort these notifications into a separate folder.
Frequently asked questions
How do I set up an email notification for a new SharePoint row with Power Automate?
Open the Power Automate portal and create a new automated flow. Choose 'When an item is created' from the SharePoint connector as the trigger. Fill in the SharePoint site URL and the list name. Then add the 'Send an email (V2)' action via the Office 365 Outlook connector. Fill in the recipient's email address, set a clear subject line and use dynamic content from the trigger to show relevant column values in the email. Test the flow by adding a new item to the list.
Can I customise the email notification with data from the SharePoint row?
Yes, in the email action you can use dynamic content from the SharePoint trigger. Each column from the SharePoint list is available as a dynamic field that you can insert in the subject line or message body. For example, you can include the name of the new item, the creation date or other field values directly in the email. This makes the notification informative and useful for the recipient without them having to navigate to SharePoint.
What common mistakes should I avoid with an email notification flow in Power Automate?
The most common mistakes are: an incorrect SharePoint site URL or list name in the trigger (copy the URL directly from SharePoint), a recipient email address that is not valid or a distribution group that does not accept external messages, and forgetting to test with a test item before the flow goes into production. Also use dynamic content carefully: some fields may be empty depending on the input, which can result in incomplete emails.