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
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