Sharepoint list Get Items query filter: The expression is not valid.

[solte98]

Hi,

I have an issue with a Flow Sharepoint Get Items action.

Its a very simple filter that tries to get an item of a sharepoint list (lets call it List A) based on a value from another sharepoint list (Lets call that List B).  The Value in Column Title List A is 'Sol'.  List B Title has unique values, so I want to filter it out and only get the items that has 'Sol' in the Title.

The query is as follows

Title eq 'Title'

Which is

Title eq 'Sol'

But I get a invalid expression

The expression "Title
 eq 'Sol'" is not valid.
clientRequestId: 9704f697-51c7-47de-972e-40d0f764ba7e
serviceRequestId: 5abf9f9e-d0d9-7000-fe72-a61f41d61aed

I tried manually enterting the string 'Sol' but still the same.

If I remove the fiilter, I can see that the value is there

{
  "value": [
    {
      "@odata.etag": "\"5\"",
      "ItemInternalId": "1",
      "ID": 1,
      "Title": "Sol",
      "Email_x0020_address": "sol@it-x.co.uk",
      "Allocated_x0020_number_x0020_of_": 40,
      

blah blah blah

Now, I do have a work around where I use a condition and not use a a filter, BUT would like to see if I can work with a simple filter

[v-yuazh-msft · Accepted solution]

Hi @solte98,

You should use expression:

Title eq 'Title dynamic content of the item in List A'

I have made a test on my side to create a flow as below:

And the expression in the Filter Array column as below:

Title eq '@{triggerBody()?['Title']}'

When an item is created in the List A and the Title is Sol, the flow would run successfully as below:

Best regards,

Alice