Auto assign a planner task to a list of project team members dependent on a project code


I have created a flow that creates a planner task when an email is flagged through Outlook, however I would like the task to be auto-assigned to a team member dependent on the project code that they are responsible for.


For example, Lucy is responsible for project code 1008 and Stephanie is responsible for project code 2008. When a planner task is created it pulls the subject line from the email which is the project code. 


I assume I need to create a SharePoint list which I have done and includes their names and email addresses, however I am unsure how to create a flow to reflect this. 


Please could someone help? 



2 Replies