How to Select a Row in CV Table by Matching Text from a Variable?

[Praveen_B]

Hi all,

I’m working with UiPath Computer Vision inside a CV Screen Scope, where I can extract table data using CV Extract Table.
I have a string variable, for example:

targetText = "832477"

I want to click a specific row in the CV table where one of the cells matches this variable.

Here’s what I tried so far:

• Extracted the table using CV Extract Table into a variable “EncounterValue”.
• Tried looping through the rows and checking row("EncounterValue").ToString = descriptorString
• But I’m not sure how to pass that row element to CV Click so it clicks the exact cell or row.

Question:
Once I have the match, how can I pass it directly to CV Click without hardcoding the descriptor?

Any example workflow or snippet would be greatly appreciated!

Thanks in advance,
Praveen

[adi.mehare (Aditya Mehare)]

By using below expression in assign activity you can get a table row

if you know column name
targetRow = dataTable.AsEnumerable().FirstOrDefault(Function(row) row("<ColumnName>").ToString().Trim() = targetText)

if you don’t know column name

targetRow = dataTable.AsEnumerable().FirstOrDefault(Function(row) row.ItemArray.Any(Function(cell) cell.ToString() = targetText))

For CV Click using variable check below links

Problem selecting line in grid recognized as one big element - Winforms application

If you have some variable to pass pass it to the description. Refer below post

CV Click with dynamic selector

Hi @Rahul_Unnikrishnan, @Sudharsan_Ka, @ushu if I click on number: [photo_2022-10-12_11-00-52] I can make selector to this field only. If I enter {{vcRowNumber}}, then it will be replaced with initial ‘2’. If I do not click on any number, then target appears only like this: [photo_2022-10-12_11-03-06] It is a desktop application. Thx and kind regards, Vanja

CV Click descriptor

I have an automation that I need to click a specific number within a table on a Cerner application. I have given it a target to see how the click works and noticed it uses coordinates, but when I remove the coordinates I get an error. I have tried so many things I can’t write them all down here, but is there a way to pass a variable into the CV click descriptor without coordinates? This automation goes through a CSV file to open an account, sometimes these accounts have multiple account encounte…

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @Praveen_B

You can specify like below for your cv click activity(sample below) where anchor would specify the text “832477” from your variable.

“Target: TableCell (271,85,552,201)” +
“ColumnName: 12345 (420,85,398,26) Accuracy:0.95” +
“RowContains: Licence Class: (271,111,149,24) RowCell: 1” +
“Anchor: Text ‘“+target text variable goes here+”’ (400,53,174,14) Accuracy:0.95”

[Praveen_B]

Hi Sonali,
Thanks a lot for your detailed explanation and example. I tried your approach and it worked perfectly – I can now match the row based on targetText and click it dynamically without hardcoding the descriptor. Appreciate your help!

[Praveen_B]

Thank you for the quick response and guidance.

[sonaliaggarwal47 (Sonali Aggarwal)]

@Praveen_B

Glad to know I could help