Home > Case Studies > PowerApps Job Title Mapping Solution Manages Updates for 40,000 Employees

PowerApps Job Title Mapping Solution

This world-renowned management consulting industry customer provides strategy and consulting services to companies around the globe. The customer was adopting an entirely new catalog of job titles throughout the organization and required a swift and accurate means of reassigning job titles to its more than 40,000 employees.

Industry

Consulting

Technology

Power Apps, Power Automate, SharePoint

Employees

10,001+

Challenge

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. Upon completion, the customer would realize the following main benefit:

  • Successful mapping of new job titles to all 40,000 employees

Solution

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

Result

Upon completion of the temporary solution for their staff mapping exercise, the customer successfully mapped the job titles of all 40,000 employees.

Conclusion

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.

Want to learn more?

This is just one of the many solutions IncWorx has delivered for our customers.

To learn more about this or other solutions we’ve delivered, please contact us today.

[wpforms id="1422"]
<div class="wpforms-container wpforms-container-full" id="wpforms-1422"><form id="wpforms-form-1422" class="wpforms-validate wpforms-form" data-formid="1422" method="post" enctype="multipart/form-data" action="/case-studies/powerapps-job-title-mapping-solution"><noscript class="wpforms-error-noscript">Please enable JavaScript in your browser to complete this form.</noscript><div class="wpforms-field-container"><div id="wpforms-1422-field_0-container" class="wpforms-field wpforms-field-name" data-field-id="0"><label class="wpforms-field-label" for="wpforms-1422-field_0">Name <span class="wpforms-required-label">*</span></label><input type="text" id="wpforms-1422-field_0" class="wpforms-field-large wpforms-field-required" name="wpforms[fields][0]" required></div><div id="wpforms-1422-field_1-container" class="wpforms-field wpforms-field-email" data-field-id="1"><label class="wpforms-field-label" for="wpforms-1422-field_1">Email <span class="wpforms-required-label">*</span></label><input type="email" id="wpforms-1422-field_1" class="wpforms-field-large wpforms-field-required" name="wpforms[fields][1]" required></div><div id="wpforms-1422-field_3-container" class="wpforms-field wpforms-field-phone" data-field-id="3"><label class="wpforms-field-label" for="wpforms-1422-field_3">Phone</label><input type="tel" id="wpforms-1422-field_3" class="wpforms-field-large wpforms-masked-input" data-inputmask="&#039;mask&#039;: &#039;(999) 999-9999&#039;" data-rule-us-phone-field="true" name="wpforms[fields][3]" ></div><div id="wpforms-1422-field_2-container" class="wpforms-field wpforms-field-textarea" data-field-id="2"><label class="wpforms-field-label" for="wpforms-1422-field_2">How can we help you? <span class="wpforms-required-label">*</span></label><textarea id="wpforms-1422-field_2" class="wpforms-field-large wpforms-field-required" name="wpforms[fields][2]" required></textarea></div><div id="wpforms-1422-field_15-container" class="wpforms-field wpforms-field-html" data-field-id="15"><div id="wpforms-1422-field_15"><p style="padding-top: 10px; padding-bottom: 10px; font-family: 'Open Sans', sans-serif; font-size: 12px; color: #333333;">By clicking the button below, you are agreeing to our <span style="text-decoration: underline;"><span style="color: #000000;"><a style="color: #000000; text-decoration: underline;" href="https://www.incworx.com/privacy-policy">Privacy Policy</a></span></span>.</p></div></div><div id="wpforms-1422-field_7-container" class="wpforms-field wpforms-field-hidden" data-field-id="7"><input type="hidden" id="wpforms-1422-field_7" name="wpforms[fields][7]" value="PowerApps Job Title Mapping Solution Manages Updates for 40,000 Employees"></div><div id="wpforms-1422-field_9-container" class="wpforms-field wpforms-field-hidden" data-field-id="9"><input type="hidden" id="wpforms-1422-field_9" name="wpforms[fields][9]" value="3.236.108.61"></div><div id="wpforms-1422-field_10-container" class="wpforms-field wpforms-field-hidden" data-field-id="10"><input type="hidden" id="wpforms-1422-field_10" name="wpforms[fields][10]"></div></div><div class="wpforms-field wpforms-field-hp"><label for="wpforms-1422-field-hp" class="wpforms-field-label">Message</label><input type="text" name="wpforms[hp]" id="wpforms-1422-field-hp" class="wpforms-field-medium"></div><div class="wpforms-submit-container" ><input type="hidden" name="wpforms[id]" value="1422"><input type="hidden" name="wpforms[author]" value="2"><input type="hidden" name="wpforms[post_id]" value="6933"><button type="submit" name="wpforms[submit]" class="wpforms-submit " id="wpforms-submit-1422" value="wpforms-submit" aria-live="assertive" data-alt-text="Sending..." data-submit-text="Submit">Submit</button></div></form></div> <!-- .wpforms-container -->