Taking the datas in a column, search these datas in a website and click on a specific line

[Al_Bert]

Hi all,

I want to take the datas from the column A:

And when the first finding value , click on the trigger text : “Etat d’avancement du dossier”

Thanks to futur your ideas , I continue to seach in my side.

AL

[Pankaj.Patil (Robot Master)]

@Al_Bert,

You’ll have to read excel using Read Range activity,
it will return result in datatable which will contain more than one 1 record.
Iterate it using For Each Row activity and provide datatable to it.
inside for each row, write row(“Column-0”).ToString in field where you want to write it and search.

[Al_Bert]

Hi Pankaj.Patil,

I’ve started my workflow like this:

[Pankaj.Patil (Robot Master)]

@Pankaj.Patil

row(“Column-0”).ToString

@Al_Bert,

Please use String.IsNullOrEmpty to check if string is empty or not

If String.IsNullOrEmpty(row(“Column-0”).ToString)){

}

Write row(“Column-0”).ToString in type into activity.

[Al_Bert]

@Pankaj.Patil

String.IsNullOrEmpty(row(“Column-0”).ToString)){

}

Ok, I changed it like this :

But it should match the row and click on the trigger text : “Etat d’avancement du dossier”

[Pankaj.Patil (Robot Master)]

@Al_Bert

But it should match the row and click on the trigger text

@Al_Bert,

Please show selector of this ui element OR you can use ui explorer to make reliable selector.

[Al_Bert]

@Pankaj.Patil

Please show selector of this ui element OR you can use ui explorer to make reliable selector.

[Pankaj.Patil (Robot Master)]

@Al_Bert,

Include Class and innertext and remove innertext until Etat d’avancement du dossier and keep only Etat d’avancement du dossier.
Exclude css-selector from selector

let me know

[Al_Bert]

Same problem :