
Announcements
Hi All,
There are multiple rows for 1 value in excel and flow returns only the first value.. Input from the bot triggers the flow and this is the flow structure ;
Example:
| Column A | Column B |
| 1 | Apple |
| 2 | Seattle |
| 3 | John |
| 3 | Rick |
| 3 | Tim |
| 3 | Gigi |
| 3 | Sam |
| 4 | Banana |
Key Column : Column A and Key Value : 3 and flow result is : John
How can i get all the values (John, Rick, Tim, Gigi, Sam) returned for one key value please ?
Thank you for your responses.
B.
I got this sorted out by using list rows + array variable.. thank you.