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 🙂
