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
Solved! Go to Solution.
Hi @v-siky-msft
Thanks a lot for your anwer.
Here is what I tried to achieve:
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;
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
Hi @v-siky-msft
Thanks a lot for your anwer.
Here is what I tried to achieve:
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;
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
15 | |
10 | |
3 | |
3 | |
3 |