Notifications
Announcements
Hi! I want to filter excel based on the user's input. The result in the status column will then be returned by the bot to the user. Below is the flow I'm currently using but I can't get it to work. Result should be 1 value (status) only and if no data was found based on the input, it should return 0 (though I have yet to include this in the return values). Thanks in advance for the help!
When you look at the result of a run is the Yes side of the condition being selected? If not, I would add a compose just before the condition to load the filtered array so you can look at the value and compare it to the one that was input. Case sensitivity can be a problem. Extra spaces can also throw of the comparison.
Thanks for the quick response. I tried doing what you said but it failed.
Flow details:
Your return failed because the flow timed out. The problem is probably that you are writing to a variable inside a loop. That can take a significant amount of time. In your case over 2 minutes, which is why it timed out. You need to find a way to streamline the loop you are using. Have you enabled parallelism for the Apply to Each loop? That an usually improve performance.
Thanks for the suggestion. I tried using enabling parallelism - it worked but it returned a lot of values from that column. I double checked my source data and there is really just 1 result that match the input data.
I just noticed that your loop is using the output from List Rows. Shouldn't you be using the output from your filter array? If you loop on all the rows in the list you'll get a lot of loops and if it finds the same record on each loop you'll get duplicates.
Hi! Thanks for your suggestion. I changed the loop using the output from filter array - it worked and filtered the result but returned values from all columns from the same row. How can I make it show the result of only one column?
That's controlled by what you specify you want to return. If you only want one column make sure you pick only one column not the who record.
Hi, could you share your working flow please? I'm running into the same issue where I'm trying to pull data from specific Excel rows, but it's not filtering properly for some reason.
Hi, Can you share me your flow?
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 436
chiaraalina 145 Super User 2026 Season 1
Michael E. Gernaey 98 Moderator
