Insert data into SharePoint list using invoke FDM workflow step

This article explains the steps required to insert data into SharePoint list using the invoke FDM step in AEM workflow.

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

Create a form data model based on the SharePoint list data source

Create a workflow

Adaptive Form based on core components

The submitted data is in the following format. We need to extract the ContactUS object using dot notation in the invoke Form Data Model Service workflow step as shown in the screenshot

{
  "ContactUS": {
    "Title": "Mr",
    "Products": "Photoshop",
    "HighNetWorth": "1",
    "SubmitterName": "John Does"
  }
}

Adaptive Form based on foundation components

The submitted data is in the following format. Extract the ContactUS JSON object using the dot notation in the invoke Form Data Model Service workflow step

{
    "afData": {
        "afUnboundData": {
            "data": {}
        },
        "afBoundData": {
            "data": {
                "ContactUS": {
                    "Title": "Lord",
                    "HighNetWorth": "true",
                    "SubmitterName": "John Doe",
                    "Products": "Forms"
                }
            }
        },
        "afSubmissionInfo": {
            "lastFocusItem": "guide[0].guide1[0].guideRootPanel[0].afJsonSchemaRoot[0]",
            "stateOverrides": {},
            "signers": {},
            "afPath": "/content/dam/formsanddocuments/foundationform",
            "afSubmissionTime": "20240517100126"
        }
    }
}

Configure Adaptive Form to trigger AEM workflow

Test the form

Preview the form created in the previous step. Fill out the form and submit. The data from the form should get inserted into the SharePoint list.