cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DSgUY
New Member

Deployment of Leave-Request APP template. Sensitive data FAIL!

Hi, I have installed and edited the leave request app in my personal office365 business folder. I publish the app and share it to a work colleague as USER. He started the app but the Excel record of his session is not created. I think has something to do to the permission of the excel.

 

I use the Leave Request template version that is connected to an Excel spreadsheet to store all the data of the app.

I don't want to expose the excel to all my work colleagues for confidence reasons. Do I have to?. 

 

Regards.

11 REPLIES 11
RandyHayes
Super User III
Super User III

@DSgUY 

Yes, you will have to share the file from your OneDrive for others to be able to write to it.  If your app writes to a datasource, then users will need to have access to it in order to write.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

Woow! thanks for your ultra fast reply!.

 

I can't do that. It must be a work around to this because it means that every powerapp created expose the database to the users?

@DSgUY 

Yes, it is really no different than any other application.  If you had a SQL based application that users needed to write to, then they would need access to it...

 

The only other way around it is to utilize PowerAutomate to put items into a datasource.  It is not clean.  For Excel, you would not be able to do this method.  For SharePoint you could.  Or you could combine SharePoint as a repository for your leave requests, have PowerAutomate trigger off of changes or additions to that list and then within the PowerAutomate flow, have it add a row to an excel file or transfer to another private list.

Again, not real easy...

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

Maybe I not deploying the app correctly.

I share the app from the powerapp make page when I was editing the Leave Request Template. I enter his email and select USER profile. My colleague received an email notification and start using it. When opened he is not seeing the days count etc. With my user I checked the data file and I saw that his record (row) was not created.

 

I undersand that he uses the excel for saving the data but if I also share the excel he will be able to see the records of other colleagues, right? I dont want that. If like seeing all the database of an app.

@DSgUY 

That is correct and that is the nature of using Excel as a data source.  All users must be able to have access to it - otherwise, they will see nothing and not be able to write/update anything to it.

Again, it's like any data source, if users can't access it, they can't do anything with it.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

ok. can I change something, use another thing to achive what I want? Despite your early reply.

 

@DSgUY 

Yes, you can re-read my second message to you. There are some workarounds listed there.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

yes, Im reading that answer.  I use excel because it was by default in the leave-request app. I can use anything else that works. I was reading about Common Data Service but I think is a premium feature. Maybe with sharepoint as you suggest?

Purikura
Frequent Visitor

I'm also facing the same issue here and many others too. A thread was created by me few weeks ago. 

 

https://powerusers.microsoft.com/t5/Building-Power-Apps/PowerApps-Leave-Request-Data-source-loophole...

 

Somehow all the workaround require extensive changes to the nature of the program and it will change the user experience so I think it really defeats the purpose.

 

I'm not sure if SharePoint list will work for as there is an option to 'view items created by you'. Really hope Microsoft can come out with something that can resolve this huge flaw.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (3,290)