Prefill adaptive form with share point list data

In the previous version of AEM Form(6.5), custom code had to be written to prefill form data model backed adaptive form using request attribute. In AEM Forms as cloud service, the need to write custom code is not longer required.

This article explains the steps required to prefill/pre-populate adaptive form with data fetched from SharePoint list using the form data model prefill service.

This article assumes you have successfully configured adaptive form to submit data to SharePoint list.

The following is the data in the SharePoint list
sharepoint-list

To prefill an adaptive form with the data associated with a particular guid the following steps need to be performed

Configure the get service

  • Create a get service for the top level object of the form data model using the guid attribute
    get-service

In this screenshot, the guid column is bound via a request attribute called submissionid.

The get service fully configured looks like this

get-service

Configure the adaptive form to use form data model prefill service

  • Open an adaptive form based on the share point list form data model. Associate the Form Data Model Prefill service
    form-prefill-service

Test the form

Preview the form by including the submissionid in the URL as shown below

http://localhost:4502/content/dam/formsanddocuments/contactusform/jcr:content?wcmmode=disabled&submissionid=57e12249-751a-4a38-a81f-0a4422b24412
recommendation-more-help
4859a77c-7971-4ac9-8f5c-4260823c6f69