Error occurred on the server. Server response: Access is denied (Exception from Hresult: ....)

[tomgardzinski]

Can anyone provide any tips on the following error after users receive this error?

This only happens when other users (not me) are using the powerapp. I have ensured that users have edit capabilities to the sharepoint list that is being used as the datasource.

Any help or pointers would be greatly appreciated.

[Anonymous]

Hello, this sounds like the app user does not have access to the datasource(s) used within the app.

[tomgardzinski]

I have ensured users have at minimum "contribute" access to the sharepoint list.

[Anonymous]

Do they also have access to the SharePoint site which the list is part of?

[tomgardzinski]

Yes

[TopShelf-MSFT]

adding in @Audrie-MSFT to assist with this error message question

@TopShelf-MSFT

[Audrie-MSFT · Accepted solution]

This is a server error (from the data source). Please check the following to clear up the error:

1. Check that the user(s) receiving the error have the appropriate rights to the record. This goes beyond just having access to the site and the list, it also involves ensuring they have the correct rights for what they are attempting to do with the data (such as edit, delete, create records). In this case, any files that are locked (such as in-place records) would also return this message.

2. Check that the app is not attempting to load supplemental data which the app consumer may not have access to. This occurs often in OnStart and OnLoad expressions if you are building collections while screens are loading. Remember, the end user must have access to all of the data connections in the app, expecially those involved in submit or patch functions to avoid unexpected server-side errors (click on the View menu and then on Datasources) to review your connections.

3. You may find it helpful to check user permissions and return your own custom messages. 

Check out these docs: 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-datasourceinfo

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-showerror

Check out this video: 

https://www.youtube.com/watch?v=M_URDG2oCWE

Thank you,

Audrie