Get Items and OData Filter

[bupshaw]

I am trying to use Get Items action from SharePoint with the filter query.  However, nothing I do seems to allow this action to work.  All I receive is "BadRequest" with no additional error information.

I am trying to find a list item where the "Full Name" column matches the value I provide.  The string I'm searching for is a piece of dynamic content.  I have tried all of the following combinations:

Full Name eq '<string>' - Didn't expect this to work

Full_x0020_Name eq '<string'> - Found on the forms as a possible solution

Full%5Fx0020%5FName eq '<string>' - From the Edit Column page's URL

Then I tried renaming the column to just FullName, and hen trying

FullName eq '<string>'

The string is valid and I can verify via the Run History that it contains data and the dynamic content is doing its thing.  But, again, the only error I get is "BadRequest" with no additional error codes.

Top Count is set to "1" so as to only return one result from the search.

Thoughts?

[Jay-Encodian]

Hi @bupshaw 

First thing to check... does the action execute succesfullt without the filter query? if it does then it it's an issue with the query... if not it's something else.

If it's the query; check the internal column name... this can be found by going into the SharePoint lists settings and clicking on the column... you can check the actual name in the Field url parameter:

To query this column I'd use: Test_x0020_MetaData eq 'value'

A useful reference: https://www.chakkaradeep.com/2018/05/01/deep-dive-into-get-items-and-get-files-sharepoint-actions-in...

HTH

Jay

[bupshaw]

Thanks for the quick reply.  From my original post, I've already tried that:

Full%5Fx0020%5FName eq '<string>' - From the Edit Column page's URL

I had seen similar advice on here and gave it a shot before posting.

EDIT:  Missed the first part of your post, I'll check if it works without the filter at all really quick.

EDIT 2:  @Jay-Encodian  yes it works without the filter.

[efialttes]

Hi

Is you column defined as 'Single line of text' in your SP list? Or is it a lookup, choice...?

Hope it helps

[Jay-Encodian]

Hi @bupshaw 

It would be: Full_x0020_Name eq 'value'

Full%5Fx0020%5FName is encoded... once decoded its: Full_x0020_Name

But it looks like you've tried that... so as @efialttes points outs, can you confirm the column type?

Cheers J

[bupshaw]

Hi @Jay-Encodian 

It is a calculated value column.  The list was originally constructed with just First Name and Last Name columns, and the formula for the column is just =CONCATENATE([FirstName]," ",[LastName]).

[Jcook]

Hi,

Where is the dynamic content coming from?

Have you tried to wrap your dynamic content In a string() expression?

Also when you do a get items without filter. Check the output in the run and see what the column is being called in there.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[v-litu-msft · Accepted solution]

Hi @bupshaw,

Unfortunately, field type 'Calculated' cannot be used in the query filter expression.

As a workaround, you could use the syntax in the ODATA filter query:

FirstName eq 'Bob' and LastName eq 'Dylan'

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.