Find the row index if a particular keyword is present in a particular Column

Help
1

Hi,

I want to get the row index of the row which has the status "1. Neu " in “Status” column(L).
I am able to get the status if “1. Neu” by creating a Boolean variable, but unable to get the row index of the same.
Kindly assist.

image
image1313×420 10.3 KB

2

Have you tried this activity -

3

Yes, but I need help with searching for the row index for that specific cell

4

image
image862×135 20.7 KB

Can I know what output you are getting when using lookup range?

5

I get a null value

6

It means is it unable to find the value in the given range.
Can you please check for the value present in the excel.
This activity returns the range string where it found the look up value.

Regards,
Karthik

7

Can you help me with the logic to get the row index for that row?

8

I will send you the sample XAML file with 1 or 2 solutions by today evening.

Regards,
Karthik Byggari

9

Hi Karthik,

Did you manage to get time to look into the solution.

Thanks,
Nikhila

10

Hi Nikhila,

I am really sorry for not sending you the workflow. I will send you today for sure.

Regards,
Karthik Byggari

11

Thanks.

12

TestProcess.zip (30.5 KB)

Output:

image
image1923×1129 113 KB

13

Thanks Karthik

1 Like
14

Hi @KarthikByggari

Can you please share the xaml file, bze am not able to download the zip folder