Custom-list application need to add new item request, the cost center manager column lookup for people/group to update the new item requestor’s immediate manager. The email sent for approval to the manager name which is selected in the cost center manger column. How to setup the workflow in SharePoint Designer
Have you tried doing this in Microsoft Flow?