You’re offline. This is a read only version of the page.
Announcements
17
I am wanting to create an app that allows departments to request an employee number for new hires.
The downside to this is that I have to use numbers that are in our ancient HRIS. The numbers are based on department. For example, Parks and Rec employee numbers start with 8. Each time a new employee is hired, I receive an email asking me for a new employee number. It is very tedious and inefficient.
Could I create a spreadsheet with columns dedicated to available employee numbers for each department and connect it to my PowerApp? Or even a SharePoint list?
The idea is for the department to visit the app, select their department, hit a button that says "Request New Employee Number" and they are given the next available number from the spreadsheet.
I would want to probably store 150-175 numbers.
Start with a SharePoint list with columns: Employee, Department, EmployeeNumber, create a NewEmployee form, In the Department card, hide the textinput control and in put a dropdown control with its Items property: Sort(Distinct(SPlist, Department), Result, Ascending). change the Update property of the card to Dropdown1.Selected.Department.
The card for EmployeeNumber, will contain a Text input box. Make its Default property:
Share
Report
All responses (
Answers (
First(
Sort(
Filter(
SPlist,
Department = Dropdown1.Selected.Result
),
EmployeeNumber,
Descending
)
).EmployeeNumber + 1
Then make the card's DisplayMode Disabled so it cannot be changed by a user.
