Documentation › Save and share › Create items and upload documents to SharePoint from Plumsail Forms with Power Automate › Save Data Table, Ink Sketch, and Likert Scale to SharePoint

How to save Data Table, Ink Sketch, and Likert Scale to SharePoint columns with Power Automate

Both Plumsail public web forms and Plumsail Forms for SharePoint include custom controls—Ink Sketch, DataTable or Likert Scale. In this article, you will learn how to save controls’ data from public form to SharePoint list with MS Power Automate (MS Flow).

SharePoint list

To view and edit controls’ data in SharePoint lists, design a form using Plumsail Forms for SharePoint.

Add an Ink Sketch, DataTable, or Likert Scale control to the form. In Save to property, select an existing Multiline Plain Text column or create a new one in the target SharePoint list to store the control’s data:

Save to property

After configuring the Save to property and saving the form, the SharePoint list view will display the control data in a user-friendly format:

SharePoint list view

Learn more about rendering controls’ data in a SharePoint list view in the Save and render control data in SharePoint article.

Flow trigger

  • Open Microsoft Power Automate and create a new automated flow:

    Create automated flow

  • Search for Plumsail and select Form is submitted trigger, click Create:

    Trigger

  • If this is the first time you are using Plumsail Forms connector, you will be asked to sign in to your Plumsail account to create a connection. Click Sign in and enter your account credentials:

    connection

  • Select the public web form from the dropdown list:

    Selecting form

Save Data Table to SharePoint column

  • Add the Data Operations - Compose action after the flow trigger:

    Compose

  • In the Inputs box, add Data Table from the Dynamic content list:

    Compose action

  • Add the SharePoint - Create Item action. Specify the site address and list name:

    Create Item

  • Select the column where you want to save Data Table control data and add Outputs of the Compose action:

    DataTableOutput

  • Save the flow and test.

Save Likert Scale to SharePoint column

  • Add the Data Operations - Compose action after the flow trigger:

    Compose

  • In the Inputs box, add Likert Scale from the Dynamic content list:

    Likert Scale Compose action

  • Add the SharePoint - Create Item action. Specify the site address and list name:

    Create Item

  • Select the column where you want to save Likert Scale control data and add Outputs of the Compose action:

    Likert Scale Output

  • Save the flow and test.

Save Ink Sketch to SharePoint column

  • Add a SharePoint - Create Item action. Specify the site address and list name:

    Create Item

  • Select the column where you want to save Ink Sketch control data and add Ink Sketch from the Dynamic content list:

    Ink Sketch

  • Save the flow and test.