Power Platform Community Forum Thread Details

To publish news from a SharePoint Communication site to a Teams channel using Power Automate, the inability to access the Site Pages library may stem from insufficient permissions or incorrect configuration in your flow. Below is a step-by-step guide and a workaround to achieve your goal:

Step-by-Step Solution

1. Check Permissions on the Site Pages Library

Ensure the account used in Power Automate has at least Contribute or Edit permissions on the Site Pages library:
1. Navigate to the SharePoint Communication site.
2. Go to Site Contents > Site Pages.
3. Check permissions for the Power Automate user account (or group).
4. Grant permissions if necessary.

2. Create a Flow to Monitor Site Pages

Use the "When an item is created or modified" trigger:
1. Select the SharePoint Site Pages library.
2. If Power Automate cannot access this library directly, use an HTTP request as a workaround.

3. Workaround: Use "Send an HTTP Request to SharePoint"

If the Site Pages library is not accessible through the standard actions:

Add the "Send an HTTP Request to SharePoint" action:
1. Site Address: Select the communication site.
2. Method: GET
3. URI:
  
  _api/web/lists/getbytitle('Site Pages')/items?$filter=PromotedState eq 2&$orderby=Modified desc
  - This retrieves news posts (PromotedState eq 2) sorted by the last modified date.

4. Extract Key Information from the News Post

Use a Parse JSON action to process the response from the HTTP request.
Input the body of the HTTP request, and generate the schema automatically by running the flow once.

5. Post to Teams Channel

Use the "Post a message in a chat or channel" action:
1. Team: Select the target team.
2. Channel: Select the desired channel.
3. Message: Format the news post dynamically:
  - Example message:
    
    <strong>New SharePoint News Published:</strong><br> <a href="@{item()?['FileRef']}">@{item()?['Title']}</a><br> Published on: @{item()?['Modified']}

Flow Example Outline

Trigger:
- Use "When an item is created or modified" or manually query using an HTTP request.
Send HTTP Request (if needed):
- Retrieve news posts dynamically from the Site Pages library.
Parse JSON:
- Parse the response from the HTTP request.
Post to Teams:
- Use the "Post a message in a chat or channel" action to share the news.

Key Troubleshooting Points

Library Accessibility:
- Verify that the Power Automate user has access to the Site Pages library.
- Use the HTTP request workaround if the default actions fail.
News Page Filter:
- Ensure you’re only retrieving news posts by filtering on PromotedState eq 2.
Teams Message Format:
- Test different formats for the message to ensure it’s user-friendly and clickable.