Separate results and check if results has more than 1 value

[Tak103]

Hi:

I had pull the answers from the Excel and had append the results to the output but in using the append, it concatenated all the results into one variable. How can I separate the results so that they are not all combine into 1 string in the variable. This is needed as I need to check if there are multiple answers. If there are, I need to ask them to rephrase the question. Would appreciate any guidance on how I can separate the results that I got from looking up on the Excel and also how I can check if there are multiple answers being return.

Thanks,

[ChristianAbata]

hi @Tak103  what you can do is add a separator in your append like this

YOURtext,

coma is separator.

Then you can use in a compose action the expression split("Yourtext",",") using the separator. So then as result you will have separated data in an array variable

[Tak103]

Thanks Christian. How will I check if multiple rows have been returned so that if 1 row is returned, I can then provide the answer but if multiple rows are returned, then ask them if they want to refine their question?  Thanks