Unanswered

I'm trying to limit the workload while Listing Rows in an Excel using ODATA filtering.

(0) Share

Report

Posted on by 925stuart

Hi,

I'm trying to limit the workload while Listing Rows in an Excel using ODATA filtering. I'm struggling with the "NOT" in the regex and hope someone could tell me what I'm doing wrong here? I have tried:

^(Field_1 eq 'Happy')
Field_1 ^eq 'Happy'
Field_1 eq ^'Happy'

Thanks for your help!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report

You can't use regex in a Filter query in Power Automate. Where you just trying to filter where Field_1 is not equal to 'Happy'? If so you can just use Field_1 ne 'Happy'

Was this reply helpful? Yes No
925stuart 76 on at

Like (0)

Report

Thank you! What are the keywords I should use to Google for the documentation?

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

The link below has some good info on what you can use to filter for SharePoint. Most of it would also apply to Excel, except you can only have a single query for Excel (can't combine filters with and/or, etc.).

https://tomriha.com/wp-content/uploads/2021/03/FilterQuery-Cheatsheet.pdf

Was this reply helpful? Yes No