power automate get item filter query

(0) Share

Report

Posted on by dmclaughlin

349

I have a once a week power automate that simply needs to check 3 fields before sending an email.

Status eq 'Approved' and Reval_x0020_Process_x0020_done ne 'Yes' and Revalidation_x0020_Required eq 'Y'

This is my filter query and it appears to be only seeing the first part of it and sending the email for all that are status eq 'approved'.

What is wrong with my syntax?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Are you dealing with a SharePoint list as a datasource in your case?

You'll see more examples on the Power Automate side of the community, but if you are dealing with a Yes/No boolean column from SharePoint, the filter query does not use the string 'Yes'. Instead, try something like: Reval_x0020_Process_x0020_done ne 1

If you are accessing single line of text columns, then you would use the string syntax.

Hope that helps,

Bryan
dmclaughlin 349 on at

Like
a
(0)

Report
Copy link

Link copied!

So Status is text, Reval process done is text. Revalidation required is a choice.
So I tried this.. wont work. Ideas?

Status eq 'Approved' and Reval_x0020_Process_x0020_done ne 'Yes' and Revalidation_x0020_Required eq 1
Verified answer

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

To clarify is Revalidation_x0020_Required a Yes/No or a Choice column?

If it is a Yes/No column, use Revalidation_x0020_Required eq 1

If it is a Choice column, use Revalidation_x0020_Required eq 'insert choice value'

When troubleshooting multiple conditions, I find it handy to test one at a time to make sure that piece is working before I put them all together with logical operators.

Bryan
dmclaughlin 349 on at

Like
a
(0)

Report
Copy link

Link copied!

so yes I've tried just having 1 filter.. Status eq 'Approved' and that works perfect. If I add 1 more statement no matter which I choose it fails. Both Status and Reval Process done are TEXT. As soon as I add just that one more check it gets no records. Status eq 'Approved' and Reval_x0020_Process_x0020_done ne 'Yes'.
And in sharepoint list I can see out of 400 approved 300 have reval = Yes so I should be getting just 100. I get nothing.
I"ve wasted hours today trying variations