cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Community Champion
Community Champion

Re: How to prevent employees from editing a Holiday Request SharePoint list?

Hi @MikeTwister @Anonymous @Fields@Anonymous

 

Allow me to add in my opinions here.

Yes, for PowerApp, when they are shared of the apps by owner, they can access to all the data and screens.

 

But there is always someway.

In fact, you can access control to Disable.True or False those areas you wish them to

- View

- Navigate

- Click

by creating additional username or passkey and then

bind it with Disable properties of those buttonb, list, etc. that you don;t want someone to use.

 

Please look at my blog to see if you can modify to meet your needs.

 

Just sharing:

I creata an App for my customer, and they only have ONE Account registered.

The Owners (2 of them) and the Employees (3 of them) are using the same Account to sign-in.

The owners (sign-in with Owener Passkey)  can view ALL screens, edit, delete ...

The Employees (sign in with their Passkey) can only ENTER data but nothing else, can;t delete or edit (even they are viewing the same screens).

 

Hope this helps.

Have a nice day and g9

hpkeong
Highlighted
Helper I
Helper I

Re: How to prevent employees from editing a Holiday Request SharePoint list?

Hi,

 

That is an interesting way of controlling access within the app.

 

However, I am not sure it helps with the situation where users can navigate directly to the SharePoint list where the data is held and edit it there, outside of the app.

 

Thank you,

 

Michael

Highlighted
Community Champion
Community Champion

Re: How to prevent employees from editing a Holiday Request SharePoint list?

Hi

 

Even the user is allowed to navigate to the specific page, you can Disable the Pen based on the user().name or user().email.

Example:

- Pen.Disabled : user().name = "name you wish to make it true".

 

I have doing this for my apps couple of months ago and use it within small organization to have a simple access control.

 

Hope you love this simple trick.

hpkeong
Highlighted
Helper I
Helper I

Re: How to prevent employees from editing a Holiday Request SharePoint list?

Thank you for your response. Yes, I realise that you can control access within the app using the user() formula.

 

However, that will not control access to the SharePoint list behind the application.

Highlighted
Advocate I
Advocate I

Re: How to prevent employees from editing a Holiday Request SharePoint list?

Realizing that this thread is a few months old, what the author wants to accomplish is possible.  You can restrict access to the list as desired at the sharepoint list level.  Powerapps is just an interface to the data and cannot prevent data entry and/or modification directly to the list on sharepoint.

 

  • Open the sharepoint list that restricted access is desired
  • Select "List Settings"
  • Select "Permissions for this list"
  • Select "Stop Inherriting Permissions"
  • Select the group/user that restricted access is desired
  • Select "Edit User Permissions"
  • Select desired permission level

Please note that if the restricted permission level has not already been created for the site then it will need to be setup under "Site Settings" -> "Site Permissions" -> "Permission Levels".  Using this method you can allow people any combination of permissions including add/edit but not delete, add but not edit/delete, edit but not add/delete, etc.

Highlighted
Anonymous
Not applicable

Re: How to prevent employees from editing a Holiday Request SharePoint list?

The goal, and one I need also, is to force everyone to use the PowerApp and prevent anyone from editing the data in the back-end SharePoint list. Designating the PowerApp use a system account to interact with the data and setting permissions on the list so that only that system account can edit items in that list (everyone else would have permission to use the PowerApp but not have permission to the SharePoint list) is one way that this problem could be solved. I voted for KREI_CZ's idea but am open to other options as long as it meets this requirement. Otherwise, what good does investing the time to build a UI that enforces business logic which can easily be circumvented intentionally or accidentally?

Highlighted
Anonymous
Not applicable

Re: How to prevent employees from editing a Holiday Request SharePoint list?

@Anonymous

 

Using Azure SQL Server instead of SharePoint List would solve all your problems.

Highlighted
Anonymous
Not applicable

Re: How to prevent employees from editing a Holiday Request SharePoint list?

@manotheshark @Anonymous @MikeTwister 

has the answer for you. You need to create a unique permission for that list and you need to create a new permission level.

 

I solved this with creating a new permission lvl that only allows to "add entries". Of course they would be still able with a few clicks to see the data source but still they are only able to add or view them. Nothing else.

 

What I also did is filtering "All items" to "My items". If you dont know hot wo work with SharePoint you won't get the view "All items".

 

Hope that suits you 🙂

Highlighted
Frequent Visitor

Re: How to prevent employees from editing a Holiday Request SharePoint list?

Just curious if anyone has made any more progress on this? I have run into the same issue here. Pitfrog's solution is okay, except with the app the user has the ability to edit current vacation requests they have. In this instance this solution doesn't work. 

 

I looked into Azure Sql. Not sure that's going to fly with the pricing involved. Any other ideas since the last post? 

Highlighted
Frequent Visitor

Re: How to prevent employees from editing a Holiday Request SharePoint list?

Thought I would reply to myself here as I can see this working for us. 

 

https://blog.lsonline.fr/2019/02/09/hide-sharepoint-library-or-list/

 

Hide the list. I am going to try this over the next day or 2 to see if it works for us. 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

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 designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,820)