Add user from O365 by job title

(1) Share

Report

Posted on by Timm1

301

Hi there. I'm building a phone list in PowerApps. Looking good so far but I would like to add the department's director in a Text Label by searching the Job Title. I found a way to do this in a Gallery by using the Filter formula but wonder if it is possible to have it show up in a Text Label. Example, in a Text Label, I want it to show who the "Finance Director" is.

Thank you for your time.

Tim

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (3)

Report
Hi

Its hard to truly answer because you don't mention how the Department is selected, so that it shows the correct departments Director. And are you talking about having it in the Gallery (like every line will show the same value?? or outside the gallery?)

Since I don't know the answers I will give you the pseudo answer

In the Labels, Text property

Where I have Department = Test put whatever value you have there from a text box or gallery or somethying and change JobTitle

LookUp(Office365Users.SearchUser(), Department = "Test" And JobTitle = "Finance Director").DisplayName;

Was this reply helpful? Yes No
Timm1 301 on at

Like (0)

Report

Thank you FLMike

Was this reply helpful? Yes No