Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Separate results and check if results has more than 1 value


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.






Community Champion
Community Champion

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



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

Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!

If you want you can follow me at Quieres contenido en español? Síguenos en Power Automate LA
Frequent Visitor

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

Helpful resources

Canadian Cloud 2022 768x460.png

Register for a free PVA chatbot creation workshop.

Learn how to respond rapidly to your customers and employees at scale, using intelligent conversational chatbots.

Users online (3,391)