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

by

In this PowerApps Tutorial, we will discuss a common error in Power Apps i.e. You don’t have permission to view this data. Server Response: Products failed: Something went wrong.

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

I have created an app where I need to create a PowerApps Collection to create a gallery indexing. 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

So when I have written the above formula, I got an error like “You don’t have permission to view this data. Server Response: Products failed: Something went wrong“. Refer to the below screenshot.

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

Also read: Power Apps Search Gallery + 19 Examples

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

When this error occurred in the app, I searched it in the browser and found many solutions and then I tried it. Here I will share some important things that you can try to overcome this error. Follow the below points:

  • While you are getting this type of error in the app, the first thing you need to make sure check the permission things with the PowerApps data sources.
  • Many users use many of the data sources like SharePoint, Azure, Excel, SQL, etc. But here I will explain the SharePoint List Data sources because most of the PowerApps users use SharePoint data source connector.
  • The most important thing is, you need to share the list in Sharepoint with every user who needs to use it in the PowerApps otherwise the users will get the same error message that I got.
  • For this, you need to set the permission level to whatever is necessary, but it must be at least View. One thing you can put in place to create a Custom Permission based on the one you need and uncheck “View application pages” and they will not be able to access any views on the SharePoint site, even if they navigate directly to them.
  • The custom permission level needs to be based on at least Contribute. So overall I can say, here are all the data sources your users will need permission to the SharePoint list.
  • In some cases what happens is, even if you have the right permission to your SharePoint list data source connector, then also the users may able to see the same error message.
  • To avoid this type of issue, all you need to do one thing i.e. refresh your Sharepoint list in the app. Click on the View tab -> Data sources -> Go to your existing SharePoint list connector (Products) -> Click on the elipses (…) -> Refresh it as shown below. Once the list is refreshed, you can see the error will not appear again and the code will run appropriately.
PowerApps error you don't have permission to view this data
PowerApps error you don’t have permission to view this data

Also, you may like the below PowerApps tutorials:

In this Power Apps Tutorial, we discussed how to overcome an error in PowerApps i.e. You don’t have permission to view this data. Server Response: Products failed: Something went wrong.

>