You’re offline. This is a read only version of the page.
Hi all, I would like to create a Dataverse O-Data filter with an IN operator.
My O-Data filter query looks like this:
https://i.imgur.com/Bl6q2RK.png
According to this doc, this should not be a problem:
https://learn.microsoft.com/en-us/odata/webapi/in-operator#:~:text=GET%20/service/Products%3F%24filter%3DName%20in%20(%27Milk%27%2C%20%27Cheese%27%2C%20%27Donut%27)
Unfortunately, the action always fails after several attempts:
https://i.imgur.com/8B9LNIp.png
I was able to find in this post that there is a restriction for the "List Rows in present table" action in Excel:
https://powerusers.microsoft.com/t5/Using-Flows/IN-operator-equivalent-in-OData-PowerAutomate/td-p/657097
In the Dataverse documentation I could not find this restriction (or I read it over?):
https://learn.microsoft.com/en-us/connectors/commondataserviceforapps/#list-rows
In general, the goal is as follows:
I want to compare which rows in the "Topics" table are already created (i.e. occur in my static array of the odata filter query) and which are new. So I would have to negate the OData filter later...
Does anyone have experience with this or another smart solution to filter a dataverse list using an array without creating an Apply-To-Each?
Thanks in advance 🙂
Hey @Expiscornovus ! Fetch XML works great. Thanks for your help 🙂
Hi @KimBim,
As far as I can tell from the Dataverse Web API docs the IN operator is not listed in the filter capabilities:
Maybe the Fetchxml query field is an option. I would suggest to try and add the array of values in there:
https://learn.microsoft.com/en-us/power-automate/dataverse/list-rows#fetch-xml-query
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (
