Unanswered

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

(1) Share

Report

Posted on by karthik3456

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

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (2)

domliu37 314 Super User 2024 Season 1 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Akah Mandela 445 on at

Like (0)

Report
Check if you have SYSTEM ADMINISTRATOR access by following these steps:
Navigate to https://admin.powerplatform.microsoft.com/environments
Open the Environment, then click on Settings at the top.
Expand Users, select User, then select the User.
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

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
karthik3456 17 on at

Like (0)

Report

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

Was this reply helpful? Yes No
karthik3456 17 on at

Like (0)

Report

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

Was this reply helpful? Yes No
karthik3456 17 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

domliu37 314 Super User 2024 Season 1 on at

Like (1)

Report

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

Was this reply helpful? Yes No
karthik3456 17 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

domliu37 314 Super User 2024 Season 1 on at

Like (1)

Report

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

Was this reply helpful? Yes No