Hi all
I've created a list workflow which changes the permission of each item when created or modified based on information from another list. I'm now trying to find the best/easiest way to run the workflow on the affected items every time there is a relevant change on the other list.
A bit more in detail:
List A contains a responsible and deputy person for each company. List B contains among other information the company from List A. The workflow on List B changes the permission of the item based on List A, so that only the responsible and deputy from that company can view and edit the item. If some day the responsible person changes in List A, the workflow need to run on each item which contains the affected company to adjust the permission.
Can someone please give me a hint how to achieve that the best way?
Thanks & best regards
Markus