Hello, so I have a couple of tables in Dataverse and I'm doing a soft-delete function (just setting a status to inactive).
Roles - List of available roles when onboarding.
Documents - List of available documents when onboarding.
RoleDocuments - Mapping of roles to documents (both just lookup columns)
Role 1 - Doc 2
Role 1 - Doc 4
Role 2 - Doc 1
Role 2 - Doc 2
I was already able to do the patching for direct deletes (deleting an item in the documents/roles table).
However I am having some trouble with deleting the associated roles/documents in the RoleDocuments table when I am deleting a Role/Document. Not sure if I'm making sense but if I delete Doc2 then the mapping of all roles with doc2 on them should be inactive as well.
This is the first thing I tried but it says that the function cannot operate on the same datasource. I did see on another answer that I can just rename the ID column differently to make it work so it did, however it only updates one row in the RoleDocuments column. Any help would be appreciated!