Reading excel information based on the criteria

Dear Community,

I would like to ask how can i amend the workflow so that the workflow able to perform as the following:
1, Read the first column of the excel and search on the browser.
2,If no result found, then only read the second column of the excel and search on the browser again.

Currently, the workflow produce the result as follow.
1.Read the first column of the excel and search on the browser.
2. After that, Read the second column of the excel and search on the browser.

What i plan to do is asking the Uipath to read the second column of the excel if no result was found on the browser based on the first column of the excel information.

I have attached the workflow for reference and appreciate if someone can assist me on this.

Many thanks in advance.
UseCase.21.07.2021.zip (27.5 KB)

  1. Read full excel

  2. Create common workflow for browser activity with in/out arguments
    IN- pass your first column using this condition row(“column1”).tostring
    Out- Get result

  3. Check - If no result found from step 2
    then
    IN(datarow)- pass your second column using this condition row(“column2”).tostring
    Out- Get result

Dear Ganesh,

Have you gone through the workflow that I attached?Could you guide me on which part that I need to add in my workflow ?Screenshot on which part of the workflow would be helpful.

Thank you.

Yes. I saw that. you have to change bit from current flow. Create a new like this as I mentioned

Dear @ganesh4 ,

May i know how to amend it ya?Which part that i can amend?

Thanks

Hi,

Keep it this flow. Can you create a new flow following my steps?

  1. Read full excel
  2. Create common workflow for browser activity with in/out arguments
    IN- pass your first column using this condition row(“column1”).tostring
    Out- Get result
  3. Check - If no result found from step 2
    then
    IN(datarow)- pass your second column using this condition row(“column2”).tostring
    Out- Get result

Dear Ganesh,

Could you guide me on how to do the step 3?

Thanks

What is the output from column search?