Concat values in a column into a string

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


desired output =;;

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)

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.

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


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)


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

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