How can I use an automation to take someone from a people column and assign them to the item?

I have an approval workflow board and form. Staff fills out the form and enters in 1-3 approval people as “person 1”, “person 2” etc.

The approvals need to happen sequentially, so I don’t want everyone assigned from the beginning. It should only be when it’s their turn.

I’d like to have an automation that says “assign person #1 as Next Approver” on item creation. Then “When approval #1 is done, assign person #2 as Next Approver” etc. (Using Assignments so that the task shows in their My Work.)

But the stock automation for assign/re-assign can only choose specific people in my company, not the people column from the form submission.

So for now, I have to hard code the approval chains for each department, setting up the automations with specific people at each step.

Anyone have a cool idea for how to dynamically assign people at each step based on the form submission?

Thanks

1
7 replies