Central News Help

Hello everyone,

I’m looking for guidance on using SharePoint to distribute department updates across multiple locations, with an administrator controlling who sees each update.

Our organization uses a dedicated Microsoft Team for each location (27 total). A single update may need to be shared with one location, several locations, or all 27. Conceptually, I have a solid understanding of how this should work, but I’ve run into some practical roadblocks, and Copilot hasn’t quite gotten me where I need to be.

Here’s the workflow I’m envisioning:

• A Department Head submits an update via a Microsoft Form.
• The form responses are stored in a SharePoint List on a central “News Hub” site.
• An Admin reviews the submission, makes edits if necessary, selects one or more target locations, and publishes the update.
• Each update includes a publish date and an expiration date, since these updates are used for monthly meetings at each location.

Based on the selected target locations, the update would either:

• Display on a SharePoint site associated with the corresponding Team(s), or
• Remain on a centralized News Hub as an additional page that can be embedded on a TEAM channel. 

The page itself would contain both static content and dynamic monthly updates. The updates should be visible as text only (not clickable), as I want managers to see the information without navigating away from the page.

The final output would be embedded into a Teams channel, allowing each location’s manager to see only the updates targeted to their specific office.

From my understanding, this aligns with a “hub-and-spoke” news model, using:

• Microsoft Forms
• SharePoint Lists
• Power Automate (triggered when a list item is modified)
• Logic to route or display updates to the appropriate locations

I’d prefer to avoid building a Power App if possible, but I’m open to it if that’s the only viable solution.

Also, I have complete rights to the Central News Hub and the Sharepoint and Team site that I am testing on.

Any advice, best practices, or examples of similar implementations would be greatly appreciated. 

Thank you in advance.