Hi @Dries2 ,
Here is an idea for you. First, your 3 lists:
Employees
Instructions
Employees_instructions
For this last one, I added a 'Signed' column to control the instructions that were already received by the employee (it a 'Yes/No' data type).
Step 1 - Flow trigger
Your flow will start with a trigger 'When an item is created', from SharePoint connector. You will populate the trigger with the 'employee' SharePoint List and it will run automatically for any new item that you insert in the employee List:
Step 2 - Check the job title instructions
For each new employee added to your SharePoint List, you will inform the 'job title'. So you will add a 'Get items' action in your flow (be careful, because there is also an action called 'Get Item', without 's'), to filter all instructions related to the job title of the new employee.
For doing this, you will select the 'instructions' list, and pass the following expression in the Filter Query: ColumnName eq 'Job title'. Make sure to pass the 'Job title' as dynamic value and to let it inside simple quotes. Also, make sure to edit the column name according to your specific case (in my List, the column is named as 'Title', as you will see below). the 'eq' operator means 'equal', so you will be basically filtering the 'instructions' List for all records where 'job title' equals to the position of the new employee.
Also, if you do not see the filter query, click in 'Show advanced options'.
Step 3 - Loop the instructions output and populate employee_instructions List:
Finally, you will run all records found in your 'Get items' action and apply a new row into employee_instructions List for each one of them, combining data from both lists. For doing this, you will add a loop ('Apply to each' action) and pass the 'value' property from 'Get Items' as source.
Inside the loop, you will add the action 'Create item', select your employee_instructions List and populate each field with the dynamic properties from the previous actions: the employee name (in my case, named 'Title') and job title from the trigger (employee List), and the Instruction from the instructions List.
Final result
After adding 'George' as 'Operator' in your employee List, the employee_instructions list may look like this:
Let me know if it works for you or if you need any additional help!
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
