Hi @Moores35TFL ,
Assuming there is one Approver per Department in your SharePoint list and the Combo Box is a single select control:
If Department is a SharePoint Choice field:
LookUp(
'Your Data',
YourComboBoxValue.Selected.Value = Department.Value,
'Your Person Column'.Email
)
If Department is a Single Line Text field:
LookUp(
'Your Data',
YourComboBoxValue.Selected.Value = Department,
'Your Person Column'.Email
)
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
