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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Users online (71,092)