Make Apprentice Recapitulation System low code with Microsoft Tools. With using Microsoft tools, we can reduce cost for build, maintenance system, and we can develop with low-code system.
One-Drive = For storage all files
SharePoint = Make sheet database recapitulation
Power Automate = Workflow to automate all configuration and system
Power BI = Dashboard Recapitulation and triggered when cost almost 80%
PowerApps = Create UI and application for daily logbook
Outlook = Email triggered
We use Power Automate to automation flow from
Registration to storing Sharepoint
Login and insert data to Sharepoint
Make better dynamic Power Apps
Import data to Power BI Dataset
Automation Emailing if cost overbudget
We use Power Apps for creating application, it can be access student to insert report task during their apprenticeship
We use One Drive for file storage all data from sharepoint
We use sharepoint for creating table and storing as a database:
Table Registration, Table Student Account, Table Authentication, Table List Job, Position, and Task, and Table Total Recapitulation
We use Power BI for visualize report and management budget cost
When cost take 6 million, it will be automate emailing to administrator or vendor in middle or as message email more important if cost overbudget 8 million.
We use Outlook Mail report data recapitulation and cost visualization