Answered

Filter excel table and return cell value to PVA

Like (0) Share

Report

Posted on 29 Sep 2022 02:12:59 by Angelaei

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!

Categories:

General

All responses (9)

Answers (1)

Angelaei 22 on 06 Oct 2023 at 11:46:39

Like (0)

Report

Re: Filter excel table and return cell value to PVA

Hi, Can you share me your flow?
PowerKid91 2 on 15 Sep 2023 at 19:05:38

Like (0)

Report

Re: Filter excel table and return cell value to PVA

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.
Verified answer

Pstork1 67,170 Most Valuable Professional on 20 Oct 2022 at 11:30:12

Like (0)

Report

Re: Filter excel table and return cell value to PVA

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.
Angelaei 22 on 20 Oct 2022 at 06:48:46

Like (0)

Report

Re: Filter excel table and return cell value to PVA

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?
Pstork1 67,170 Most Valuable Professional on 30 Sep 2022 at 13:10:41

Like (0)

Report

Re: Filter excel table and return cell value to PVA

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.
Angelaei 22 on 30 Sep 2022 at 05:03:55

Like (0)

Report

Re: Filter excel table and return cell value to PVA

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.
Pstork1 67,170 Most Valuable Professional on 29 Sep 2022 at 15:44:45

Like (0)

Report

Re: Filter excel table and return cell value to PVA

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.
Angelaei 22 on 29 Sep 2022 at 03:36:50

Like (0)

Report

Re: Filter excel table and return cell value to PVA

Thanks for the quick response. I tried doing what you said but it failed.

Flow details:
Pstork1 67,170 Most Valuable Professional on 29 Sep 2022 at 03:01:25

Like (0)

Report

Re: Filter excel table and return cell value to PVA

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.