Skip to Content

Case Study

Power Apps Solution Maps 40,000 Job Titles
Technologies Supported: Power Apps Power Automate SharePoint
Team members laughing together at a table with laptops and coffee

Reassigning job titles for 40,000 employees by hand wasn’t an option. IncWorx built an intuitive Power Apps tool using technology this consulting firm already owned, mapping every title accurately and fast.

The Challenge

A Need for a Solution That is Automated, Accurate and Easy to Use

The customer was facing the daunting task of mapping over 400 new job titles to over 40,000 of its employees. The mapping of job titles was not one-for-one and required human intervention for the verification and approval of each new job title assignment.

The customer recognized the need to automate the process wherever possible and to provide management an easy, intuitive means of performing the mapping. Their intention was to complete the mapping of job titles quickly and accurately without causing undue hardship or disruption to the management team.

The Solution

Create an Intuitive Tool Using Existing Tech

IncWorx performed a thorough analysis of the customer’s requirements for mapping the new job titles to each employee. We developed and executed the plan to create a temporary solution for performing the mapping by management through leveraging PowerApps, SharePoint Online, and Power Automate.

Some highlights of the solution include:

  • PowerApps canvas app for easy access and intuitive controls
  • SharePoint Online for storing and securing the results of the mapping exercise
  • Power Automate for keeping the data in sync with the backend HR system
  • Delegated filtering to avoid data threshold-related issues
  • Mapping recommendations to speed job title selection
  • Secured access limiting management to direct reports only
Overhead view of a man relaxing on a couch with a coworker sitting nearby

The Results

Accurate Mapping of 40,000 New Job Titles

Upon completion of the temporary solution for their staff mapping exercise, the customer successfully mapped the job titles of all 40,000 employees. The process was quick and efficient and was managed by users without the help of IT.

Some critical tasks require a robust but temporary solution. The Power Platform and SharePoint offer rapid, low-code development for the effective delivery of such solutions. By engaging with IncWorx, our customer was able to perform the potentially labor-intensive task quickly and accurately, and with negligible disruption to normal business operations.

The Microsoft technology stack provides the infrastructure and software necessary to maintain and grow your business. Combining Azure, SQL Server databases and SQL Server Integration Services packages provided this customer with a secure and robust data processing platform that will ensure the growth of their business for years to come. Do not delay your opportunity to get more from your data with ETL development.

PowerApps Solution for Tracking Due Diligence Field Exams

Read

Application Lifecycle Management for Manufacturing

Read

Technologies

Let's Build a Data Platform That Works for You

Some problems just need the right tool. Build an automated solution that handles scale your current process can’t.

Let's Get Started