cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
TWolsten

oDATA Filters?

Submitted by Helper III on ‎07-10-2017 07:27 AM

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
1 Comment (1 New)
Comments
BTbearings
Advocate II
Advocate II
‎06-25-2020 11:18 AM

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.