Update Metadata activity

An activity that changes metadata in SharePoint.


Update Metadata activity

Configure the Update Metadata activity

To configure the Update Metadata activity, do the procedure in this topic.

Video: eForms with SharePoint - Part 4

Examples

Good to Know

How to Start

  1. Open Process Builder.

    For information about how to open this screen, refer to Process Builder.


    Open Process Builder
  2. In Process Builder, in the Activity Library, and open the SharePoint tab.

    Open SharePoint tab
  3. On the SharePoint tab, drag the Update Metadata activity onto your process.

    Drag Update Metadata activity

General Configuration

Specifies the basic settings for the Update Metadata activity.

Figure: General Configuration screen

General Configuration screen

Good to Know

  • Documentation for this screen is provided for completeness. The fields are mostly self-explanatory.

Fields

Field NameDefinition

Display Name

Function:
Specifies the activity name that shows in your process.
Accepted Values:
One line of text that can have spaces.
Default Value:
None
Accepts Process Data Variables:
No
Example:
This is a common configuration field that is used in many examples. Refer to:
  • Examples - Step-by-step use case examples, information about what types of examples are provided in the AgilePoint NX Product Documentation, and other resources where you can find more examples.

Description

Function:
Specifies an optional text description for your activity.
Accepted Values:
More than one line of text.
Default Value:
None
Accepts Process Data Variables:
No

Update Metadata Configuration > Configuration tab

Specifies a value for a field to update in a SharePoint library and folder.

Figure: Update Metadata Configuration > Configuration tab

Update Metadata Configuration Configuration tab

Fields

Field NameDefinition

SharePoint

Function:
Specifies the access token that connects to your SharePoint site.
Accepted Values:
A list of access tokens configured for your environment.
Default Value:
None
Accepts Process Data Variables:
No
Example:
Refer to:

Create Add Token icon

Opens this Screen:
Access Token for SharePoint
Function of this Screen:
Configure an access token to connect to SharePoint.
Example:
Refer to:

Site

Function:
Specifies the URL for your SharePoint site.
Accepted Values:
A valid SharePoint site URL.
Default Value:
None
Accepts Process Data Variables:
Yes
Example:
  • http://[machine name]:[port]/sites/[site name]

    Note: You must include the /sites in the Site URL for the site to be created successfully.

Also refer to:

List

Function:
Specifies the name of your SharePoint list.
Accepted Values:
The name of your SharePoint list.
Default Value:
None
Accepts Process Data Variables:
Yes
Example:
Refer to:

Folder

Function:
Specifies the name of your SharePoint folder.

The folder contains the process data variables to change.

Accepted Values:
The name of your SharePoint folder
Default Value:
None
Accepts Process Data Variables:
No

Field

Function:
Specifies the name of the SharePoint column to use to limit the change in the process data variable's value.
Accepted Values:
The name of your SharePoint list column.
Default Value:
"ID", the list column that specifies the unique list item ID.
Accepts Process Data Variables:
No
Example:
Refer to:

Field Value

Function:
Specifies the SharePoint column's value.

This will limit the change of the process data variable to the value specified.

Accepted Values:

The list column's value.

Note the following:

  • If you want to clear a value, specify NULL.
  • If you leave the Field Value property empty, the activity updates all records in the SharePoint library.
Default Value:
${ListItemID}
Accepts Process Data Variables:
Yes
Example:
Refer to:
Limitations:

Some information about third-party integrations is outside the scope of the AgilePoint NX Product Documentation. It is the responsibility of the vendors who create and maintain these technologies to provide this information. This includes specific business use cases and examples; explanations for third-party concepts; details about the data models and input and output data formats for third-party technologies; and various types of IDs, URL patterns, connection string formats, or other technical information that is specific to the third-party technologies. For more information, refer to Where Can I Find Information and Examples for Third-Party Integrations?

Update Metadata Configuration > SharePoint List tab

Specifies a value for a field to update in a SharePoint library and folder.

Figure: Update Metadata Configuration > SharePoint List tab

Update Metadata Configuration SharePoint List tab

Fields

Field NameDefinition

Display Name

Function:
Specifies the name of the SharePoint library column.
Accepted Values:
Read only.
Example:
Refer to:

Value

Function:
Specifies the value of the SharePoint list column.
Accepted Values:
Read only.
Example:
Refer to:

Field Display Name

Function:
Specifies the SharePoint column names for your list or library.
Accepted Values:
Read only.

The values show when you select a list item.

Field Internal Value

Function:
Specifies the internal names of the SharePoint columns for your list or library.
Accepted Values:
Read only.

The values show when you select a list item

Meta Data Name

Function:
The name of the process data variable to store the list item field values. The values can be changed to a process attribute, an XML schema element, or SharePoint variable.
Accepted Values:
  • A process attribute.
  • An Xpath to a schema element.

    To add XML metadata associated with the process model, click the button in the MetaData Name field.

  • SharePoint metadata.
  • The URI for one or more files.

    You can attach one or more files separated by semicolons (;) using:

    • Local file path - c:\[path]\[file name]
    • URL - http://[URL]/[file name]
Default Value:
None.

When you add a field, the Meta Data Name column shows the internal name of the SharePoint column.

Accepts Process Data Variables:
Yes
Example:
Refer to:

Filter Filter icon

Function:
Shows the items in the list based on the values you enter.
To Open this Field:
  1. Click Filter Filter icon.
  2. On the filter screen, select your operator.
  3. Enter the values to show in your list.
Accepted Values:
  • Is equal to
  • Is not equal to
  • Starts with
  • Contains
  • Does not contain
  • Ends with
Default Value:
Is equal to

Update Metadata Configuration > Item Ownership tab

Specifies the owner of a metadata you changed in SharePoint .

Figure: Update Metadata Configuration > Item Ownership tab

Item Ownership tab

Fields

Field NameDefinition

Item Ownership

Function:
Specifies the owner of a metadata you changed in SharePoint .
Accepted Values:
Default Value:
Service Account used in Access Token