Add an Item to a SharePoint List

Connection

Select the connection for the SharePoint server with the site and list that you want to update.

Note:

If no SharePoint connections have been configured in Business Analytics, this property shows a message and you cannot use this block until a connection to SharePoint has been configured by a Business Analytics administrator.

If the SharePoint server you need to work with is not in this list, contact your Business Analytics administrator.

User Credentials

This section is collapsed by default. It defines the credentials (user account and permissions) used to connect to this SharePoint server and sites. Use the

and

buttons to expand or collapse this section.

The permissions for the credentials you use determine which SharePoint sites and lists you can use in this block. Based on configuration, this may default to the credentials defined for the connection you have selected, also known as the service account. Or you may be required to supply your credentials for this SharePoint server.

Note:

Some SharePoint server connections may disable the use of user credentials based on configuration. In this case, this section only displays credential information.

To use your own SharePoint credentials to connect to this server, change or enter this account information and click Save.

Important:

Updating these credentials creates or updates your Business Analytics credentials for this SharePoint server (which are saved as Business Analytics User Attributes). This can affect other mashups or mashables that work with this SharePoint server if they use your credentials rather than the service account.

To remove your credentials from this block, click Remove. Depending on configuration for this server, the service account credentials may default. This also removes your Business Analytics User Attributes for this SharePoint server.

Site Name

Once you have the connection and user credentials set, choose the SharePoint site with the list you want to update.

List Name

Choose the SharePoint List you want to update.

Return

Choose the scope of the results for this block:

Entire list: this is the default, which returns the results for this list including the newly added item.

Only the added item: set this option if you need a simple confirmation or more detailed information for the item just added to this list.

column-name

Once you have identified the server, site and list that you want to update, Business Analytics retrieves information on the columns in this SharePoint List and adds a property to the block for each column. Use these properties to set the value of the item to add to this List.