Automation Challenge: Filling Varying Data from Excel into Web App Patient by Patient

[Aditya_Nalawade]

Hello UiPath Community,

I am facing a challenging automation task. I need to automate the process of filling data from an Excel sheet into a web application. The complexity lies in the fact that each patient in the Excel sheet has a varying number of treatments, and I want the automation to complete data entry for one patient before moving to the next.

Description of the Problem:

• The Excel sheet contains patient data with varying numbers of treatments.
• The web application requires accurate data entry for each patient and their respective treatments.
• I need the automation to ensure that the data for one patient is fully entered before moving on to the next patient
  .
  Here is my workflow

[Anil_G (Anil Gorthi)]

Duplicate

How to Fill Varying Excel Data into Web App Fields with Looping Question

@Aditya_Nalawade As all the test element details are different…you need to indicate each seprately and based on the test value you can use if activity to check if test matches then click those tests… So basically inside the loop use all these if conditions Inside the unique for each…use another for each for filtereddt Inside that use if condition eith index = 0 …and index is the property in for eqch of filtereddt And on else side use the intial patient level details like name date etc Afte…

[Aditya_Nalawade]

I was looking for different approaches

[Anil_G (Anil Gorthi)]

@Aditya_Nalawade

Then also its not good to create new topics…you can raise it one the same…it is just to maintain sanity…so that duplicate topics are not present and discussion hppens in one palce…

Cheers