I need to give an input box where the user updates string of values example -YY, AB, CD… sepearted by a comma. I use a for each loop to run each string i need to use a type into activity for each string how do i write that?
You can split the input provide by the user and the output of split will be array. Now, you can iterate through array using for loop and put the type into activity inside that for loop and provide the current element array as parameter to type into activity.
Instead of Message box use Type into activity @RACHEL_PAUL
Thank you for the response i will check and get back to you on this.
I need to store these values in a excel sheet but it does not store only the last value does
Which activity did you used? Can you share the Screenshot of your workflow?
The type into works perfect but i need to store the values of strings in a excel sheet how do i do that
can you share the details of “How you want to save data in Excel”?
Under a column called colA
You can use append range activity to do that. OR you can maintain one datatable and add row in it every time. Place it inside the loop only.
You can try with Add Data Row activity
Please elaborate with screenshot and data
i want the output to look like this, how can i achieve that?
Hi @RACHEL_PAUL ,
Could you let us know what would be the Input for this Dialog ?
How are you adding the values or in which format.
U can give A,B
Could you check the below modified workflow :
Main.xaml (19.3 KB)
I have used a Linq approach for this operation as it seemed convenient to use it, than looping and adding the values to a list and preparing it in the output format.
I have commented UtMarks For Loop and used a Linq expression to get the format to match as the output.
Let us know if you are still facing issues or do you wish to revert back to the old approach.
if i give another input box for comments how to i write assign activity in the for each loop?