Microsoft has come at the right time. To come out with a RAD (Rapid Application Development) tool where you can develop your apps on the cloud much faster, and deploy them for multiple devices, whether it is mobile, cloud, laptops, or desktops. It is similar to Oracle APEX or Oracle developer tools where you just drag and drop into your application within minutes.
The primary use case of this solution is case management reporting. If, for example, you have a set of engineers who have been assigned a particular case or project they will need to record all of their activities and their visits. Using the application created in PowerApps, they report everything, then it goes through a workflow.
The workflow goes from recording the daily activities of the team for the specific project. The project then goes through a series of approvals and gets logged, completed, and the report is generated.
Expenses are also being logged.
We have Power BI as well, and it moves the data from the source to the data warehouse then generates a report.
This is quite a short term, six-week engagement. We wanted to create an application and have it up and running within four to six weeks, rather than spending three to six months on bigger projects on the platform. We wanted it to be quick and fast.
PowerApps is best suited for those cases where you have a small scenario and an application to support that project or scenario. You can call these departmental applications, which are needed on the fly. We create a much shorter development lifecycle and then deploy, and then people start using it.
Take an example of the COVID-19 situation. We wanted all of our branches to log their COVID cases or what exactly are they doing daily to manage the COVID cases and to know what the process is. All of those details are logged into the COVID folder and then the reports are generated daily or weekly.