Error: You don’t have permission to associate or disassociate table contact to mk_messages

[karthik3456]

Hi

While i am uploading image and submitting form i am getting this error, You dont have permission to associate or disassociate the 

table contact to mk_messages.

I have verified the site settings and table permissions it looks good. Can anyone please resolve this issue 

[domliu]

Hi @karthik3456 ,

This error message indicate that your table permission configuration is incorrect. Please check your table permission.

Make sure the table permission has append/appendto. Make sure the logged in user has webrole that contains the table permisison you created. If still not working, I'd suggest to give yourself global permission then narrow your way down.

Cheers,

Dom

[mandela]

Check if you have SYSTEM ADMINISTRATOR access by following these steps:

1. Navigate to https://admin.powerplatform.microsoft.com/environments
2. Open the Environment, then click on Settings at the top.
3. Expand Users, select User, then select the User.
4. Click Manage Roles and make sure you have SYSTEM ADMINISTRATOR access.

If this doesn’t resolve your issue, please refer to configuring table permissions in power pages

[ragavanrajan]

Hi @karthik3456 

I can see there is an active relationship from contact to your custom table (mk_messages).  Please see the screenshot below. This is a known issue 

Official URL: Please click here

To solve this error, you need to use fetch XML in the OData query or check the alternative below. 

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

[karthik3456]

The table permissions  also i changed to append and append to and also checked on manage roles user is having system administrator permission but still issue is not resolved

[karthik3456]

I have checked the system administrator access is there for that user

[karthik3456]

Contact table is having table permission as access type global and mk_messages also having access type as global and i also tried with append and append to , even for that it is not working, could u please give any alternative solution for this.

[domliu · Accepted solution]

hi @karthik3456 ,

Can you try to give yourself the global access for all previleges, set this to both contact and mk_messages table 

----------------------
If you enjoy this post, click the thumbs-up button. If it helped you, mark it as a solution so others can find it easily.

Cheers,
Dom

[karthik3456]

Hey Thanks It got worked for me I Have given roles for the messages table Authenticated Users and Anonymous users, then later on I would be able to submit the form.

[domliu · Accepted solution]

Hi @karthik3456,

Glad to hear that it is working, like i said its 100% related with your table permissions. Now for a user that has global access to those two tables may not be the best options, even though you can successfully submitted the form now. You might want to dig into a bit more and try narrow your way down by reduce your permission.

----------------------
If you enjoy this post, click the thumbs-up button. If it helped you, mark it as a solution so others can find it easily.

Cheers,
Dom