if(
and(not(empty(item()?['Surname'])), not(empty(item()?['FirstName']))),
concat(item()?['Surname'], ' ', item()?['FirstName']),
if(
not(empty(item()?['Name']?['DisplayName'])),
if(
contains(item()?['Name']?['DisplayName'], ','),
concat(
trim(first(split(item()?['Name']?['DisplayName'], ','))),
' ',
trim(last(split(item()?['Name']?['DisplayName'], ',')))
),
concat(
last(split(item()?['Name']?['DisplayName'], ' ')),
' ',
first(split(item()?['Name']?['DisplayName'], ' '))
)
),
''
)
)
Select Employees
From: outputs('GetTeamMembers')?['body/value']
Map: FullName
Value: item()?['field_1']
Map: ManagerEmail
Value: item()?['Manager']?['Email']
Filter NoSubmission
From: body('Select_Employees')
Filter Query:
not(
contains(
toLower(string(outputs('Select_SubmittedNames'))),
toLower(concat('"FullName":"', item()?['FullName'], '"'))
)
)
Filter ValidManagers
From: body('Filter_NoSubmission')
Filter query:
and(
not(empty(item()?['ManagerEmail'])),
contains(item()?['ManagerEmail'], '@')
)
Select ManagerEmails
From: body('Filter_ValidManagers')
Map: Email
Value: item()?['ManagerEmail']
DistinctManagers
Inputs:
union(outputs('Select_ManagerEmails'), outputs('Select_ManagerEmails'))
Apply to each
outputs('DistinctManagers')
Filter EmployeesForManager
From: body('Filter_ValidManagers')
Filter Query:
equals(
toLower(item()?['ManagerEmail']),
toLower(items('Apply_to_each'))
)
Select 2
From: body('Filter_EmployeesForManager')
Map: Name
Value: item()?['FullName']
