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.



  1. Vijaya Kolakalapudi 10th November 2017 at 7:38 pm - Reply

    For the check box fields what value do we need to enter in the excel file

    Thanks Vijay

    • Hetty Weston 24th November 2017 at 12:02 pm - Reply

      Hi Vijay

      Sorry for the slow response. For checkboxes you can use TRUE/FALSE, 1/0 or yes/no.


Leave A Comment