Answered

Get User.DisplayName by JobTitle and OfficeLocation

(1) Share

Report

Posted on by FS-30090618-0

Hi All,
I'm creating a form in powerapps and for approvals I need the name of the "Operations Manager" in either one the OfficeLocation "Sydney", "Brisbane" and "Perth".

 
LookUp(
        Office365Users.SearchUser({searchTerm: ""}),
        JobTitle = "Local IT" && OfficeLocation = "Maarheeze"
    ).DisplayName
 
This works but has limit of 100 users and in those 100 users non have "office location" of syd, bris, and perth and none are "Operations Manager".

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

developerAJ 4,763 on at

Like (2)

Report
Copy link

Link copied!
Use Graph API or Power Automate to get all users with the job title

Office365Users.HttpRequest( "https://graph.microsoft.com/v1.0/users?$filter=jobTitle eq 'Operations Manager'", "GET", "" )

Process the response in Power Apps (via JSON()) or Power Automate.

Filter locally for officeLocation in your desired values (e.g., "Sydney", "Brisbane", "Perth").because officelocation is not filterable using graph

This approach bypasses the Graph API limitation, giving you the correct subset of users for your approval logic.

If this solution helped you resolve your issue, kindly mark it as accepted — it makes it easier for others to find and also closes the discussion. If you found it useful, a Like ❤️ would be greatly appreciated!

🤝 Let’s connect on LinkedIn || 📘 Explore more on my articles

2 people found this reply helpful.

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like (0)

Report
Copy link

Link copied!

Please let us know if the issue still exists. If it has been resolved, kindly close the thread by accepting the solution

If this solution helped you resolve your issue, kindly mark it as accepted — it makes it easier for others to find and also closes the discussion. If you found it useful, a Like ❤️ would be greatly appreciated!

🤝 Let’s connect on LinkedIn || 📘 Explore more on my articles

1 people found this reply helpful.

Was this reply helpful? Yes No
WarrenBelz 155,283 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @FS-30090618-0,

I will throw in this - I cannot test it as I do not have a tenant that big, but it may work for you.
Filter( Office365Users.SearchUserV2( { IsSearchTermRequired: false, top: 999 } ).value, JobTitle = "Operations Manager" && OfficeLocation in ["Sydney", "Brisbane", "Perth"] ).DisplayName

Was this reply helpful? Yes No