Concat values in a column into a string

Help Activities
,
1

Hi … I am trying to concatenate all the values in a columm into a string.

Email
a@gmail.com
b@gmail.com
c@gmail.com

desired output = a@gmail.com; b@gmail.com; c@gmail.com

Steps taken

  1. read range workbook. Output = EstMeetingTB
  2. assign
    EmailList =String.Join(“;”,EstMeetingTB.AsEnumerable().Select(Function(a) a.Field(of string)(“Email”)).ToArray()).

I get the following error: System.NotSupportedException: Expression Activity type 'VisualBasicValue1' requires compilation in order to run. Please ensure that the workflow has been compiled. at System.Activities.Expressions.CompiledExpressionInvoker.InvokeExpression(ActivityContext activityContext) at Microsoft.VisualBasic.Activities.VisualBasicValue1.Execute(CodeActivityContext context)
at System.Activities.CodeActivity1.InternalExecuteInResolutionContext(CodeActivityContext context) at System.Activities.Runtime.ActivityExecutor.ExecuteInResolutionContext[T](ActivityInstance parentInstance, Activity1 expressionActivity)
at System.Activities.InArgument1.TryPopulateValue(LocationEnvironment targetEnvironment, ActivityInstance activityInstance, ActivityExecutor executor) at System.Activities.RuntimeArgument.TryPopulateValue(LocationEnvironment targetEnvironment, ActivityInstance targetActivityInstance, ActivityExecutor executor, Object argumentValueOverride, Location resultLocation, Boolean skipFastPath) at System.Activities.ActivityInstance.InternalTryPopulateArgumentValueOrScheduleExpression(RuntimeArgument argument, Int32 nextArgumentIndex, ActivityExecutor executor, IDictionary2 argumentValueOverrides, Location resultLocation, Boolean isDynamicUpdate)
at System.Activities.ActivityInstance.ResolveArguments(ActivityExecutor executor, IDictionary`2 argumentValueOverrides, Location resultLocation, Int32 startIndex)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

2

This can currently occur if the Studio version and UiPath.System.Activities Package version does not harmonize. Just set the package version a few versions lower and test again.

3

It did not work. I am using studio 2023.4.2 Below are the package versions I am using:

image
image1348×500 44.6 KB

4

Hi,

This error may be caused by double quote except " (0x22). For now, can you try to replace all the double quotes with " ?(If necessary, copy and paste this character)

Regards,

5

It worked. Thanks so much for your help!!!

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.