Forum Discussion
You don't have permission to create a row - SharePoint list, new item via PowerApp Form
Hi there,
We have a Communications Team SharePoint site, we created a simple list, we created a PowerApp form.
When tested by two users one could add a row to the SharePoint list, but the other go the "you don't have permission to create a row" error when using the PowerApp form.
We've tried lots of permissions changes and variations but don't have a solution. Please let me know what you think we could do to solve this.
The one thing that looks strange is seen when checking the permissions for the user who gets the error, using the List's "check permissions" button. This user has a deny - add and customize pages permission.
BUT
The second user who can add an item via to the list using the PowerApp form has the same permissions when checked in the same way.
Here is the input form (super simple)
Here is the error one of the users get
We've tried
- removing and re-adding the sharepoint list to the PowerApp. Didn't fix the issue.
- using set-sposite -identity https://ourtenant.sharepoint.com/sites/oursite -DenyAddAndCustomizePages $false didn't resolve the issue
- checking https://OurTenant.sharepoint.com/sites/OurSite/_layouts/15/role.aspx?Source=https%3A%2F%2FOurTenant%2Esharepoint%2Ecom%2Fsites%2FOurSite%2F%5Flayouts%2F15%2Fuser%2Easpx we found
Full and had the folllowing ticked
Add and Customize Pages - Add, change, or delete HTML pages or Web Part Pages, and edit the Web site using a Microsoft SharePoint Foundation-compatible editor
and Read had it unticked
Changing these didn't solve the issue.
Many thanks for your help
Only other thing I can think of is to check who the original creator of the app was and whether they have appropriate permissions to access the list.
In the form (referring to image 2 of your simple form) in the ... menu > Customize with PowerApps and in PowerApps click onto the View tab > Data sources.
In the left side Data sources pane, under In your app, hover your mouse over the SharePoint list and see who the connection belongs to.
It may be that the creators permissions are not quite right and may need adjusting.
Otherwise if still nothing, you can also try the experts at the dedicated PowerApps forum who are mind blowingly amazing at this stuff.
https://powerusers.microsoft.com/t5/PowerApps-Community/ct-p/PowerApps1
See how you go?
Good luck
Damien
3 Replies
In the Lists permissions, are the two users in the Members group with Edit access? If not you may want to add the affected user into the Members group and see if that helps.
The image you show of permissions appears to show a user who has full rights (Owner) so that shouldn't be an issue, unless it's of the affected user?
Cheers
Damien
thanks for the reply.
We have tried the two users , as members of the Members group. Same error for one of them as I've documented.
The screen shot is of the impacted user when they were a member of the Owners group. Which also gave the same error I documented.
Dorje
Only other thing I can think of is to check who the original creator of the app was and whether they have appropriate permissions to access the list.
In the form (referring to image 2 of your simple form) in the ... menu > Customize with PowerApps and in PowerApps click onto the View tab > Data sources.
In the left side Data sources pane, under In your app, hover your mouse over the SharePoint list and see who the connection belongs to.
It may be that the creators permissions are not quite right and may need adjusting.
Otherwise if still nothing, you can also try the experts at the dedicated PowerApps forum who are mind blowingly amazing at this stuff.
https://powerusers.microsoft.com/t5/PowerApps-Community/ct-p/PowerApps1
See how you go?
Good luck
Damien
