cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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:

 

echo_davidG_0-1606317609301.png

 here "batchID" is just an integer.

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

echo_davidG_1-1606317702390.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

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;

View solution in original post

2 REPLIES 2
v-siky-msft
Community Support
Community Support

Hi @Anonymous ,

 

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

 

Anonymous
Not applicable

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;

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,757)