Remove duplicate values from Find Children and write it into Excel

Help Studio
, ,
1

When I use Find Children. Im getting duplicate values and space between two lines for eg
MicrosoftTeams-image (120)

w-10
w-10

w-11
w-11

and so on.
I want to remove duplicate values and line space and click on the form the forms can vary it can one or more than one.

I also want to store that value in excel in this format:
image

I dont need “Add new Employee also”

Can anyone please help

2

@Bhushan_Nagaonkar

Assign cleanedData = outputElements.Select(Function(e) e.Get(“innertext”).ToString.Trim).Distinct.ToList

3

And I also want to click on that form and extract certain data is that possible?
MicrosoftTeams-image (121)

Every form has same template. I want to extract and write into excel

4

MicrosoftTeams-image (123)
MicrosoftTeams-image (123)815×284 14.6 KB

Im getting this error

5

@Bhushan_Nagaonkar

Is CurrentItem is the find childern activity output, If its not give the find childern activity output

6

Yes. I have passed current ITem. As you can see. Or i did it wrong.
Following is my code
currentItem.Select(Function(e) e.Get(“text”).ToString.Trim).Distinct.ToList

7

@Bhushan_Nagaonkar

CurrentItem Datatype is IEnumerable of UiElement which stores the find childern activity output

8

Hi @Bhushan_Nagaonkar ,

I believe you are using a For Each activity and the instance currentItem is created within it.

You would require to use the variable which is passed to the For Each activity as a List.

Also, the Expression would eliminate the use of For Each activity, we would not need to use it.

9

Is it correct then or should I modify this expression

10

Ok, Thanks I will pass that value.