Click Checkbox in a table based on dynamic values

Help Studio
, ,
1

Hi Community,

I want to click the checkbox depending upon “Mod Trn” and “Description”. PFB screenshot of table. These values are dynamic and will be fed by Excel sheet.

image
image1559×346 34.2 KB

2

Hi @tilarapiyush

I think this is almost same query i have solved some time back,

can you please check this post and try to do the same logic here also

Thanks.

3

This won’t work as there are 2 dynamic values which determine the correct checkbox. e.g. It could be combination of (CL1 and ATOZ) or(CL2 and ATOZ) and so on.

4

In that post I take the value of name using one get attribute so you can use 2 get attributes for both mod trn and description ,we can tweak that little bit and it should works fine.

So just one question did the selectors shoe table row and column values in selectors if indicate anything in the table…

5

Yes, the selectors do show the Table row and columns while selecting any element in the table. Could you explain how to apply your solution in my case step wise ?

Just to add to my problem, the number of rows also are dynamic here.

6

I have modified the workflow which check for 2 columns instead of 1 column,

sample (2).xaml (17.7 KB)

change the selector as per your need

Thanks

7

I understood the selectors, just want to know how the process flow should look and what activities to be used.

8

Here are the steps we need

  1. We extract aaname form 2nd column (Mod trn) and 3rd column (description)

  2. We check if the aaname of both these are equal to what we want.(if it is not equal we increase the row number and check the next row this will continue in loop until the condition is met)

  3. If it is equal then that row number and 1st column number is the selector for that check box which we can check using click or check activity.

Thanks

9

Could you send the workflow in Zip to my mail (tilarapiyush@gmail.com) ?

10

Are you not able to download the workflow I have attached earlier?

11

There are activities missing as it happens while downloading.

image
image647×690 17.6 KB

12

Okay I will send through mail also please try update all the packages to the latest version…thanks

13

Hi, I tried your method but the roadblock is that bot is unable to pick aanames from each row while using While activity. Error is that the bot is unable to find the Ui Element when it tries to get the aaname of row elements as it moves down from row 1.

Below I am pasting selector screenshot of 2 different elements.

image
image1120×93 5.72 KB

image
image1127×106 6.08 KB

Elements CL1 and CL2, both have same Table Row.

14

Hi,

I was able to fix the issue by making Parent ID dynamic instead of tableRows. PFB screenshot.
image

Only thing I am stuck at now is ending the While Loop when condition is met. I am using Studio 2019 and it says Break Activity can only be used inside For Each loop. Could you suggest an alternative to break activity here.

15

Hi @tilarapiyush

You have to give condition in while loop ,

like if you set a variable 0 at start(before while loop) and once your condition met you have to make the variable value to 1.so that is will comes out of the loop.