Others

How to Create a SharePoint and Teams Workflow for Department Updates

Tauseeq Magsi Sep 28, 2026 869 views

Question details

The user needs to set up an automated system for departments to submit monthly updates via SharePoint, centralize the data, tag it by location, and distribute it to relevant Teams channels.

How to Create a SharePoint and Teams Workflow for Department Updates

Product: SharePoint, Microsoft Teams, Power Automate
Device & OS: not provided
Scenario: Automating monthly departmental project updates and distributing information securely across a company network.
Observed behavior: The desired goal is to have isolated department-specific submission areas, a centralized hub for administrators, and automated routing of location-specific updates to local teams.

Before you start

Ensure you have Site Owner or administrative permissions for the necessary SharePoint sites and Microsoft Teams channels, as well as an active Microsoft 365 account with Power Automate access.

Solution 1Recommended

Build an Automated Workflow with Power Automate

This solution uses SharePoint lists for data entry, Power Automate for routing logic, and Microsoft Teams for localized distribution.

By leveraging the native integration between Microsoft 365 applications, you can create a highly secure and automated pipeline. This setup ensures data privacy between departments while giving administrators a full overview.

Create Department and Central SharePoint Lists

Set up individual SharePoint sites or pages for each department to input monthly updates via Lists. Then, create a centralized List on a separate admin-only site to act as the main hub.

Set Permissions for Security

Go to the 'Site Settings' > 'Site Permissions' for each department site to ensure users only have 'Edit' access to their specific input areas, while giving administrators access to the central hub.

Configure the Power Automate Trigger

Open Power Automate, click 'Create' to build an automated cloud flow, and select the 'When an item is created' trigger in SharePoint. Point this to one of your department lists.

Copy Data to the Central Hub

Add a new step with the 'Create item' action in SharePoint. Map the dynamic content (like Title, Description, and Location Tag) from the department list to your central hub list.

Route Updates to Teams by Location

Add a 'Condition' control based on the location tag. In the 'If true' branch, use the 'Post message in a chat or channel' action to automatically notify the specific local team in Microsoft Teams.

Build an Automated Workflow with Power Automate

Workflow Optimization: You can duplicate this Power Automate flow for each department list, or use advanced expressions to route multiple lists through a single dynamic workflow.

Free Microsoft Office alternative

Manage Your Project Documents with WPS Office

While SharePoint and Teams handle your automated workflows, you still need a powerful office suite to create and edit the monthly project reports. WPS Office is a free, lightweight alternative that lets you handle documents seamlessly before submitting them to your SharePoint workflow.

1. Download and Install WPS Office: Visit the official WPS website to download and install the free office suite on your device.
2. Edit Your Project Reports: Open WPS Writer or WPS Spreadsheet to compile your monthly departmental project data.
3. Save and Submit: Save your files in standard .docx or .xlsx formats and upload the data seamlessly to your SharePoint list.

Free and lightweight office suite for daily project management.Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Easily edit local documents before uploading your monthly project updates to SharePoint.Familiar user interface ensuring a seamless migration for all team members.

microsoft office alternative - wps office

Frequently Asked Questions

Do I need a premium Power Automate license to connect SharePoint and Teams?

No, the standard connectors for SharePoint and Microsoft Teams are included in most base Microsoft 365 business licenses, allowing you to build this automated workflow without premium add-ons.

How can I ensure departments only see their own SharePoint lists?

Navigate to the List Settings in SharePoint, select 'Permissions for this list', click 'Stop Inheriting Permissions', and manually remove groups that should not have access to that specific department's area.

Can I trigger this workflow on a monthly schedule instead of every time an item is added?

Yes, you can use the 'Recurrence' trigger in Power Automate to run the flow on a specific day each month. This scheduled flow can pull all recent updates at once and distribute them to the appropriate Teams channels.

Office Quick Solutions