Unanswered

SharePoint Get Items - ODATA Filter Help

(0) Share

Report

Posted on by greddin1

Hi all,

I'm having trouble using the SharePoint Get Items action when filtering by a Lookup column. I'm not getting any results when I know there should be. The output value of the Get Items always returns empty.

Here's the flow:

Here is the list. If I pass in P2404002 I expect to see four items returned.

This is the configuration of the Project No Lookup column.

Thanks,

-Greg

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@greddin1

Try this - use Project_x0020_No/Title instead of Project_x0020_No

Please let me know if this wors for you.

Was this reply helpful? Yes No
greddin1 86 on at

Like (0)

Report

Thanks Scott. I tried that but still no results.

Was this reply helpful? Yes No
greddin1 86 on at

Like (0)

Report

I've also tried Project_x0020_No/Id as well. But still don't get the results.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@greddin1

I just ran a test using internal_col_name/Title and it works for me.

Make sure that the case of your input matches what is in the list.

Is the lookup column a multi-select?

Was this reply helpful? Yes No
greddin1 86 on at

Like (0)

Report

No, just a single select. Here's the configuration of the field.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@greddin1

Just for fun, try hard coding a Project No in the OData filter and see what happens.

Was this reply helpful? Yes No
greddin1 86 on at

Like (1)

Report

I managed to get it working from reading this post here: https://powerusers.microsoft.com/t5/Building-Flows/ODATA-Filter-queries-on-LookUp-columns-from-a-SP-List/td-p/84882

My query needed to be Project_x0020_No/ProjectID eq ... (where ProjectID is the internal name of the column from the parent list.

Thanks!

Was this reply helpful? Yes No