You’re offline. This is a read only version of the page.
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
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!
Just for fun, try hard coding a Project No in the OData filter and see what happens.
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?
Try this - use Project_x0020_No/Title instead of Project_x0020_No
Please let me know if this wors for you.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (
