Looking for something in particular?

UI Fill

This test step 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 test step in the Test 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 filled page 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 more Account records with varying data requirements.

Step 1: Create an Excel template with column names set as the Salesforce Account object field names. Custom fields will have a __c suffix.

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 parameter source step to read through the Excel sheet and save the values in a list.

Step 4: Add a For Each to loop through the list. Within the For Each, add a UI On Screen step to navigate to the Account New screen, then add the UI Fill step followed by a step for the click save button.

Your test case should look like this.

Then, Save and run the test case.

Review Provar on G2
Documentation library

Trying to raise a case with our support team?

We use cookies to better understand how our website is used so we can tailor content for you. For more information about the different cookies we use please take a look at our Privacy Policy.

Scroll to Top