Answered

Get Items Filter query by Item ID not returning value

(0) Share

Report

Posted on by elansr

I'm trying to use a Filter Query to return the ID of an item from a list using a variable. It works fine when I manualy type in the query as follows:

Title eq 'Cory Ave '

But when I use a variable it fails. The variable is an item from a different list. Is the variable type within the query a potential problem? What else could be causing this?

Here is the flow with a variable in the query:

Query 2.png

Here is the flow with hardcoded query:

Query 4.png

This screenshot is from the successful run returning a single record from the filter:

Query 3.png

This screenshot is from the failed run with no output resulting from the filter.

Thanks, Elan

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @elansr ,

In general, variable values can definitely be used as filter criteria in Filter Query.

We often use Created to compare with utcNow(), so this is for sure.

I am curious why the number of items traversed during the two tests is different, one is 13 and the other is 14, I wonder if this will be the reason for the test results.

Please try reconfiguring Filter Query, noting the location of the space, the field name, and the parameter type.

Please take a try again.

Best Regards,

Was this reply helpful? Yes No
elansr 4 on at

Like (0)

Report
Copy link

Link copied!

Excuse my lack of experience, but can you explain or give an example of what you mean by "We often use Created to compare with utcNow(), so this is for sure."

Thanks!

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Like:

Regards,

Was this reply helpful? Yes No