Where do I set permissions for a Sharepoint List being displayed to the public in Power Pages?

(1) Share

Report

Posted on by JM-30091617-0

I am new to Power Pages, and fairly new to Sharepoint. I have an existing Sharepoint List that I want to display (read only) on a Power Pages page to anyone visiting the page (no need to log in). I was able to connect and add the list to the page, but the data will not display in either the editing environment or the public site. The table headers show up, but the data fields display "Internal Server Error." I assume this is a permissions issue on the Sharepoint side. The list is currently set up to give unique permissions to specific internal groups. I think I must need to create a permission's group for anonymous users (external to our company), and then grant that group read-only permission. Is that right? If so, how do I set up that group -- in 365 Admin Center, in Sharepoint, or somewhere else? If not, what settings to I need to change?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Jon Unzueta 1,827 Super User 2025 Season 2 on at

Like (1)

Report
@JM-30091617-0

this does sound like a permissions issue on the SharePoint side, especially since you're trying to expose the list to anonymous users via Power Pages.

Here’s a step-by-step guide to help you resolve it:

✅ Goal:

Display a read-only SharePoint list on a Power Pages site that is publicly accessible (no login required).

🔧 Steps to Enable Anonymous Access to SharePoint List

1. Enable Anonymous Access at the Site Level

SharePoint Online does not natively support anonymous access to lists or libraries like classic SharePoint did. However, you can:

Create a SharePoint page that displays the list (e.g., using a web part).

Share that page using the “Anyone with the link” option.

⚠️ Note: You cannot directly share a SharePoint list with anonymous users, but you can share a page that displays the list.

2. Use Power Automate or Graph API as a Proxy

Since direct anonymous access to SharePoint list data is restricted, you can:

Create a Power Automate flow or Azure Function that reads the list data.

Expose that data via a custom Dataverse table or Web API.

Display the data in Power Pages using Entity Lists or Liquid templates.

This way, you control access via Power Pages and avoid exposing SharePoint directly.

3. Alternative: Export List to Excel or Dataverse

If the list doesn’t change often:

Export the SharePoint list to Excel or CSV.

Import it into a Dataverse table.

Display it using an Entity List on Power Pages.

🛑 Why You’re Seeing “Internal Server Error”

Power Pages is trying to access SharePoint data using a connector that requires authentication.

Anonymous users don’t have access to the SharePoint list, hence the error.

🧭 Where to Manage Permissions

Microsoft 365 Admin Center: For user and group management.

SharePoint Site Settings: For sharing pages or files.

Power Platform Admin Center: For configuring Power Pages and Dataverse access.

🏷️ Tag me if you have any further questions or if the issue persists. ✅ Click "Accept as Solution" if my post helped resolve your issue—it helps others facing similar problems. ❤️ Give it a Like if you found the approach useful in any way.

Was this reply helpful? Yes No
Suggested answer

DP_Prabh 43 on at

Like (0)

Report

Power Pages cannot directly display SharePoint list data to anonymous users. SharePoint does not support anonymous access to list data due to security restrictions.

The Correct Approach:

1. Copy or sync your SharePoint list into a Dataverse table. (either you can create virtual table in Dataverse if you don't have attachments)
You can export the list to Excel and import it into Dataverse Or use Power Automate to keep the data in sync.
If you have attachment as well in SharePoint, then sync data by using power automate flow.

2. Configure table permissions in Power Pages:

- Go to Power Pages Studio → "Set up" → "Permissions" → "Table permissions."
- Create a new table permission for the Dataverse table.
- Set the access type to Global.
-Set the permission level to Read.
- Assign the permission to the Anonymous Users web role.

3. Save and publish your site.
Your Power Pages site will now display the list data to anyone, without requiring sign-in.

Was this reply helpful? Yes No