I've created a powerapp canvas form app from a SharePoint list that each Employee must fill out. The only way I could get it to work was to share the app to all our internal users (from an AD group) as well as setting the permissions on the SharePoint list to ReadWrite.
However, building apps for employees to run should not then give them access to all the data, or at least, not to the other EMployee's answers. I've already contacted O365 support about the permissions, but we can't hide the list, the content type or the settings gear to prevent them from finding this list and seeing all of the data.
Is there not a way to design an app to use a generic account to post the data into the destination list/table (this is how most other applications work with SQL etc). If it did that, the app would use this account to write the data and the user themselves would not have access to the data ie the SharePoint list.
Anyone have any idea if PowerApps can so this? If not, it's really leaving a lot of data out there that people shouldn't see.
