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

[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…