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

Powerapps and Sharepoint Online Permissions

Hello,

 

I created a PowerApp with a Sharepoint custom list as the data source. I granted all 315 users of the app "Site Member" status (R/W/E). 

 

Problem

  • The PowerApp has a LOT of validation in place (no blanks, min char counts for comments, etc.)
  • The Sharepoint URL leaked out and users have been creating new records DIRECTLY in the Sharepoint list instead of using the PowerApp
  • This has resulted in many partial records that make reporting impossible. 


Question

  • How can I grant the correct permissions to allow users access to the Custom List but NOT give them permission to edit the Sharepoint list directly if they have the URL?

 

Thank you

48 REPLIES 48

Hi @WarrenBelz , where are you seeing all these checkboxes? If I go to:

1. Gear Icon

2. Site Settings

3. Site Permissions

4. Create a new group ('test')

 

I'm only given permission level checkboxes (Read, Edit, Contribute, etc.). 


Where are the granular controls you show above?

 

Hi @ericonline ,

You need control of the site (parent site if you are working on subsites), then as below
Gear icon > Site permissions

WarrenBelz_0-1625086734335.png

Advanced permission settings

WarrenBelz_1-1625086780994.png

Permission levels

WarrenBelz_2-1625086808145.png

Add a permission level (then you will get the screen I posted earlier)

WarrenBelz_3-1625086837841.png

 

 

 

 

panand99
Impactful Individual
Impactful Individual

Hi,

 

You can also prevent users from creating new records by -

1) Create new powerapps app by 'customize forms' from sharepoint list.

2) On your SharePointForm, remove all fields and create new label 'Please use Powerapps <link to the powerapps> to create/edit record"

 

This will prevent all users from directly create/edit/view records from the list.

 

Please reply if you have any further questions.

 

Thanks,

Prashant

 

ericonline
Community Champion
Community Champion

The issue with this approach is that you need an additional Sharepoint-customized-form-PowerApp for each Sharepoint list. 

 

When a Stand-alone PowerApp has, say, 4 lists associated with it, you now need 4 additional PowerApps to support this approach. This can get complex quickly and it creates unnecessary apps in the environment as each Sharepoint customized form is actually a PowerApp.

twister
Post Partisan
Post Partisan

@WarrenBelzcan u share to me how to use this custom permissions? I've already create new custom permission "Power Apps Field Users" as your advise but i dont know how to use/share this permission to users within organization.. thanks

@twister ,

You need to share the list/ site with a group using that permission level.

@WarrenBelzthere is no selection for new perimssion..

 

twister_0-1626149880860.png

 

twister_1-1626149964401.pngtwister_2-1626150014069.png

 

@twister ,

Go into Advanced Site Permissions

IbrarAhmad12
New Member

This will Help you.

use this on Gallery

Fiter('sharepointtablename','Created By'.Email = User().Email)

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,338)