Skip to main content
All CollectionsAutomationWorkflowsMicrosoft SharePoint integration
Set up your “Upsert to SharePoint Using a Completed Form” Workflow recipe
Set up your “Upsert to SharePoint Using a Completed Form” Workflow recipe

Add a row or update an existing row in your Excel table based on a key value.

Updated over 4 months ago

Automatically update a row or add a new row to an Excel table within your SharePoint account with the data you collect with your completed Forms with Workflows.

You’ll find the process of updating or adding rows based on their condition referred to as upserting.

🗒️ Note: SharePoint Workflows are only available for Advanced and Enterprise accounts.

This Workflow requires a SharePoint connection. If you haven’t added a SharePoint connection, you’ll need to do that before you set up this Workflow.

In the web app, go to the Workflows tab. Click Create Workflow to access the Workflow Recipes Library.

Select the Upsert to SharePoint using a completed Form recipe.

Screenshot displaying the “Upsert to SharePoint Using a Completed Form” Workflow Recipe card in the Workflow Recipes Library of the web app.

You'll navigate to the Workflow Editor where you’ll complete the following steps.

  1. Click the pencil icon next to the default Workflow name.
    ​

    Enter a Workflow name.
    ​

  2. Establish your Form Completed trigger. Start your Workflow when specific Templates are used to complete a Form by a specific user or Group.​
    ​

    Screenshot displaying the details of the Form Completed trigger in the GoFormz web app’s Workflow Editor.

    1. Select your Template to start your Workflow when your selected users complete a Form using either a specific Template, or all Templates.
      ​

    2. Trigger your Workflow based on Form completion using your selected Templates When completed by your selected user or Group.
      ​

    Select the Upsert Row in Excel Table action.
    ​

  3. Establish your Upsert Row in Excel Table action.
    ​

    Screenshot displaying the details of the SharePoint Online: Upsert Row in Excel Table action in the GoFormz web app’s Workflow Editor.


    This action determines where within your SharePoint account you’ll upsert your completed Form data.
    ​

    1. Select your Connection - this’ll determine the available configuration details that follow.
      ​

    2. Select your SharePoint account details. These include Site, Document Library, Workbook Path, and Table Name.
      ​

    3. Column Mapping delivers values to your associated SharePoint location.
      ​

      1. Enter your SharePoint sheet’s Column Name to determine where your Workflow delivers the value you enter in the matching Cell Value.
        ​

      2. Switch the Is Key Column? slider to active for your sheet’s key column.

  4. Click the Activation slider if you want your Workflow active immediately. ​
    ​

    Screenshot displaying the Activation slider in the GoFormz web app’s Workflow Editor.


    ​
    Your Workflow’s activation status is either Active or Inactive.
    ​

  5. Click Save Draft.
    ​

  6. Click Publish.

Did this answer your question?