Hi everyone
Apologies if the title is not clear as I was not sure what to set it to. Also, I was not sure whether to post this question here or in a Power Apps forum as my problem also involves that platform.
I am in need of advice on the best way to create a system I'v been tasked to create.
The system in question is going to provide our customers with an online application form to apply for some of our services. This application form is to be created using a Power Apps portal form and the data is to be saved in D365 entities. The application form will be collecting a lot of information about applicants such as their personal and contact details, joint applicant (if any), employment history, current and old addresses, residency history, etc.
The application has a unique reference number. Once an application is submitted, it will be reviewed and will either be accepted or rejected by the admin team. But during its review or even after it's been rejected, the admin team could allow the applicant to make changes to the application on the applicant's request. For instance, if the application has been rejected because the admin team did not find the joint applicant suitable for the application, the applicant could ask the admin team to allow them to amend the application to remove that joint applicant or replace them with another applicant.
Here's the important part. Because an application can be amended during its life before it has been accepted or rejected for good, the admin team need the system to keep track of all changes made to the application. Therefore the system should support a version history of the application. This should include a version number so that every time a new version of the application is made, the version number is incremented. And all versions will be pointing to the same application, i.e. they will hold the unique reference number of the application.
Finally, the admin team wants the ability to send the applicant the link to the specific version of the application the applicant wants to amend or update (which is usually the latest version but it could be an older version) so that when the applicant clicks the link the Power Apps portal form will load all the details of that version for the applicant to access.
I most appreciate any advice the good experts here can provide for the above scenario.