Data Population screen

Configures data population for an app.

Figure: Data Population screen

Data Population screen

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, click Misc > Data Population.

    Click Data Population

Fields

Field NameDefinition

Repository

Description:
Specifies whether to write the data to a database or a SharePoint list or library.
Allowed Values:
  • Microsoft SQL Server - Writes the data to a Microsoft SQL Server database.
  • Sharepoint - Writes the data to a SharePoint list.
Default Value:
None
Example:
Refer to:

Database

Description:
Specifies the access token that connects to your database.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select Database.
Allowed Values:
A list of access tokens configured for your environment.
Default Value:
None
Accepts Variables:
No
Example:
Refer to:

Schema Name

Description:
Specifies your process schema.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select Database.
Allowed Values:
A schema name from the list.

When you select a database, the schemas associated with the database show in this field.

Default Value:
None
Example:
Refer to:
Limitations:

Create Add Token icon

Opens this Screen:
Access Token for Database
To Open this Field:
  1. On the Data Population screen, in the Repository list, select Database.
Function of this Screen:
Configure an access token to connect to a database..

SharePoint

Description:
Specifies the access token that connects to your SharePoint site.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select SharePoint.
Allowed Values:
A list of access tokens configured for your environment.
Default Value:
None
Accepts Variables:
No

Create Add Token icon

Opens this Screen:
Access Token for SharePoint
To Open this Field:
  1. On the Data Population screen, in the Repository list, select SharePoint.
Function of this Screen:
Configure an access token to connect to SharePoint.

Table Names

Description:
Shows all the table names of the specified database.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select Database.
Allowed Values:
A database table names selected from the database.
Default Value:
None
Accepts Variables:
No
Example:
Refer to:

Selected Table Names

Description:
Specifies the database table names.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select Database.
Allowed Values:
The table names selected from the Table Names list.
Default Value:
None
Accepts Variables:
No
Example:
Refer to:

Site URL

Description:
Specifies the URL for your SharePoint site.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select SharePoint.
Allowed Values:
A valid SharePoint site URL.
Default Value:
None
Accepts Variables:
Yes
Example:

List Name

Description:
Shows the name of your SharePoint list.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select Database.
Allowed Values:
The name of your SharePoint list.
Default Value:
None
Accepts Variables:
No

Selected List Names

Description:
Specifies the name and primary key of your SharePoint list.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select SharePoint.
Allowed Values:
  • Field Name - Specifies the name of your SharePoint list.
  • Primary Key - Specifies the primary key to be used for each list.
Default Value:
None
Accepts Variables:
No

Map Data

Opens this Screen:
Schema Mapper screen
Function of this Screen:
Maps SharePoint fields, form fields, web methods, or other input sources to an XML schema..