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

47 REPLIES 47

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
Solution Supplier
Solution Supplier

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 Patron
Post Patron

@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

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,613)