Answered

OData $filter query not collecting all matching records

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello, I am working on creating a flow that pulls in Azure DevOps query results and populates the results in an Excel table. I then have to filter out out Work Item Types I don't wish to include through and OData $filter. However the OData $filter doesn't always pull all matching records. I have attempted to use both contains and eq. This last run missed 12 rows. How can I improve my solution to capture all rows on every Flow run?

My OData $filter:

The output in Excel:

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-duann-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Thank you for posting.

According to your description, you would like to filter result based on some keywords but always can’t get accurate result. If any misunderstanding, please kindly let me know.

If that’s the case, I recommend you try ‘filter array’ action instead. It has less limitation comparing with ‘filter query’.

Hope the content above may help you.

Best regards,
Anna

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @v-duann-msft ,

I was able to leverage Filter Query to obtain the rows I want. Then I was able to feed it into Parse JSON to iterate over all rows found. Then I could update my table accordingly. Thanks for the help!

-Zach

Was this reply helpful? Yes No