How do I prevent users going into the sharepoint list directly and editing items that do not belong to them?

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

I have given "contribute" access to users which means users can "Can view, add, update" items.

How do I prevent them going into the sharepoint list directly and editing items that do not belong to them?

I prefer them not editing the sharepoint list directly at all.

In power apps i am able to make it so they can only view items that belong to them.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
@wonka1234 - to use a Power App with a SharePoint list connected as a data source, users must ultimately have the necessary permissions to that list.

There are several workarounds you find on the web, but remember that is what they are - workarounds:

https://powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/PowerApps-Community-Call-How-to-creat...

https://powerusers.microsoft.com/t5/Building-Power-Apps/hide-sharepoint-list-from-users/m-p/435504

https://powerusers.microsoft.com/t5/Building-Power-Apps/Sharing-a-Power-App-without-Sharing-the-Shar...

https://powerusers.microsoft.com/t5/Building-Power-Apps/Sharing-a-Power-App-without-Sharing-the-Shar...

https://powerusers.microsoft.com/t5/Building-Power-Apps/Allow-Sharepoint-List-in-app-but-data-inacce...

Was this reply helpful? Yes No
Bartelli 75 on at

Like (0)

Report

Hi, @wonka1234 ,

@Amik has given you a bunch of workarounds. The easiest is to adjust the SharePoint list settings (Advanced). You can choose to allow the user to Read All or only items that were created by the user.
Please let me know if this helps, thanks!

Was this reply helpful? Yes No
WarrenBelz 153,030 Most Valuable Professional on at

Like (0)

Report

@wonka1234 ,

Firstly, you can give them a customer permission level in SharePoint based on Contribute, but with View Application Pages disabled - that way they cannot access any SharePoint views, but can still write from Power Apps.

If you want them to only operate on their own records in SharePoint, this blog of mine may give you a pathway to achieving this. Essentially you can restrict the user to an integrated app, in which you can make the controls in View Mode for everything other than records created by them.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No