Announcements
I am using an Excel to extract the results from the question. I will be using a compose action with the expression split("Yourtext",",") using the separator. So the result you will have separated data in an array variable instead of all the results combining into 1 string. How do I check if there are more than 1 results because if there are more than 1 results, I will need to send a msg to user to either refine the question or send e-mail to group for help. Appreciate any guidance in advance.
Thanks,
Hi @Tak103,
You could use a length function in an expression to check the outputs of your compose action:
length(outputs('Compose'))
The expression could be used in a condition action with an operator like is greater than 1.
Unfortunate, the answer length can vary. If I were to use split("Yourtext",",") using the separator to separate the results in an array variable. Will I be able to count how many is in the array variable? If this is a sound approach, would you be able to share with me how I can do this.
That is why I suggested to use a length function, this type of function can count the number of items in an array. It doesn't matter how much items there are in that array, it will just output a number.
When the array has 3 items it will output 3. When it has 10 items it will output 10 as a result.
Can you share a screenshot of your current setup? I can adapt my previous example to your setup 😀
Thanks. I am totally new to this so much appreciate it.
I don't see a screenshot. Can you try and attach it again to your post?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 227
sannavajjala87 208 Super User 2026 Season 1
Valantis 198
