Answered

SharePoint List Visible Security Requirement

(1) Share

Report

Posted on by PD-18021222-0

Hi Folks ,

I have a requirement : I have SharePoint Site for Development ,Production as Private Group (Team Site) , where there are different List with data for Different PowerApps applications. And SharePoint Site has set of People around (200+) as Owner ,Member and Visitor Access.

I want a solution where :

1) Any User can only View the SharePoint Site when click on SharePoint Link .But not able to see any List Present in the Site.

2) Only SharePoint having Owner Access can have the Full Control to view, edit ,delete and read any list.

3) But Any User ,whatever action they are supposed to do in any PowerApps (like Add, Edit, Delete and View)the data, they can able to do .But they can not access any List present under the site (not visible to them).

4) Some List contains more than 30K records.

Kindly help me to resolve the Issue sharing the steps to meet the requirement.

Thanks in Advance

Categories:

Connectors

Using Apps Using Formulas

Connecting to Data

General Questions

All responses (4)

Answers (1)

PD-18021222-0 8 on at

Like (0)

Report

SharePoint List Visible Security Requirement

hi @S.-19020525-0 ,thanks for the reply .But unfortunately may be i am unable to describe the requirement .

Basically , I want SharePoint Site to be only having Full control access to all list and site both to definite user. But for Certain user may have the Site Access only but they can not View any List present under the site .But they can view there data and do CRUD operation in those hidden lists using PowerApps screen only. And Kindly note : this SharePoint site's having 200+ people given as access and some list having more than 30k records present.

Do let me know ,if its clarify the requirement and kindly share any approach if present.

Thanks
PD-18021222-0 8 on at

Like (0)

Report

SharePoint List Visible Security Requirement

Hi @FLMike , thanks for the response and notifying me about where to Post this Question.

Can share any Approach or PowerAutomate flow steps ,My requirement is to basically End Users unable to view or Mask or trim the fullpath of SharePoint Attachment in the Browser.They can only see the SharePoint site name in the browser while i am launch() it.
MSR@08012015 574 on at

Like (0)

Report
SharePoint List Visible Security Requirement

Hi,

1) Any User can only View the SharePoint Site when click on SharePoint Link .But not able to see any List Present in the Site.

Solution : This is because the SharePoint Site may have the Permission for everyone, where as the list might have broken the permission inheritance from the parent and restricted to certain audience this needs to be altered.

2) Only SharePoint having Owner Access can have the Full Control to view, edit ,delete and read any list.

Solution : Create SP Groups as per naming convention or Modify the existing SP Group Permission Level Such as Members will have Full Control access where as Visitor or Other Group Members just give View access. This will help all the Members can perform the CRUD Operations but Visitors can view the data without any issue.

3) But Any User ,whatever action they are supposed to do in any PowerApps (like Add, Edit, Delete and View)the data, they can able to do .But they can not access any List present under the site (not visible to them).

Solution : Sounds interesting, If you are accessing the data from Power Apps first step we will connect the data-source to the application if the data doesn't have relevant permission the users cannot able to perform any operations to the datasets which you are connected.

For your problem, Lets create a SharePoint Group Named as Power Apps Users in the application and provide the Permission Level as Contribute this will help you address the problem

4) Some List contains more than 30K records.

Solution : This is default item limit in-terms of SharePoint, which allows 5000 item view per page/api call and in PowerApps Max of 2000.

Index the relevant columns which you are going to use at Max you can index 20 columns per list.

In Power Apps use delegable queries such as Filter, Starts With, Ends With.

Use Pagination techniques or lazy loading in the Power-apps gallery for showing the records.

Hope this will helps
Verified answer

Michael E. Gernaey 36,211 Super User 2025 Season 1 on at

Like (1)

Report

SharePoint List Visible Security Requirement

Hi

Unfortunately this isn't the SharePoint forum. That being said, you cannot hide the List from someone but at the same time giving them essentially contributor (add/delete etc) to sharepoint.

What you want isn't really possible.

Plus I would suggest you put this question in the Office SharePoint forum instead.