Answered

Can't Get "Get Items" Filter to Work for Choice Field

(0) Share

Report

Posted on by tsmolskow

Hello Community!

I'm working with Power Automate, and I need to create a "Get Items" action that filters on a choice field. First, I capture the current items Choice selection in a variable:

Then I try to use that variable as a filter:

But unfortunately, I get errors like this:

The expression "Enterprise SharePoint (it/sp) eq Enterprise SharePoint (it/sp)" is not valid. Creating query failed.

When I look at this comparison, I think it's a match. Has anyone else seen and solved this problem? If you have, please share the way to solve it along with examples.

Thanks!

Tom

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

R2D2CS 9 on at

Like (0)

Report

Its been a long time since I've done it and I don't have any sharepoint lists to test with but I "think" you need to put the field3.value dynamic content in 'single quotes'

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@tsmolskow Your filter query is incorrect. You need to include the internal column name of your Choice column. Keep in mind that the internal column name may not always match the column name displayed in your Sharepoint list. If you aren't sure how to get the Internal Column name, you can refer to this section of one of my YT Tutorials.

Not sure how to write a filter query? Check out this YT short.

If you have more than 100 items in your SP list, you will need to toggle on pagination and set a threshold. The Get Items action returns 100 items per call by default, if you want more items returned per call you'll need to toggle on pagination and set a threshold. The threshold max is 5000.

Additionally, whenever I use a Filter Query in a Get Items action, I always like to return the count of items returned in a Compose action. This is helpful when building a flow and can also be used to troubleshoot your flow.

Insert a Compose action. Add an Expression. Use the length() function.

Select the Dynamic content tab and insert the value dynamic content from the Get Items action into the length() function.

Run a test.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
tsmolskow on at

Like (0)

Report

Hey A Creative Opinion,

Thank you for your advice, and I certainly will try out your trick with the Compose Action. Unfortunately, after adding the field name to my Query Filter, I still get an error message. Here is the query setting:
Here is the error:
The expression "field_3 eq Information Technology (it)" is not valid. Creating query failed.

I thought the parathesis might be the problem, so I tried this code in both a variable to hold the edited items value and the filter comparison value, but it still errors out.
replace(replace(replace(triggerBody()?['field_3']?['Value'],'(',''),')',''),'/','')

Any thoughts?

Was this reply helpful? Yes No
Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@tsmolskow You are missing single quotes around your variable. I also don't think using a variable is necessary in your case. Whenever you are using strings in the Filter Query field, you need to ensure you wrap your string in single quotes.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No