cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JackCuba
Frequent Visitor

User permission on Sharepoint and PA

Is there a way I can block/restrict the users from writing to a sharepoint list from Sharepoint itself? I only want them to do so through my app. 

Thank you for your help!

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Community Support
Community Support

Hi @JackCuba ,

 

My thought:

1. Customize the form by PowerApps, Apply authentication mechanism to configure your SharePoint list form to be opened in view mode for some of the users.

Set App.OnSelect:

Set(CurrentUser, User())

Set SharePointIntegration.OnNew property: 

If(CurrentUser.Email in ["User1@Outlook.com", "User2@Outlook.com"], ViewForm(SharePointForm1),NewForm(SharePointForm1))

Set SharePointIntegration.OnEdit property:  

If(CurrentUser.Email in ["User1@Outlook.com", "User2@Outlook.com"], ViewForm(SharePointForm1),EditForm(SharePointForm1))

2. Disable datasheet view, Navigate to the list, Click Settings cog > list settings > advanced settings, Set 'Quick Property Editing' to No

Then user1 and user2 have no permission to write data back to the list in SharePoint site.

Hope this helps.

Sik

View solution in original post

1 REPLY 1
v-siky-msft
Community Support
Community Support

Hi @JackCuba ,

 

My thought:

1. Customize the form by PowerApps, Apply authentication mechanism to configure your SharePoint list form to be opened in view mode for some of the users.

Set App.OnSelect:

Set(CurrentUser, User())

Set SharePointIntegration.OnNew property: 

If(CurrentUser.Email in ["User1@Outlook.com", "User2@Outlook.com"], ViewForm(SharePointForm1),NewForm(SharePointForm1))

Set SharePointIntegration.OnEdit property:  

If(CurrentUser.Email in ["User1@Outlook.com", "User2@Outlook.com"], ViewForm(SharePointForm1),EditForm(SharePointForm1))

2. Disable datasheet view, Navigate to the list, Click Settings cog > list settings > advanced settings, Set 'Quick Property Editing' to No

Then user1 and user2 have no permission to write data back to the list in SharePoint site.

Hope this helps.

Sik

View solution in original post

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

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

Experience what’s next for Power Apps

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

Users online (59,973)