Permissions on excel data source

[CH6]

I have built a form for people in my organisation to fill out. The Powerapp is connected to two excel files on onedrive. One file feeds the data into the app for drop-downs etc while the other stores the form's entries. 

I have tested my app with one of my colleagues by giving him permission to view the file that feeds the data in. I thought that would be the only file you would need to give permission in order to use the app. When he entered data into the fields, nothing was sent to the form entries file.

The data that is entered is confidential so I do not want to give permissions to people to view the file that is saving the entries. 

Can you please advise if there is a way of enabling all my colleagues to uses this app without allowing them permission to the form entries file? Appreciate your suggestions, thank you.

[WarrenBelz · Accepted solution]

Hi @CH6 ,

Firstly, Excel as a data source is not really designed with security in mind.

You will always have to give a user permissions to write to a file to allow them to do this in PowerApps, however the two files do not need to be in the same folder, so you could share the folder for the first one and then shift the file to another folder and only share the file. The user would have to know where it was to find it. 

An alternative is to consider SharePoint for the files (or certainly the confidential one) - it is a bit easier to hide the list from any browsing exercises to find it.

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.

[Yeiner · Accepted solution]

Hello @CH6 

You will need to provide user permissions to write to a file to allow them to do this in PowerApps.

consider SharePoint for the files or certainly the confidential one

[WarrenBelz]

Hi @CH6 ,

What @Yeiner posted was exactly what I said (with a bit more information) on the last post I did.

You can consider accepting multiple correct solutions.