Skip to main content
Community site session details

Community site session details

Session Id : ZwIIwHoKNf04pp/FdOQcVE
Power Apps - Building Power Apps
Unanswered

Error when opening data from list with no access

Like (0) ShareShare
ReportReport
Posted on 5 Sep 2023 13:55:37 by 35

I have a user who has access to the Power App but no read permissions to certain lists.

As soon as the user opens a screen that attempts to load data through the SharePoint connection and collections, the following errors occur:

"Error when attempting to retrieve data from the network: X failed. The response is not in JSON format."

 

How can I best resolve this?

  • MarkRahn Profile Picture
    1,061 Super User 2025 Season 2 on 05 Sep 2023 at 16:48:38
    Re: Error when opening data from list with no access

    Hi @AH92 

     

    For the App, there will be a Property named "OnError". Start by adding the following code to the "OnError",

    Notify(
     Concatenate(
     FirstError.Message,
     ", Observed: ",
     FirstError.Observed,
     ", Source: ",
     FirstError.Source
     ),
     NotificationType.Error
    );
    Trace(
     "Unhandled Error",
     TraceSeverity.Error,
     {
     Kind: FirstError.Kind,
     Message: FirstError.Message,
     Observed: FirstError.Observed,
     Screen: App.ActiveScreen.Name,
     Source: FirstError.Source,
     User: User().Email
     }
    )

    This code was taken from the blog post by @mdevaney 

    https://www.matthewdevaney.com/power-apps-onerror-property-capture-log-unexpected-errors/#Write-A-Custom-Error-Message-With-Power-Apps-OnError-Property

     

    This can give you more details on the error. From there base on the "FirstError.Source" value, you could set a variable for Showing/Hiding the Edit form on a Screen and instead displaying a more friendly message that the user does not have access.

     

    -Mark

     

    If this helped you get to a solution, please click on Accept as Solution below

  • AH92 Profile Picture
    35 on 05 Sep 2023 at 15:52:30
    Re: Error when opening data from list with no access

    Yes, something like that. How can I catch this error? 

  • MarkRahn Profile Picture
    1,061 Super User 2025 Season 2 on 05 Sep 2023 at 15:39:48
    Re: Error when opening data from list with no access

    Hi @AH92 

     

    Are you looking to display a prettier error message? Or something else? For example, do you want to supports the Error that is showing and instead show a label on the form that says "You do not have Permission to view this form"?

     

    I am trying to figure out what you are looing for to better answer your question.

     

    -Mark

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading started