Set up an “Upsert to OneDrive Using a Completed Form” Workflow recipe

Add a new row or update an existing row in your OneDrive based on a key value using a completed Form.

Updated over a week ago

Automatically update a row or add a new row to your OneDrive worksheet based on your completed Form with the "Upsert to OneDrive Using a Completed Form" recipe. You’ll find the process of updating or adding rows based on their condition referred to as upserting.

This Workflow enables you to automatically pull data from transmitted Forms into your connected OneDrive worksheet.

During this process, you'll need to reference your Table Name. Your Table Name is different than your Sheet name. If you don't have a table within your selected OneDrive Workbook, you'll need to create a table.

After you've created a table, open the Table Design drop-down menu. You'll find a text box with your table name on the left-hand side of the menu.

Screenshot displaying the location of the table name in the Table Design menu of Microsoft Excel.

This is the Table Name you'll reference when setting up this Workflow.

Set up this Workflow recipe in the GoFormz web app’s Workflows tab. Here you’ll click Create to navigate to the Workflow Recipes Library where you’ll complete the following steps:

  1. Select the Upsert to OneDrive Using a Completed Form recipe.
    ​
    ​

    Screenshot displaying the Upsert to OneDrive Using a Completed Form recipe in the Workflow Recipe Library in the GoFormz web app.


    ​
    You’ll navigate to the Workflow Recipe Builder.

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

    Screenshot displaying the location of the pencil icon in the Workflow Recipe Builder in the GoFormz web app.


    ​
    Enter a Workflow name.
    ​
    ​Note: GoFormz recommends that you include the Template name used in the Workflow in your Workflow name.
    ​

  3. Establish your Form Completed trigger by configuring your Completed By & Template options.
    ​
    ​

    Screenshot displaying the configuration details for the Form Completed trigger in the Workflow Recipe Builder within the GoFormz web app.


    ​

    1. Select the appropriate user-based trigger using the Completed by drop-down menu. Options include Anyone, Specific User, or Group.

    2. Select the appropriate Template from the Template drop-down menu.
      ​

  4. Establish your Upsert Row in Excel table action. This action requires that you configure your Connection, Workbook, Table Name, and Column Mapping.
    ​
    ​

    Screenshot displaying the configuration details for the OneDrive: Upsert Row in Excel Table action in the Workflow Recipe Builder in the GoFormz web app.


    ​

    1. Connection is a drop-down menu listing your available OneDrive connections. Your OneDrive connections determine the options available to you here.

    2. Workbook specifies the path to the OneDrive Workbook you want your action to reference.

    3. Table Name is the name of the Table within the OneDrive Workbook you want your action to reference.

    4. Map your Column Name from OneDrive to the Value with Column Mapping.
      ​
      Your Value can be a specific number, or a specific Field from your Template using Workflow Variables. Identify whether your data will be added as a new row or used to update an existing row based on a specified Key Column.
      ​

  5. Click the Activation slider if you want your Workflow active immediately.
    The Workflow Activation status will display as Active or Inactive.
    ​
    ​

    Screenshot displaying the location of the Activation slider in the Workflow Recipe Builder in the GoFormz web app.


    ​

  6. Click Save.

Want to verify that your Workflow is set up correctly?

If you want to verify that your Workflow is correctly set up, complete the Workflow trigger you set up in Step 3 above.

Next, check the Workflow Jobs page in the GoFormz web app.

Screenshot displaying the location of the View Jobs link on Workflows page in the GoFormz web app.

Here you’ll see if your Workflow succeeds. If your Workflow is successful, you’ll see data from your submitted Form in your connected OneDrive worksheet.

Did this answer your question?