DocumentationAEMUser Guide

[AEM Forms]{class="badge positive" title="Applies to AEM Forms)."}

Connect an Adaptive Form to Microsoft® SharePoint List connect-af-sharepoint-list

Last update: May 18, 2026
  • Applies to:
  • Experience Manager as a Cloud Service

CREATED FOR:

  • User
  • Developer
https://video.tv.adobe.com/v/3424820/connect-aem-adaptive-form-to-sharepointlist/?quality=12&learn=on

This video is applicable only for Core Components. For UE/Foundation Components, please refer to the article.

To use the Submit to SharePoint List Submit Action in an Adaptive Form:

  1. Create a SharePoint List Configuration: It connects AEM Forms to your Microsoft® Sharepoint List Storage.
  2. Use the Submit using Form Data Model (FDM) in an Adaptive Form: It connects your Adaptive Form to configured Microsoft® SharePoint.

1. Create a SharePoint List Configuration

To connect AEM Forms to your Microsoft® Sharepoint List:

  1. Go to Tools > Cloud Services > Microsoft® SharePoint.

  2. Select a Configuration Container. The configuration is stored in the selected Configuration Container.

  3. Click Create > SharePoint List from the drop-down list. The SharePoint configuration wizard appears.

  4. Specify the Title, Client ID, Client Secret and OAuth URL. For information on how to retrieve Client ID, Client Secret, Tenant ID for OAuth URL, see Microsoft® Documentation.

    • You can retrieve the Client ID and Client Secret of your app from the Microsoft® Azure portal.

    • In the Microsoft® Azure portal, add the Redirect URI as https://[author-instance]/libs/cq/sharepointlist/content/configurations/wizard.html. Replace [author-instance] with the URL of your Author instance.

    • Add the API permissions offline_access and Sites.Manage.All in the Microsoft® Graph tab to provide read/write permissions. Add AllSites.Manage permission in the Sharepoint tab to interact remotely with SharePoint data.

    • Use OAuth URL: https://login.microsoftonline.com/tenant-id/oauth2/v2.0/authorize. Replace <tenant-id> with the tenant-id of your app from the Microsoft® Azure portal.

      note
      NOTE
      The client secret field is mandatory or optional depends upon your Azure Active Directory application configuration. If your application is configured to use a client secret, it is mandatory to provide the client secret.

  5. Click Connect. On a successful connection, the Connection Successful message appears.

  6. Select SharePoint Site and SharePoint List from the drop-down list.

  7. Select Create to create the cloud configuration for the Microsoft® SharePointList.

Certificate-based authentication certificate-based-authentication

Certificate-based authentication for the SharePoint List configuration is under the Early Adopter Program. You can write to aem-forms-ea@adobe.com from your official email id to join the early adopter program and request access to the capability.

In the SharePoint List configuration wizard:

  1. Set Authentication Type to Certificate based authentication.
  2. Specify Title, Client ID, Certificate Alias, Tenant Id, and Tenant Name.
  3. Enter the SharePoint Site URL, verify the site connection if needed, and select the SharePoint List.
  4. Click Connect to verify the connection, then click Save & Close to save the configuration.

The below screenshot displays the SharePoint List configuration with Certificate based authentication:

SharePoint List configuration with certificate based authentication {align="center" width="50%,"}

To prepare the certificate for AEM and Microsoft Azure, perform the following steps in AEM, then register the public certificate in Microsoft Azure.

In AEM

  1. Go to Tools > Security > Users.
  2. Search for fd-cloudservice, select the user, and click Properties.
  3. Open the Keystore tab. If a keystore is not created yet, click Create Keystore and complete the prompts to set the keystore password.
  4. Add the private key to the keystore: expand Add Private Key From Keystore File and upload your .jks file.
  5. Enter an Alias that matches the Certificate Alias in the SharePoint List configuration, submit the key material, then click Save & Close.

The screenshot displays the keystore after the certificate is added. The Alias must match the Certificate Alias in the SharePoint List cloud configuration:

fd-cloudservice user Keystore with certificate alias {align="center" width="50%,"}

In Microsoft Azure

  1. Open your application registration and go to Certificates & secrets > Certificates.
  2. Select Upload certificate and upload the certificate file (public key) that Azure must trust for the application.

The screenshot displays the Certificates tab in the Azure portal, where you upload the certificate for the app registration:

Azure app registration Certificates and secrets {align="center" width="50%,"}

2. Use the Submit using Form Data Model (FDM) in an Adaptive Form use-submit-using-fdm

You can use the created SharePoint List configuration in an Adaptive Form, to save data or generated Document of Record in a SharePoint List. Perform the following steps to use a SharePoint List in an Adaptive Form as:

  1. Create a Form Data Model (FDM) using Microsoft® SharePoint List configuration
  2. Configure the Form Data Model (FDM) to retrieve and send data
  3. Create an Adaptive Form
  4. Configure Submit action using a Form Data Model (FDM)

When you submit the form, the data is saved in the specified Microsoft® Sharepoint List Storage.

NOTE
In Microsoft® SharePoint List, the following column types are not supported:
  • image column
  • metadata column
  • person column
  • external data column
recommendation-more-help
experience-manager-cloud-service-help-main-toc