cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

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
New Member

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
Community Support
Community Support

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

 

New Member

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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (12,215)