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.

PVA Community Blog Build Carousel (1) (1).png

What does the community say?

Discover what our community thinks about the announcements at Build 2022.

June 14th PVA AMA Carousel (up on May 25th, take down June 15th) (1).png

'Ask Microsoft Anything' about Power Virtual Agents!

Join the community to ask questions and provide helpful answers about Microsoft's conversational AI and Power Virtual Agents.

Users online (1,943)