Prompt User "Please upload your Excel file" $myExcel -excel
$rpasite = "http://www.rpachallenge.com/"
navigate to $rpasite
foreach ($row in $myExcel)
{
//Variables in foreach loops are auto generated
//Use inspector to get variable names,
//they will be the column headers without spaces and special characters
switch to $rpasite
//The parameter -forcedetection is used because each time the Submit button is clicked, the position of controls change
//This is used to tell Aura to force redetect the screen controls
//Normally, without this parameter, Aura can detect screen changes automatically, but we want to be sure to force this here
Enter $FirstName as "First Name" -forcedetection
Enter $LastName as "Last Name"
Enter $PhoneNumber as "Phone Number"
Enter $CompanyName as "Company Name"
Enter $RoleInCompany as "Role in Company"
Enter $Email as "Email"
Enter $Address as "Address"
Click "Submit" button -nearest("address")
switch to $myExcel
Set value "Is Completed" as "Yes"
}