Unanswered

Users Office 365 searching users with email manager equals 'manager@microsoft.com'

(0) Share

Report

Posted on by Jonas_Cruzrj

Hi, I need to search my company's Office 365 database for all employees whose manager has the email 'manager@microsoft.com'. And then I will research each employee's birthday. However, my company has many employees and therefore, I need to do this filter first to reduce the search and make the flow more efficient. Please, can anyone help?

Categories:

Building flows

All responses (12)

Answers (0)

Sort by

schmid1208 87 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello @Jonas_Cruzrj,

Thanks for your question! Try adding a Filter Array action, where you take the "value" dynamic content from your search then take the email and set it equal to your Manager@Microsoft.com. Then, use your apply to each to find their Birthday. By adding the filter array action, it'll eliminate the number entries the apply to each action has to go through. See the screenshot below for assistance!

I hope this helps, and hope you have a great rest of your day!

Accept the solution if this helped and worked!

-Reid
DJ_Jamba 2,837 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Jonas_Cruzrj
Login to Graph Explorer and try the following end point:

https://graph.microsoft.com/v1.0/users/manager@microsoft.com/directReports?$top=999

What do you get?
Jonas_Cruzrj 14 on at

Like
a
(0)

Report
Copy link

Link copied!

In fact, I need to know the people whose manager has the email manager@microsoft.com. Your suggestion will bring people who have the email manager@microsoft.com and that's what I need.
schmid1208 87 on at

Like
a
(1)

Report
Copy link

Link copied!

@Jonas_Cruzrj, apologies I miss read your original message. Regardless, what I suggested should still work for you because it’ll return individuals who have that email particular email address. Then, if you want to get employees that report to that manager simply add the get direct reports action which will return the employees that report to that manager. Is that what you’re looking for?

-Reid
Jonas_Cruzrj 14 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes, that is it.
schmid1208 87 on at

Like
a
(1)

Report
Copy link

Link copied!

@Jonas_Cruzrj, that’s great! Let me know if you run into any additional troubles in testing, etc.
Jonas_Cruzrj 14 on at

Like
a
(0)

Report
Copy link

Link copied!

It doesn't work yet, sorry.
"Flow saving failed with code 'InvalidTemplate' and message 'Template validation failed: 'The repeating actions 'Apply_every_4' referenced by 'inputs' in the action 'Filter_array' are not defined in the template.'.'.
I tried:
1) Search users
2) Get the manager's email
3) With the manager's email, I used the list filter to compare with the manager's email of the team I want to select.
4) Based on this manager filter, I asked to Get user profile and finally display the user's birthday.
schmid1208 87 on at

Like
a
(0)

Report
Copy link

Link copied!

@Jonas_Cruzrj, Thanks for sharing your screenshots! Let me quickly build the flow, then I’ll share the screenshots so you can copy it over to yours. That might be easier.
schmid1208 87 on at

Like
a
(1)

Report
Copy link

Link copied!
DJ_Jamba 2,837 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Jonas_Cruzrj
Did you check graph explorer?
If you don't want to loop through thousands of users via an apply to each (very slow) method to get birthdays, I can show you a very fast method using graph api.
Just @mention me if you're interested