Answered

Add Contains on Filter Query

(0) Share

Report

Posted on by dhana88

Hey there,

I'm having some trouble with my filter query. I tried adding "Contain eq 'Support'" to it, but it didn't work. Then I attempted to list the Owner role on the Power query, but that didn't work either. I used the "or" operator, but it didn't filter anything closely related; instead, everything showed up. I'm not sure how to fix this. Could someone please help me by either adding the "contain" condition or showing me how to list them? I tried using brackets for the case owner list and the substring of, but none of them seem to work.

The owner list is longer, but only a few add

Status ne 'Closed' and
Status ne 'Delete' and
Status ne 'Archive' and
Status ne 'ETC Delete' and
Owner_Role__c eq 'III Support Engineer' and
Owner_Role__c eq 'Tier III Support Engineer' and
Owner_Role__c eq 'Tier II Support Engineer'

Thank you

Categories:

General topics

All responses (2)

Answers (1)

Sort by

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @dhana88 ,

Status ne 'Closed' and Status ne 'Delete' and Status ne 'Archive' and Status ne 'ETC Delete' and Owner_Role__c eq 'EMEA Tier III Support Engineer' and Owner_Role__c eq 'Americas Tier III Support Engineer' and Owner_Role__c eq 'Americas Tier II Support Engineer'

There is a problem with the logic of your expression, Owner_Role__c it is impossible to equal three values at the same time unless it is a multi-choice column, if you only want to meet one of the conditions in the Owner_Role__c, please try this:

Status ne 'Closed' and Status ne 'Delete' and Status ne 'Archive' and Status ne 'ETC Delete' and (Owner_Role__c eq 'EMEA Tier III Support Engineer' or Owner_Role__c eq 'Americas Tier III Support Engineer' or Owner_Role__c eq 'Americas Tier II Support Engineer')

Best Regards,

Sunshine Gu
dhana88 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much fo the help