SOLVED
Home

You don't have permission to create a row - SharePoint list, new item via PowerApp Form

%3CLINGO-SUB%20id%3D%22lingo-sub-1045436%22%20slang%3D%22en-US%22%3EYou%20don't%20have%20permission%20to%20create%20a%20row%20-%20SharePoint%20list%2C%20new%20item%20via%20PowerApp%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1045436%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20a%20Communications%20Team%20SharePoint%20site%2C%20we%20created%20a%20simple%20list%2C%20we%20created%20a%20PowerApp%20form.%3C%2FP%3E%3CP%3EWhen%20tested%20by%20two%20users%20one%20could%20add%20a%20row%20to%20the%20SharePoint%20list%2C%20but%20the%20other%20go%20the%20%22you%20don't%20have%20permission%20to%20create%20a%20row%22%20error%20when%20using%20the%20PowerApp%20form.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe've%20tried%20lots%20of%20permissions%20changes%20and%20variations%20but%20don't%20have%20a%20solution.%20Please%20let%20me%20know%20what%20you%20think%20we%20could%20do%20to%20solve%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20one%20thing%20that%20looks%20strange%20is%20seen%20when%20checking%20the%20permissions%20for%20the%20user%20who%20gets%20the%20error%2C%20using%20the%20List's%20%22check%20permissions%22%20button.%20This%20user%20has%20a%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bdeny%20-%20add%20and%20customize%20pages%26nbsp%3B%20%26nbsp%3Bpermission.%26nbsp%3B%3CBR%20%2F%3EBUT%3C%2FP%3E%3CP%3EThe%20second%20user%20who%20can%20add%20an%20item%20via%20to%20the%20list%20using%20the%20PowerApp%20form%20has%20the%20same%20permissions%20when%20checked%20in%20the%20same%20way.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F159904i0F046EC707A9A828%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHere%20is%20the%20input%20form%20(super%20simple)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F159905iA4D88D4A59A04B6B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHere%20is%20the%20error%20one%20of%20the%20users%20get%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F159906i7A5B10541EF70B9F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_2.png%22%20title%3D%22clipboard_image_2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EWe've%20tried%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E-%20removing%20and%20re-adding%20the%20sharepoint%20list%20to%20the%20PowerApp.%20Didn't%20fix%20the%20issue.%3C%2FP%3E%3CP%3E-%20using%20set-sposite%20-identity%20%3CA%20href%3D%22https%3A%2F%2Fourtenant.sharepoint.com%2Fsites%2Foursite%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fourtenant.sharepoint.com%2Fsites%2Foursite%3C%2FA%3E%20-DenyAddAndCustomizePages%20%24false%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bdidn't%20resolve%20the%20issue%3C%2FP%3E%3CP%3E-%20checking%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2FOurTenant.sharepoint.com%2Fsites%2FOurSite%2F_layouts%2F15%2Frole.aspx%3FSource%3Dhttps%253A%252F%252FOurTenant%252Esharepoint%252Ecom%252Fsites%252FOurSite%252F%255Flayouts%252F15%252Fuser%252Easpx%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2FOurTenant.sharepoint.com%2Fsites%2FOurSite%2F_layouts%2F15%2Frole.aspx%3FSource%3Dhttps%253A%252F%252FOurTenant%252Esharepoint%252Ecom%252Fsites%252FOurSite%252F%255Flayouts%252F15%252Fuser%252Easpx%3C%2FA%3E%20we%20found%3C%2FP%3E%3CP%3EFull%20and%20had%20the%20folllowing%20ticked%3C%2FP%3E%3CP%3E%3CSPAN%3EAdd%20and%20Customize%20Pages%20%26nbsp%3B-%26nbsp%3B%20Add%2C%20change%2C%20or%20delete%20HTML%20pages%20or%20Web%20Part%20Pages%2C%20and%20edit%20the%20Web%20site%20using%20a%20Microsoft%20SharePoint%20Foundation-compatible%20editor%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eand%20Read%20had%20it%20unticked%3CBR%20%2F%3EChanging%20these%20didn't%20solve%20the%20issue.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EMany%20thanks%20for%20your%20help%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1045436%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1045782%22%20slang%3D%22en-US%22%3ERe%3A%20You%20don't%20have%20permission%20to%20create%20a%20row%20-%20SharePoint%20list%2C%20new%20item%20via%20PowerApp%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1045782%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F228833%22%20target%3D%22_blank%22%3E%40Dorje%20McKinnon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20%3CSTRONG%3ELists%20permissions%3C%2FSTRONG%3E%2C%20are%20the%20two%20users%20in%20the%20%3CSTRONG%3EMembers%3C%2FSTRONG%3E%20group%20with%20%3CSTRONG%3EEdit%3C%2FSTRONG%3E%20access%3F%20If%20not%20you%20may%20want%20to%20add%20the%20affected%20user%20into%20the%20Members%20group%20and%20see%20if%20that%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20image%20you%20show%20of%20permissions%20appears%20to%20show%20a%20user%20who%20has%20full%20rights%20(Owner)%20so%20that%20shouldn't%20be%20an%20issue%2C%20unless%20it's%20of%20the%20affected%20user%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1047741%22%20slang%3D%22en-US%22%3ERe%3A%20You%20don't%20have%20permission%20to%20create%20a%20row%20-%20SharePoint%20list%2C%20new%20item%20via%20PowerApp%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1047741%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20the%20reply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20tried%20the%20two%20users%20%2C%20as%20members%20of%20the%20Members%20group.%20Same%20error%20for%20one%20of%20them%20as%20I've%20documented.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20screen%20shot%20is%20of%20the%20impacted%20user%20when%20they%20were%20a%20member%20of%20the%20Owners%20group.%20Which%20also%20gave%20the%20same%20error%20I%20documented.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDorje%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1048188%22%20slang%3D%22en-US%22%3ERe%3A%20You%20don't%20have%20permission%20to%20create%20a%20row%20-%20SharePoint%20list%2C%20new%20item%20via%20PowerApp%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1048188%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F228833%22%20target%3D%22_blank%22%3E%40Dorje%20McKinnon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnly%20other%20thing%20I%20can%20think%20of%20is%20to%20check%20who%20the%20original%20creator%20of%20the%20app%20was%20and%20whether%20they%20have%20appropriate%20permissions%20to%20access%20the%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20form%20(referring%20to%20image%202%20of%20your%20simple%20form)%20in%20the%20%3CSTRONG%3E...%20menu%20%26gt%3B%20Customize%20with%20PowerApps%3C%2FSTRONG%3E%20and%20in%20%3CSTRONG%3EPowerApps%3C%2FSTRONG%3E%20click%20onto%20the%20%3CSTRONG%3EView%20tab%20%26gt%3B%20Data%20sources%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20left%20side%20%3CSTRONG%3EData%20sources%3C%2FSTRONG%3E%20pane%2C%20under%20%3CSTRONG%3EIn%20your%20app%3C%2FSTRONG%3E%2C%20hover%20your%20mouse%20over%20the%20%3CSTRONG%3ESharePoint%20list%3C%2FSTRONG%3E%20and%20see%20who%20the%20%3CSTRONG%3Econnection%3C%2FSTRONG%3E%20belongs%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20may%20be%20that%20the%20creators%20permissions%20are%20not%20quite%20right%20and%20may%20need%20adjusting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOtherwise%20if%20still%20nothing%2C%20you%20can%20also%20try%20the%20experts%20at%20the%20dedicated%20PowerApps%20forum%20who%20are%20mind%20blowingly%20amazing%20at%20this%20stuff.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community%2Fct-p%2FPowerApps1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community%2Fct-p%2FPowerApps1%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20how%20you%20go%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20luck%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Dorje McKinnon
Contributor

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.

 

clipboard_image_0.png

Here is the input form (super simple)

clipboard_image_1.png

Here is the error one of the users get

clipboard_image_2.png

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%... 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

 

 

 

3 Replies

Hi @Dorje McKinnon 

 

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

Hi @Damien Rosario 

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

Solution

Hi @Dorje McKinnon 

 

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