cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CH6
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
WarrenBelz
Super User III
Super User III

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

Yeiner
Community Support
Community Support

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
WarrenBelz
Super User III
Super User III

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

Yeiner
Community Support
Community Support

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

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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,115)