Power Automate: Send a Teams message when a new SharePoint item is created
With Power Automate you can automatically send a Teams message whenever a new item is created in a SharePoint list. You set up the trigger 'When an item is created' on the SharePoint connector and then add the action 'Post a message in a channel'. By using dynamic content from the SharePoint item, the message looks informative and concrete. This way your team is always immediately informed of new data entries.
In many BI and data environments it is important to be quickly informed of new data entries. With Power Automate you can easily set up a trigger that automatically sends a message in Microsoft Teams whenever a new item is added to a SharePoint list.
In many BI and data environments it is important to be quickly informed of new data entries. With Power Automate you can easily set up a trigger that automatically sends a message in Microsoft Teams whenever a new item is added to a SharePoint list. This article teaches you how to set up this workflow, so your team is immediately informed and can respond more quickly.
What you need
-
A SharePoint list where new items are added
-
A Microsoft Teams channel to which the message will be sent
-
Access to the Power Automate portal to create the flow
Step 1: Create a new flow with the trigger ‘When an item is created’
Open the Power Automate portal and choose to create a new automated cloud flow. Select “When an item is created” under the SharePoint connector as the trigger. Enter the URL of your SharePoint site and select the correct list. This trigger ensures the flow starts as soon as a new item appears in the list.
Step 2: Add an action to send a message in Teams
Add a new action and search for the Microsoft Teams connector. Choose the action “Post a message in a channel”. Select the team and channel where the message should go. In the message field you can add dynamic content from the SharePoint item, such as the title or other relevant columns, so the message is clear and informative.
Step 3: Test and activate the flow
Save the flow and test it by adding a new item to the SharePoint list. Check whether the message appears correctly and promptly in the chosen Teams channel. Adjust the message or settings if necessary. Once everything works, make sure the flow remains active so your team is always immediately informed.
Tips & common mistakes
-
Make sure you select the correct SharePoint site and list to avoid errors.
-
Use clear and relevant dynamic content in the Teams message for maximum clarity.
-
Always test the flow with a sample item before taking it into production.
-
Pay attention to permissions: the user creating the flow must have access to both SharePoint and Teams.
Example / mini use case
A BI team uses a SharePoint list to register new data reports. With this flow the team automatically receives a Teams message for each new SharePoint item, so they can immediately start with the analysis without manually checking.
Conclusion
With this simple Power Automate trigger you improve communication within your BI team and ensure a faster response time with new data entries. Set this up via the Power Automate portal and immediately experience the benefit of automated notifications.
Our tip: Always test the flow with a sample item before taking it into production. Add a new item to the SharePoint list and check whether the Teams message appears correctly with the right dynamic content. This catches errors in the settings before real users depend on the notification.
Frequently asked questions
What tips and common mistakes are there?
- Make sure you select the correct SharePoint site and list to avoid errors. - Use clear and relevant dynamic content in the Teams message for maximum clarity. - Always test the flow with a sample item before taking it into production. - Pay attention to permissions: the user creating the flow must have access to both SharePoint and Teams.
How do I add dynamic content to a Teams message in Power Automate?
In the message field of the Teams action, click 'Add dynamic content'. You will then see a list of fields from the SharePoint list, such as the title, creation date or other columns. Select the fields you want to show in the message. This automatically fills the message with the current data from the new item, without you having to type it manually.
What permissions are needed to create a Power Automate flow for SharePoint and Teams?
The user creating the flow must have read permissions on the SharePoint list and be a member of the Teams channel to which the message is sent. Power Automate executes the flow on behalf of this user. If permissions are missing, the flow will fail and an error message will appear. Check this in advance in the SharePoint and Teams administration environment to prevent problems.