Many to Many Update Actions Unauthorized

Get Help
1

Hello community. I have a many to many relationship that every time I try to update, I get a “Unauthorized” message.

To give context:

  1. The relation ship is between the “Users” collection and another one called “Questions Lists”.
  2. I’ve created a list of “Users” that when clicked on, updates the “Questions Lists” collection adding the current User (the user shown in the Users’ list).
  3. Every time I click to a User from that Users’ list, I get the message “Unauthorized”.
  4. I’m able to add users to the “Questions Lists” manually from the backend, but I would need this to be done by the users of the app.

I’ve also noticed that this is something that happends with other many to many relationships that I’ve tested.

I’ve search for information here in the forum and in the Adalo’s information library, but I can’t find an answer to that.

Does anyone know a solution to that?

Thank you very much.

2

Hello! Please can you try “as a test” to do the same relationship between the users and another collection? And let me know the results.

This way we can identify the source of the issue.
Please let me know once you try it.
Thank you!

3

Done. And thank you for your help Ali-Bazzi :+1:.

The test I’ve done is:

  1. Create a many to many relationship between “Users” and “Animals”
  2. Create a list of “Animals” that when clicked, Updates the “Animals” collection adding the “Logged-In User” to the current animal (the one click on on the list).
  3. Everytime I click any animal, I get the “Unauthorized” message and the animal is not added to the user.
  4. I’ve also tryed to change the action to update the “Users” collection (instead of updating the animals collection) adding the current animal to the “Logged-In User”. And the result is the same.

And by the way, I’ve checked the permissions of the collections all are set to “anyone can view, create, update and delete”.

I’ll keep trying things.

Any more ideas meanwhile?

Thank you!

4

By the way @Ali-Bazzi, in case it helps in anything, I’ve done the same test in a new app for tests and it has worked.

So I can update the many to many relationship without problems there, but not in my app.

5

Okay, finally I’ve cloned the app and now it works :+1:

6

Hello! It looks like there was an issue with the collection in the app. I’m glad to hear that it’s working correctly now in the cloned app.

Please let me know once you have any questions.
Thank you!