I am new RPA dev, need help.
I have a workflow ready, I am reading excel column and in that col there will be 1 value e.g(D5, JK or LD) any such combination. I need to do further process on that value and find the output for that value.
This I did. But now as per changed business requirement, there will be values separated by comma, or cell can be blank as well, or there will be only value, or many,
I want to run my exiting workflow for these values, I can used for each value and can process.
how to read those value dynamically?
if no values then e should display log msg
if values there split with comma, remove spaces if any,
for each value ( further i have workflow)
<For Each Row In="{x:Reference dt}" DisplayName="For Each Row">
<Sequence>
<!-- Get the value from the specific column -->
<Assign DisplayName="Get Column Value" To="[colValue]" Value="[currentRow("YourColumnName").ToString()]" />
<!-- Check if the cell is empty -->
<If Condition="[String.IsNullOrEmpty(colValue)]">
<Then>
<Log Message Level="Info" Message="No values to process." />
</Then>
<Else>
<Sequence>
<!-- Split the values by comma and trim spaces -->
<Assign DisplayName="Split Values" To="[valuesArray]" Value="[colValue.Split({","c}, StringSplitOptions.RemoveEmptyEntries).Select(Function(s) s.Trim()).ToArray()]" />
<!-- Iterate through each value -->
<For Each Item In="{x:Reference valuesArray}">
<Body>
<!-- Process each value -->
<Invoke Workflow File WorkflowFileName="path\to\your\existing\workflow.xaml" Arguments="value: item" />
</Body>
</For Each>
</Sequence>
</Else>
</If>
</Sequence>
</For Each>