How to Join values from one column of UiPath entity in one variable in UiPath apps?

[deepakchawla]

Hi Team,

I have to join all emails whose status is activity in string variable from UiPath entity in UiPath apps

Entity Name - Email

UserName Email Status
Test Test@gmail.com Active
Test1 Test1@gmail.com Disabled
Test2 Test2@gmail.com Active

Can anyone help me creating query in UiPath app ?

Thanks in Advance.

Regards,
Deepak

[Anil_G (Anil Gorthi)]

@deepakchawla

say the entity is assigned to a variable varEntity

then String.Join(",",varEntity.Data.Where(function(x) x.Status.ToString.Equals("Active")).Select(function(x) x.Email.ToString))

this will join all emails with comma

cheers

[deepakchawla]

working fine, thank you very much