Condition for the list

Help Apps
, ,
1

image
In this I need to give condition like
If the list is more than one and less than one i need to update the status in the excel sheet as “ERROR”
else:
click on the list
Please help me with this So urgent…

2

which list

3

Under the CNP bro its having the single row i need to get the count of that and need to give condition as mentioned
I tried datascrapping its not working in the application

4

Bro use data scraping and count the database
database.rows.count
then give the condition based on the count

I hope it will help try once like this

5

image
Error bro

6

Hmm Then we have to go through selectors this also new thing i will try to give solution
or these people help you
@Yoichi @NIVED_NAMBIAR
Help him and am also watch this topic please help us

7

Can you please share the selector of the application i.e list(table)

8

I need to indicate on the only one present below or else i need to indicate that whole list space
like
image

9

no only one because we have to check the data by increment the selector and bot will search the seletor if its not present so we can come out of the loop we have to use do will like this if bot through the error then break the loop and if the count value is less than one or one we can update the status error

like this i don’t know its work or not try once

1 Like
10

image
image1339×641 48.2 KB

I think we cant increment here there is no idx value

11

Hi @Sudharsan_Ka
if the datascrapping won’t work, you can try with screenscrapping, Screen scrape the tabular region and u will get the data in string format

Now i am assuming that CNP columns are numbers and had fixed digits everytime.

Now using string u had obtained as output from screenscrapping, use the below regex way to get the count of rows

count=System.Text.RegularExpressions.Regex.Matches(input_string,“\d{13}”).Count

the count variable stores the count of how many CDP column values are there [ which is equal to number of rows]

so count is equal to number of rows, by this u will get the rows count and u can further use the datatable manipulation to update the excel value based on count variable

Hope the information help you

Regards,
Nived N
Happy Automation

1 Like
12

I will try and get back to you bro

13

yes it will work thanks once again

2 Likes
14

Hi @Sudharsan_Ka

i had small correction in using regex, hope you will find that

15

Bro whether it will work dynamically bro

16

U had make it dynamic actually while screenscrapping

Just try for one case and see whether it is working fine or not

17

I am new to UIpath bro please correct the mistake ,so i can test it

18

I had done that already in the reply [edited it]

1 Like
19

Bro tried and got 1 in the message box ,What i need to change to make work dynamically

20

Hi @Sudharsan_AIT
can u show the selector of screen scrapping activity , from this u can find any dynamic attribute value, replace that dynamic value by using asterk (*) sign