My team has two separate flows feeding into each other - the first one funnels request form responses into an excel table & sharepoint list, and the second one checks the excel sheet every minute to see if there's been new responses; if so, and if the requested date is within a certain time-frame from now, it auto-creates a planner task with the information in that table's row.
We self-assign the tasks once they populate into planner, but are looking to add a column to the table that would auto-assign based on the information therein. For example:
1.) We want this task to be assigned to John Smith, so we put "JS" into the column and it auto-assigns once it populates in planner.
2.) Both John Smith and Mary Brown are going to work on this task, so we put "JS/MB" into the column and it auto-assigns to both.
I can think of solutions that are granular -- i.e. conditionals like "If (value Owner/Assigned) contains (variable Initials), Create a task w/ Assigned User Id", but that would require a different "Create a task" step for each individual.
Any ideas on how to move forward with this? I appreciate any and all input, thank you in advance!