Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Query
Unanswered

Sharepoint list permissions

(0) ShareShare
ReportReport
Posted on by 87

Hi,

 

My organisation has a few PowerApps where the data contained in the data source (Sharepoint Lists) is sensitive information about employees.

 

We have followed all the guidance so that the lists are not accessible through web browser and have also used a flow to set the hidden and Nocrawl properties to true. The list does not even show up in site contents.

 

However…


All lists on all sites are accessible through excel and the New Query -> SharePoint List


Yes, you have to know the Site name. But if you do you can see everything and import the data into excel.

 

Is there any way round this?

 

Strangely Teams sites are not affected by this. You have to be a team member or have permissions to read/write/contribute something in the site. 


Thanks very much.

 

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 the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Power Query

#1
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 7

#3
SD-13050734-0 Profile Picture

SD-13050734-0 6

Overall leaderboard

Featured topics