With(
{
selDepartmentHeadId: LookUp(Department,ID = DataCardValue16.Selected.ID).'Department Head'.Id
},
LookUp(Users, ID = selDepartmentHeadId)
)
LookUp(
SecondListName,
DepartmentField = DataCardValue46.Selected.department,
HeadField
)
WarrenBelz
89
Most Valuable Professional
MS.Ragavendar
60
stampcoin
48