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 this connector is not available to legacy accounts.
Setting up the Connector
- 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
By default, 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 – it does this by creating multiple rows, one for each repeat.
All non-repeated data is copied down into each repeat row created.