Answered

Get Items and OData Filter

(0) Share

Report

Posted on by 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?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Jay-Encodian 2,920 on at

Like (0)

Report
Copy link

Link copied!

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-microsoft-flow/

HTH

Jay

Was this reply helpful? Yes No
bupshaw 12 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (2)

Report
Copy link

Link copied!

Hi

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

Hope it helps

Was this reply helpful? Yes No
Jay-Encodian 2,920 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
bupshaw 12 on at

Like (0)

Report
Copy link

Link copied!

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]).

Was this reply helpful? Yes No
Jcook 7,783 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-litu-msft Microsoft Employee on at

Like (4)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No