Automate desktop field flow on each datatable for each row

Hi @danielvianna

It should be completely doable, but will vary in difficulty level depending on the structure of the application you use.

If I were to approach it, this would be how:

  1. Use For Each Row activity to loop over each row.
    This activity will be the top of your sequence. It will host all the logic inside it.

    Then
  2. I would select elements based on their selectors, dynamically.
    What I mean is kind of explained in the post I made yesterday (the example was built in 2019.7.0 and it will not open on an earlier version):
    Look up functionality - #5 by loginerror
    The example shows how you can insert a value from wherever (in your case your Data Table) into your selector to click/set the thing you want.
    Step 2 is therefore the part where you figure out with UiExplorer if your elements allow for that (=that the name of each field is present anywhere in the selector and could thus be replaced by a dynamic value)
    Afterwards, two more comments
  3. You will want to check if the values were set correctly. For that, you could read the attribute of the field you have set after setting it and see if it was done correctly. This could be done with a simple Get Text, or in the case of the checkboxes, with the Get Attribute activity (I think the attribute for the checkbox would be “state”, but you have to see for your particular app).
  4. For actual well designed process, there should be error handling involved. If I were to write this application, I would make use of the ReFramework. It is more advanced, but would do the job perfectly.
    If you are curious, you should check this post for a working example of a process that takes rows from Excel as input and processes them one by one as transactions to give output. In your case, all you would need to do is to make a few changes to make it work for you:
  • replace input Excel file your with your Data Table
  • put the bulk of your code in Process.xaml
  • you would need to initialize your apps and kill them in the correct places
    Reframework help - #9 by loginerror

I hope these comments are helpful, let me know if you need more guidance :slight_smile:
I feel like my advise is based on too many tiny bits of knowledge I gained while submerged in UiPath and not everything might be clear right away :smiley: