Forum Discussion
2 very strange behaviors with sharepoint online list settings . permissions nightmare
1) When I turn Quick Property Editing Off (No) I lose the ability to edit in grid view on my sharepoint online record list view, as is expected.
.My coworker still has this ability to do so, even after removing the cache, trying a different browser, yet they do see that the list setting -> advanced settings -> quick property setting is correctly set to 'No'.
2) When quick property editing is set to No, uploading 5 rows inexcel with power automate to push these excel rows into sharepoint items takes twice as long (8 minutes) versus when quick property editing is set to Yes (3 minutes).
Is this because Quick edit doesnt allow 'bulk edit data' so it throttles power automate from moving rows into the online list?
And bonus question ,but this is more a power apps question, what is the point of locking data fields in power apps that has sharepoint integration when anyone can just edit those fields in 'edit grid mode' in the sharepoint list? id like 'edit grid mode' then disabled for all users
How it should have been built is like this: if you cant edit a field in your sharepoint integrated custom app, than you cannot edit the cell in 'GRID MODE' and the cell should be 'READ ONLY'
1 Reply
childishbambino Ideally when you turn OFF quick edit settings from list settings, it should be applied to all users using this list. Try this:
- Create another test list in your site and see if you can replicate the same issue in test list.
- Raise support ticket with Microsoft: Get M365 support
Do you want your users to go to SharePoint and see the list items but they should not edit items? If you don't want users to access the list from SharePoint UI, you can make your list hidden from SharePoint UI using PowerShell (Note: CRUD operations can be done on list using API calls, Power automate, etc.)
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
