how works "Filter Query" in a "list rows" on a dataverse table?

(0) Share

Report

Posted on by DiePic

463

Hi all,

I've a flow that works with my "Filter Query" = "InvioMail eq 'SI'".
Now I need to add a new filter here so my filter became "Filter Query" = "InvioMail eq 'SI' and checkMailDimissioni ne 'Inviata'".
Separately the 2 filters ("InvioMail eq 'SI'" and "checkMailDimissioni ne 'Inviata'") are working, but togheter MPA returns an error
"Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported."
There is a way to have both filters in "Filter Query"?
thanks for any suggestion

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (1)

Report

check this guide on how to combine your filter Power Automate OData Filter Query with Examples

Was this reply helpful? Yes No
Verified answer

MS.Ragavendar 5,017 Super User 2025 Season 2 on at

Like (1)

Report

@DiePic,

When you get huge list of items, will find difficult in filtering the records, In order to sort that pain point filter query parameter helps.

How Filter Rows works

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query/filter-rows

This is reason for you equal and not equal is not working with string.

Dataverse

https://sharepains.com/2019/06/10/filter-queries-in-the-list-records-action-in-the-microsoft-dataverse-connector

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item

Was this reply helpful? Yes No