Make array with employees that shared same manager

[TonjeWaa]

I am sending out an email to all the managers of the employees in a SharePoint list. Some have the same manager. In the email, I am going to have the names of the employees of the manager, separated by comma. 

Every employee has a row in a SharePoint list with the name of the manager. 

How can I get the information that I need to make this work?

[v-LilyW-msft · Accepted solution]

Hi @TonjeWaa 

Do you want to send every manager an email with all his employees?

If the names of these managers are unique in your organization, you can refer to the screenshot below.

This is my test list.

Flow in details.

Exoression:

items('Apply_to_each_2')?['Employees/DisplayName']

Expression:

substring(outputs('Compose'),0,sub(length(outputs('Compose')),1))

Save and test the flow.

After flow runs, managers will each receive an email.

Hope the content above may help you.

Best Regards

If my answer helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TonjeWaa]

Thank you so much - this worked beautifully 😃

[TonjeWaa]

One more thing. I need to only get participants that have to true/false fields set to false. I have tried to filter the "Get items", but it doesn't work. Maybe because it is too many filters? I have to filter on 3 things. Do you have a suggestion?

[v-LilyW-msft]

Hi @TonjeWaa 

Could you provide me the configuration of your Filter Query in Get items?

Best Regards.

[TonjeWaa]

Here it is:

The first one is a parameter that you give when you start the flow, the to others are yes/no fields. (Ja=yes, Nei=no). I have tried with true/false, but same outcome. Nothing gets returned. 

[v-LilyW-msft · Accepted solution]

Hi @TonjeWaa 

When column is a Yes/No field you want to filter query, Yes/No Columns be evaluated as 1/0.

So please try:

Best Regards.

[TonjeWaa]

Thank you so much for your help - again!! Hehe