Unanswered

Return AD Properties filter by OfficeLocation

(0) Share

Report

Posted on by send2mark

505

I have not been able to get all the properties I need using MS Graph Explorer. Is there another way in Power Automate to only pull from a certain office location and get the displayName, Employeeid, and Manager?

I think want to put the results into an Excel sheet.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Show your GRAPH request.

Was this reply helpful? Yes No
send2mark 505 on at

Like (0)

Report
Copy link

Link copied!

I found a workaround, but if you want to take a crack at the graph explorer request here it is. https://graph.microsoft.com/v1.0/users?$expand=manager($levels=max;$select=id,displayName)&$select=id,displayName,employeeid&$count=true

Was this reply helpful? Yes No
Expiscornovus 33,480 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @send2mark,

I think this is the combination of the advanced query and the $expand query parameter which makes it challenging.

As far as I am aware the $expand is not allowed with advanced queries like this. See the note section in this article:

https://learn.microsoft.com/en-us/graph/aad-advanced-queries?tabs=http

Without the $expand it should be possible to retrieve users from a specific officeLocation:

https://graph.microsoft.com/v1.0/users?$filter=officeLocation eq 'Scranton'&$select=id,DisplayName&$count=true

Don't forget the ConsistencyLevel header with the eventual value.

Was this reply helpful? Yes No