Explored multiple platforms to build a user friendly, intuitive tool that collects user inputs while complying with business rules and at real time, stores the input data to an excel sheet which would then be used for other transformations.
After studying various platforms and their features, Power Apps was selected for developing the app as the tool had essential features such as secure login, RLS features and easy interface for user inputs along with being in the MSFT stack.
Designed an intuitive app interface for collecting target inputs from field teams; the UI was designed to display necessary information such as previous year’s performance for each associate which helped the field teams to assign necessary targets for associates.
Implemented row-level security to ensure the user’s privacy and eliminating any potential privacy concerns.
Access to data was controlled using login credentials, such that each user had access to their respective data only.
Implemented multiple data validation steps to ensure that business rules and logics were met.
Using the new app, field teams can now seamlessly assign the targets for associates they manage and eliminate potential errors during target inputs as there are proper validations in place.
• Through the implementation of RLS for the app, privacy concerns were eliminated as the targets were secured for each person.