Use this page to find example workflows for Aura Digital WorkforceGenta Automation.

Prompt User "Please upload your Excel file" $myExcel -excel//This folder is in My Documents\Digital Workforce\Genta Digital Worker\Assets\.

//This path is used to locate files and folders. You can also specify a full path below.

$excelFile = ""

$folder = "Test Data"

$rpasite = "http://www.rpachallenge.com/"

navigate to $rpasite

foreach ($excelFile in $folder)

{

foreach ($row in $myExcel$excelFile)

{

//Variables in foreach loops are auto-generated.
generated
//Use inspector to get variable names,.

//theyThey 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"
}

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

//You are now finished inputing values. Swith to Excel or the file to update a value.

switch to $excelFile

Set value "Is Completed" as "Yes"

}

//This will send the result back to the user to open once workflow automation is complete.

//You could also use the "Copy" or "Move" commands to copy files to another location.

//The files are stored on Genta Worker.

Add Result $excelFile

}

//This command below will send the results stored to Genta Desktop.

//Once completed, look for a button labeled 'Open Results'.

Send Results to Genta Desktop