How to pass the specific cell value in 'Find/Replace Value' Activity

Suresh_Ghadai · July 1, 2022, 10:22am

Hi Team,

The flow is running in a for each loop. I want to search a specific keyword in a particular row not in entire data table. How to pass the particular row value in Found AT ?

Please let me know if you need more information…

sb001 · July 1, 2022, 10:28am

It will give you a Range as an Output Where it has found Searched Value.
e.g. You have Searched for an value “5” in your Excel Column So it Will Give Its Cell Range Like “A5” or Whatever it is.

Let me know if you have any Query.

Yoichi · July 1, 2022, 10:41am

Hi,

The flow is running in a for each loop. I want to search a specific keyword in a particular row not in entire data table

If you want to replace specific keyword in specific column, the following might help you.

Regards,

Suresh_Ghadai · July 1, 2022, 10:59am

No, i am using Replace activity.

For example , if i am searching the keyword ‘India’ which may be exists in multiple rows of that data table. Since the flow is in a for each row, it has to search the keyword ‘India’ in that row value however it is searching the all the rows and replacing the value in other rows as well. My requirement is it has to search ’ India’ in that part row and replace the value in that row only.