Unanswered

PowerApp Solution through SharePoint List (Access Requirement)

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have created powerapp solution through sharepoint list. In that case, those members who have edit access to sharepoint site can be able to perform powerapp solution. I also have other members those have only read access, they are unable to use the solution.

When, I changed edit access control through sharepoint site and remove manage list checkbox from the access control, members those have edit access even not able to use powerapp solution.

I am looking to access control, where members can submit request through powerapp solution., but they should not be allow to delete or edit after submission the record.

Regards,

Bhavuk

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

RashmiKaushik 62 on at

Like (0)

Report

Hi @Anonymous
PowerApps Canvas app inherits Data Access Permission inherits Data Access Permission from the data source itself. If the end users could add a new record in your SP List directly then they would be able to submit new record via a canvas app to your SP List.

In default, if you assign a "Contributor" permission of your SP List to these end users, they would be able to add new items in your SP List directly. Please ask users to clear cache of their browser, then access your SP List again, add a new item, check if the issue is solved.

If the issue still exists, please consider assign a "Edit" permission of your SP List to these end users, then try it again, check if the issue is fixed.

If this post helps, then please consider Accept it as the solution

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

My user has permission of SP list to add and manage list. But, I want to give them access only to create a record, not for deleting or editing the record in SP list. Presently, they have access to delete the recod as well from SP list.

I have checked the control access permission. But when i remove manage permission, user unable to create new record through powerapp solution.

permission.PNG

Was this reply helpful? Yes No
RashmiKaushik 62 on at

Like (0)

Report
Hi
1) In your SharePoint List form, change the user permission from 'Edit' to 'Contribute.
Navigate to your SharePoint site, Click Settings cog > Site Permissions > Advanced permissions settings
Click 'Create group', give it a name and set it's access level to 'Contribute - Can view, add, update, and delete list items and documents.'
Add your users to this new group and remove them from the standard members group
2. Disable datasheet view
Navigate to the list which stores your data, Click Settings cog > list settings > advanced settings
Set 'Quick Property Editing' to No
Save
3. Configure your SharePoint list form to open in view mode for all standard users
Navigate to the list which stores your data, Click new > Customise with PowerApps
In the tree view click 'App'
In the property dropdown select 'OnStart'
Set the formula to 'Set(varMe, User())'
In the tree view click 'SharePointIntegration'
In the property dropdown select 'OnNew'
Set the formula to 'If(varMe.Email = "myAdminEmail@Outlook.com", NewForm(SharePointForm1), ViewForm(SharePointForm1))'
In the property dropdown select 'OnEdit'
Set the formula to If(varMe.Email = "myAdminEmail@Outlook.com", EditForm(SharePointForm1), ViewForm(SharePointForm1))
Save & Publish
Let me know if it helps you

Was this reply helpful? Yes No