web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / PowerApps and Sharepoi...
Power Apps
Answered

PowerApps and Sharepoint List access permission

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Each time a user want to lookup a value in the combo box they get below errors.

 

"You dont have permission to use this lookup. Server Response: The response is not in a JSON format."

 

Please help!

 

Categories:
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Anonymous 

    Does the user have permissions to the List?  They need to have at least read access.  They need contribute and edit access if you are planning to write to that list in the app.

     

    I hope this is helpful for you.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @RandyHayes  How do i grant permission to user to have access the share point list in a way that they wont edit the items on the list.

     

    Your video always help.

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Anonymous 

    In that case...I wish I had a video for you on this 😁  Perhaps I need to put one together 😉

     

    Your list (and site) will have three built in groups - Members, Owners and Visitors.  The Visitor group has read only access.  So, you can add everyone to the Visitor group.

    This is all done in the List settings under the "Permissions for this list" setting.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Please do a video, I will check this step and revert as soon as possible.

     

    All your videos are straight forward and well explanatory

     

    Thanks for your quick response always.

  • Verified answer
    RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Anonymous 

    Thank you for that feedback.  It is more encouragement for me to try desperately to find the time to produce more, as it has been over a year now and I had a slew of videos on the production line that got sidetracked.  It's just hard to find enough time to do everything!

  • A-Roosevelt Profile Picture
    153 on at

    @AnonymousHope you're  doing good?

    You can check this by

    • Navigate to your SharePoint site.

    Click the settings icon below. SharePoint SiteSharePoint Site

    This will take you to a set of options as shown in the image below:

    • Click on "Site Permissions" as shown in the image below.

    sharepointsitepermission.PNG

    It will take you to some options where; 

    • You can add a new member and give the desired permission.
    • Edit the permission of the site members to full control.

    Note: if you're not the owner of the site, just make sure you have the full control access from the admin.

    sharepointsitemembers.PNG

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Do well to let me know how it worked for you!

    Cheers!!

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @A-Roosevelt  Keep in mind that what you are showing is for the entire site.

    List permissions can be more specific to just the list.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks @A-Roosevelt , I want the permission for the list and not the whole site, 

  • A-Roosevelt Profile Picture
    153 on at

    @RandyHayes Thanks for bringing my attention to that, it's the same rules that applies, he need to contact the owner of the list to grant him full access.

     

  • A-Roosevelt Profile Picture
    153 on at

    @Anonymous Let me do an instruction for that

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 397 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 354

#3
WarrenBelz Profile Picture

WarrenBelz 232 Most Valuable Professional

Last 30 days Overall leaderboard