You don’t have permission to view this data error in Power Apps

In this Power Apps tutorial, we will discuss a common error in Power Apps‘You don’t have permission to view this data. Server Response: Products failed: Something went wrong, and how to resolve it.

Power Apps Error: You don’t have permission to view this data

I have created an app where I needed to create a Power Apps Collection to create a gallery index. For that, I have applied the collection formula on the Screen’s OnVisible property, i.e.

OnVisible = Clear(colIndex);
ForAll(
    Products,
    Collect(
        colIndex,
        {
            ItemID: ID,
            Index: Value(Last(colIndex).Index) + 1
        }
    )
)

Where,

  1. colIndex = Collection name
  2. Products = SharePoint List name

When I wrote the above formula, I encountered an error message stating, “You don’t have permission to view this data. Server Response: Products failed: Something went wrong.” Refer to the screenshot below.

You don't have permission to view this data error in PowerApps

Solution: You don’t have permission to view this data error in Power Apps

When this error occurred in the app, I searched for it in the browser and found many solutions, and then I tried them. Here, I will outline some essential tips to help you resolve this error. Follow the points below:

  • If you see this error in your app, first check the permission settings for your Power Apps data sources.
  • Many users connect to various data sources, including SharePoint, Azure, Excel, and SQL. Here, we focus on SharePoint since it’s the most common.
  • Ensure the SharePoint list is shared with everyone who needs to use it in Power Apps; otherwise, they will encounter an error.
  • Users need at least View permission on the SharePoint list to avoid errors.
  • You can create a Custom Permission based on the required level and uncheck “View application pages” to restrict access to SharePoint views.
  • The custom permission should be based on at least the Contribute level.
  • Users must have permission to access the SharePoint list data source in Power Apps.
  • Sometimes, even with correct permissions, users may still see errors.
  • To fix this, refresh the SharePoint list connection in your app:
    • Go to View tab → Data sources → find your SharePoint list connector → click the ellipsis () → select Refresh.
  • After refreshing, the error should disappear, and your app will work properly.
PowerApps error you don't have permission to view this data

Also, you may like the following Power Apps tutorials:

I hope all these above tips will be helpful for you to overcome the Power Apps error, i.e., “You don’t have permission to view this data. Server Response: Products failed: Something went wrong.

Leave a Comment

Power Apps functions free pdf

30 Power Apps Functions

This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.

Download User registration canvas app

DOWNLOAD USER REGISTRATION POWER APPS CANVAS APP

Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App