Project Budget Tracking – power apps
- The client is a government contractor who supplies technological resources and solutions to US government
- The client wanted a tracker to manage the project billing and resources and overall progress of multiple projects
- Required formulas and customization are to be implemented to achieve the form
- Various details like contract type, status, contact details , funding expenditure can be captured, edited and
- Form functionality is designed to evaluate the details entered and update the required field status
Solution
- SharePoint site is built using Power Apps
- Required customization and formulas are applied to successfully implement the form
- User can create, edit and view the records using different
- User can delete , save and add comments wherever
- Various field data is evaluated and formulas are applied to calculate funding expenditure , (if more than or less than 70%) , based on the user submitting the expenditure details .
Impact
- Increased project visibility to management
- Automated Notifications for better tracking on escalations