I have created a Microsoft form that employees use to request items for purchase. It uses branching to request additional items since repeated tables in not in forms. Employees select their immediate supervisor, 2nd , 3rd and final approver from a list of names. I need to convert the name selected to the email address of the approver then start and wait for an approval and outcome before it goes to the next approver. Depending on the person's rank in the department it is routed to specific people and in some cases may be no approver (none) in second or third. I have figured out the approval piece but cannot figure out the converting name to email address.
