cancel
Showing results for 
Search instead for 
Did you mean: 

oDATA Filters?

Hey,

 

I wonder if anyone can help.

 

I have two lists in SharePoint 'Change List' and the 'Admin List'.

 

I am using the Get Items function in Flow to pull one value out from the list.

 

The Get Items is querying the 'Admin List' and then I am using the a value from the 'Change List' [Change Ref] on the Filter Query to pull out that one value.

 

f.jpg

 

However, it pulls the below Gateway error?

 

d.jpg

 

As you can see it is using the correct value from the 'Change List' to filter [61] but it is not finding the value in the 'Admin List' even though it is there?

 

Do I have to specify which column the filter gets applied to, and if so how would I go about doing that?

 

Any help would be greatly appreicated.

Status: New
Comments
BTbearings
Advocate II

I'm not an expert on this, but I believe that you do have to specify the column name to search through.  So, for this example, if you wanted to look through a column called 'Reference' in the SP list 'Admin List' for a value that matched the particular value, you would enter the following in the "Filter Query" field:

Reference eq XXXX

 

Note: the XXX is the structured reference you already have.  Also, be aware of integer vs. string issues.  If the 'Reference' column in 'Admin List' is an integer type, than enter the search as above.  If it is a string type, then you have to manually put apostrophes before and after the structured reference.