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

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

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,985)