Getting SharePoint list item(s) from a related list

[guyinkalamazoo]

This is the first flow where I am using oData filter, but I am not sure of the syntax.  I was going to pull in the whole list and do a condition, but I saw that the oData filter is more effective.  I have a list that gets report data from a power app.  This report data primary key is the DFRID.  The same ID is sometimes saved back to a different list based on certain conditions entered in the report, but not always.  When I test the flow, I get an error - Column 'DFR00004' does not exist. It may have been deleted by another user.  Is this because in this case, the report did not have to save a record to this other table?  Here is the syntax that I have for the oData filter. DFRID is a value coming from getting the new item from the parent list.

Thanks for the information

[jinivthakkar · Accepted solution]

@guyinkalamazoo you are missing single quote(') before and after the dynamic value

just try Title eq 'dynamic value' 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[guyinkalamazoo]

Thanks!  That did the trick