Hello Everyone, i m new to power platform.
i have created a PowerApps application that uses SharePoint lists as a database.
I use a form to take data from the PowerApps application and store it on a SharePoint list. This application will be utilized by everyone in the organization, so all end users of the application must be added to the SharePoint list as members in order to view the relevant data when filling out the form and storing it in the database.
However, as a member, they can view and edit the data. However, i do not want them to be able to modify the data directly in the SharePoint list.
if you can help with following alternatives -:
i tried creating the permission by
Setting -> Site Permissions -> Advance Permission Settings.
i created group with following permission -
List permission :
Site Permissions :
However, users can still edit the data. I'm not sure if I set it up right.
Hi,
This is unfortunate limitation of SPlist as a database,
-I've used flows that allow hiding the list so well it's virtually impossible to get to it after running the flows.
-You can set the splist to make records only available to the creator, this is very limited application I think unless you combine it with a flow that will duplicate the records into another list available only to the admins.
- I believe you can use dataverse without premium inside of ms teams environment which would solve all the security issues, but i understand not everyone can limit the app to work in teams.
I hope someone found a way to solve it honestly. I love SPlists and it would be great if they were more secure in this way. I have premium but not using much dataverse as in large company the premium licenses are not viable sometimes especially if hundreds of users will use only one or two apps.
Seb