cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Permissions on excel data source

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Permissions on excel data source

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.

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Permissions on excel data source

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

 

View solution in original post

3 REPLIES 3
Highlighted
Community Champion
Community Champion

Re: Permissions on excel data source

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.

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Permissions on excel data source

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

 

View solution in original post

Highlighted
Community Champion
Community Champion

Re: Permissions on excel data source

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.

 

 

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (7,368)