i've reached a dead end with linked lists in SharePoint Online: I created two Lists "Tasks" and "Data". The Data list has a unique Identifier (ID-Number) that is used by tasks to connect tasks (often up to 20 tasks per data element) to data elements.
I would like to write a Workflow (or script) to query all persons who are asigned to a task, related to a specific data element and create an outlook meeting invitation email with these persons as recipients.
Has anybody here done something similar? I'd apreciate your help! Thanks, LS