The SharePoint List Connector extends our SharePoint integration to allow manipulation of rows in a target SharePoint List. Please note that the connector can only be configured and used by Premium-level users, and that this connector is not available to legacy accounts.
Setting up the Connector
Ensure you have a valid SharePoint connection defined in the Connections area:
- Go to the Connectors page on any Form and add the new SharePoint List Connector
- Specify a List name for the connector to access and hit Save
- Our system will retrieve the columns available in the target List – you now simply need to map a Form value to each column as desired
Updating SharePoint Rows
The SharePoint List connector will insert new rows into the target List.
If you want the connector to update pre-existing rows, then use the Key option to define a key column which will be used to find a matching SharePoint row when the connector is executed. If a matching row is found, then that will be updated. Otherwise, a new row will be added.
The connector also allows for repeating Form entry data by creating multiple rows, one for each repeat.
All non-repeated data is copied down into each repeat row created.