This API fills one or more fields on a Salesforce screen with data defined in an Excel sheet. This is most useful when you have a single Object screen in which you need to input data into multiple fields and/or enter multiple records. It saves having to create multiple Test Steps to input every field.

Locate the UI Fill API in the API palette and click and drag it into your Test Case.

Update the parameters as follows:

  • Values: The list name which contains the values of all the fields to be populated
  • Ignore Fields: Any Salesforce fields on the page being filled which should be ignored when Provar reads from the Excel sheet. This should be a comma separated list of column names

Then save the Test Case.


This Test Case will create via the Salesforce UI two Account records with information defined in an Excel sheet. This example could be expanded further to create a larger number of Account records with varying data requirements.

Step 1: Create an Excel template with Column Names set as the Salesforce API Names of Account object fields. These API names will have a __c suffix for custom fields.

These names can be accessed from within Provar Desktop using the Org Browser:

Step 2: Enter field values under the relevant Columns of the Excel sheet. Each row should represent a new Account record. Multiple rows can be added.

Step 3: In the Test Case, add a Read step to read through the Excel sheet and save the values in a list.

Step 4: Add a For Each and loop through the list. Within the For Each, add an ‘UI On Screen’ step to navigate to the Account New screen, then add the UI Fill step followed by a step for ‘Click Save Button’.

Your Test Case should look like this:

Then Save and run the Test Case.