Data Extraction-Excel

Hello Folks, I 'm a 3 old day RPA learner. I was assigned with a task of Ui Automation with Excel . I need to automate the workflow to log into a portal ,taking the input from excel of customer, Item Code and quantity and import them in portal. After submitting the order i need to capture the conformation Id and Write it in to the excel sheet. I have come up with a logic for the workflow :slight_smile:

Read Excel PreviousStoreCode = “” For each CurrentStoreCode If its first Row Search CurrentStoreCode Search ItemCode Add Quantity End If If (CurrentStoreCode = PreviousStoreCode) Search ItemCode Add Quantity End If If (CurrentStoreCode != PreviousStoreCode) AND (Not the First Row) Submit Order for Previous Store Code Capture Confirmation code and write in Excel "Calculation performed successfully " Search CurrentStoreCode Search ItemCode Add Quantity End If If (last row) Submit Order Capture Confirmation code and write in excel End If PreviousStoreCode = CurrentStoreCode End For

Please help me if i am missing anything in workflow

Hello @Tech_Projects_Cloud

  1. Read data from Excel.
  2. Loop through rows.
  3. Log in to the portal (outside the loop).
  4. For each row: a. Enter data into the portal. b. Submit the order. c. Capture the confirmation code. d. Write the code to Excel.
  5. Log out or complete portal tasks (outside the loop).

Thanks & Cheers!!!