list rows present in a table - query filter with dynamic content

[echo_davidG]

Hi all,

I'm struggling a lot with one little step of my pipeline:

I'm trying to filter the content of a table using "query filter" attribute. It returns nothing and I can't fathom what's going wrong in my parameters:

 here "batchID" is just an integer.

I can see it is handled correctly in the flow history (the variable is replaced by its value):

but the output is empty ...

When I replace the variable by, let's say, the value 9 in the parameters everything is works fine .... but it's no longer usable as I need to capture the batchID value dynamically.

I've tried to change the variable into a string but it's still not working.

Any ideas about what I am doing wrong ? I've read many post on the subject but no solution worked for me.

Thanks and best,

David

[v-siky-msft]

Hi @echo_davidG ,

Could you please share more details about your scenario? What is data structure of table1? How did you set the variable value?

If the batchID is a Number field, please try to remove the single quotes around the variable, since single quotes format the variable as non-numeric type.

Hope this helps.

Sik

[echo_davidG · Accepted solution]

Hi @v-siky-msft 

Thanks a lot for your anwer.

Here is what I tried to achieve:

1. user fill a very basic form 
2. when answer is submitted, this flow fills-in an excel spreadsheet with many information (batchID among others, batchID is increased by one for each new form submission).
3. Return to the user the rows he just added to the table, using batchID as filter

For that, I'm listing the rows of the main spreadhseet and I wanted to filter using batchID... that's were I was stuck. When I'm not using a dynamic content it's perfectly working (with single quotes) but as soon as I want to get the batchID for this session it's not returning anything. What is frustrating me is that I can see the correct filtering query in the flow execution history and if I copy/paste it, it works !

Anyway, I've found a workaround: I'm now getting all rows from the table, then I use "filter array" + "parse json" and it works fine. 

batchID is indeed a numerical value, I tried the two following options without success in the "list from from a table" component:

- removing single quote

- changing the variable type to non-numeric type

I can mark this issue as "solved" even if I used a workaround, hope this will help someone in the future

Cheers;