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

Function:
Specifies whether to write the data to a database or a SharePoint list or library.
Accepted 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

Function:
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.
Accepted Values:
A list of access tokens configured for your environment.
Default Value:
None
Accepts Process Data Variables:
No
Example:
Refer to:

Schema Name

Function:
Specifies your process schema.
To Open this Field:
  1. On the Data Population screen, in the Repository list, select Database.
Accepted 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

Function:
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.
Accepted Values:
A list of access tokens configured for your environment.
Default Value:
None
Accepts Process Data 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

Function:
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.
Accepted Values:
A database table names selected from the database.
Default Value:
None
Accepts Process Data Variables:
No
Example:
Refer to:

Selected Table Names

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

Site URL

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

List Name

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

Selected List Names

Function:
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.
Accepted 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 Process Data 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..