Answered

Creating an employee directory

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone,

I have following Task of creating an employee Directory. I know how to open a screen and use "People". With this one I can search for everyone in my Company. But I have following restrictions or implementations I would like to add:

1. The Company did not fill out the Job Title for each employee, so when i want the Job Title to be displayed it is blank. Is there a way how I can Change this? Maybe with a SharePoint List or sth? Because I created a SharePoint List where I wrote employee names of my Department and their Job title, and what the Job title's required experience and Tasks are.

2. I want to be able to search for Job Title let's say Project Manager and see who is a Project Manager in my department

3. I dont want to have the whole Company in my employee search. Only having my Department and ist subdepartments is sufficient.

How can I implement all These Things 😞 Please someone help me.

Best Regards

Emre

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (2)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

I will answer your questions one by one.

First, yes you could use the SharePoint list which stores employee names and job titles. Only need to connect with this SP list as a data source.

For your second question, if you would like to retrieve all Project Managers in your organization, like populate into a combo box, you could set the Items property of the Combo box to:
Filter(Office365Users.SearchUserV2().value,DisplayName in Filter(YourSPlist, 'Job Title' = "Project Manager").EmployeeName)

For the last question, you could modifty above formula a bit, user your department as a search condition:
1\ In OnVisible of the Main Screen, create a variable:
Set(myDepartment,Office365Users.MyProfileV2().department)
2\ Modify above formula:
Filter(Office365Users.SearchUserV2({searchTerm:myDepartment}).value,DisplayName in Filter(YourSPlist, 'Job Title' = "Project Manager").EmployeeName)

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @v-jefferni,

okay you have to deal with me for a bit I guess. I do appreciate your effort, but I am such a newbie to this whole Thing. So I have done now following Things:
1. I have created a SharePoint List with my key employees (Name, Job Title, Department, Email Adress).
2. I opened Power Apps clicked Import from SharePoint and it already created me a search application.
3. I have set that the Information displayed is Job Title, Name, Department.
4. I have set that I can search for employee name
-> Now my new Questions:
1. I want to be able to click on the E-Mail adress of any random employee and make Outlook open and already insert this E-Mail adress I have clicked on. What would be an appropriate Code for this? Probably something with OnSelect = Navigate or launch Outlook?
2. I did not fully understand the Combo box issue? Right now when i type in the search field a Name it finds me an employee. i want to Code the search field in a such way that i can search Department, employee or Job title. It should Show me any match.
Unfortunately I cant use anything with office365users or Job titles as they have not been updated from the Company.

Best Regards and thank you!
Emre

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,
Unfortunately, for now there is no way to open outlook directly. However, you could leverage the Launch function to open the default mail app in either desktop or mobile phones.

On your end, for the first question, set On Select of ALL controls in Gallery (Labels and the arrow button) to:
Launch("mailto:" & ThisItem.'Email Adress' &"&subject=XXXXX"&"&body= XXXXXX")

Below blog would provide details about parameters you could set for the email:
https://www.c-sharpcorner.com/article/compose-outlook-email-using-mailto-inside-power-apps-form/

For the second question, you could modify the formula in Items of the Gallery to:SortByColumns(Filter(Employees,
StartsWith(EmployeeName, TextSearchBox1.Text) || StartsWith('Job Title', TextSearchBox1.Text) || StartsWith(Department, TextSearchBox1.Text) || StartsWith('Email Address', TextSearchBox1.Text)), "EmployeeName", If(SortDescending1, Descending, Ascending))
It means search all columns start with text typed in the search box, and sort by Employee Name column.

Hope this helps

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-jefferniThis did help me a lot!!!!!!!!!!!!!! Thank you.
May I ask for one more Thing? 🙂 So I have one more SharePoint List where I described each Job Title regarding Tasks, specification etc. So I want someone to be able to click on the Job Title of someone they searched for in Power Apps and Redirect them to the exact row of the other SharePoint list where I described the Job title. Is this possible? Maybe working with links? Something like OnSelect and then Navigate to this link if Job Title = Project Manager || Navigate to another link if Job Title = Finance and so on.
Thank you very much in Advance 🙂

Best regards
Emre

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

If I understand correctly that you would like users to navigate to another screen with a Gallery with items of a list "Job Title", you could set OnSelect of the 'Job Tilte' Lable inside the Gallery to:
Navigate(JobTitleScreen,ScreenTransition.None,{JobTitle:ThisItem.'Job Title'})

Then in JobTitleScreen Gallery, set the Items of the Gallery to:
Filter('Job Titles', 'Job Title' = JobTitle) //'Job Titles' is the list name, 'Job Title' is the column name, JobTitle is the variable from Navigate function

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @v-jefferni,
first of all thanks for your commitment to help me. My Supervisor was thrilled so far. But unfortunately I could not do the Gallery Thing. So the SharePoint List with the Job Titles consist of These columns: Title, Tasks, Responsibility, Skills, Further Information.
So you want me to have a new screen and Import this data into it? So which type of screen should I use when I want to make a new screen? (view attachment). Then you want me to open a Gallery and Import the data of the SharePoint list in it? Maybe this would clarify the Situation a bit for me.

Thanks in Advance.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

That list type screen is fine, it includes a Gallery by default.

Then you will need to add the other SP list into Power Apps as another data source:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-online#add-data-to-an-existing-app

After connect to this list
1\ modify the screen name to JobTitleScreen.
2\ follow up my last post.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @v-jefferni
That just worked perfectly for me! 🙂 Wow I am really impressed. So what I did now is I have also created a Details List. So when I click on the Job Title it Shows me in a different list the Name of the Job Title and there I can click on an arrow which brings me to another List with Information on Title, Tasks, Responsibilities etc. Is there a way that I can have a button to Transfer These Details into Excel or better Word? (View attachment to see which Information I am Talking About). Can I furthermore have a presetting like defining the Header and footers of this Word document?
2. Question: So I typed in the employee names and email adress in my SharePoint list manually. Can I also add an profile Picture which is taken by office365 users? Maybe something like If email adress is equal to an element in Office365 Users use the profile Picture? 🙂
Thank you very much you are great!!!!

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

The answer to your first question would refer to Power Automate. In Power Apps studio, you could find Action -> Power Automate in command bar:
it would lead you to a pane that let you select flows in your organization. You can choose to create a new flow at the bottom of the pane.

If you choose to create a new flow, then you would go to Power Automate studio, create an instant cloud flow -> trigger from power apps. I have a test flow just meet your need:

You could refer to below discussion, video links in it are very helpful:
https://www.powerplatformug.com/communities/community-home/digestviewer/viewthread?MessageKey=0cc19b79-17e7-417b-8785-069fd03a2404&CommunityKey=5c267d03-430a-4007-8630-2e0a6c38e85e&tab=digestviewer

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @v-jefferni ,
I know I am keeping you busy but I really appreciate your help. So my Company apparently blocked the flow for MS Windows. I have Excel Online available. Could you Show me when I use the List Screen and from there go to a Details Screen in my search how to create a simple Excel Table from this specific search item.
Thank you!

Was this reply helpful? Yes No