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 as soon as 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 faster.
What You Need
- A SharePoint list where new items are added
- A Microsoft Teams channel where the message will be sent
- Access to the Power Automate portal to create the flow
Step 1: Create a New Flow with Trigger ‘When an Item is Created’
Open the Power Automate portal and choose to create a new automated cloud flow. Select the trigger “When an item is created” under the SharePoint connector. 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 be sent. 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 if the message appears correctly and timely in the chosen Teams channel. Adjust the message or settings if necessary. Once everything works, ensure the flow remains active so your team is always immediately informed.
Tips & Common Mistakes
- Make sure to 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 putting 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 a new SharePoint item, allowing them to start analysis immediately without manual checking.
Conclusion
With this simple Power Automate trigger, you improve communication within your BI team and ensure faster response times for new data entries. Want to learn more about automating processes? Also check out the article Apply an Approval Process in Power Automate. Set this up via the Power Automate portal and immediately experience the benefits of automated notifications.
