Answered

Contains in power automate

(0) Share

Report

Posted on by Vaibhav_k

Dear community,

I have a filter expression in get items action. I have now added a new field in the form and also in the list that is querying the same columns mentioned below. I now have to check NewField in the filter. The field is multiple selection choice field. How can this be achieved? Do I need to select contains so that it will filter with additional field.

(Channel/Title eq '@{triggerOutputs()?['body/Channel']}') and ((ClaimType/Title eq '@{triggerOutputs()?['body/ClaimType']}') or (SubClaimType eq '@{triggerOutputs()?['body/SubClaimType']}')) and (RequestType eq '@{triggerOutputs()?['body/RequestType']}')

Categories:

Building flows

All responses (2)

Answers (1)

Sort by

Verified answer

tom_riha 10,187 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hello @Vaibhav_k ,

the OData Filter Query doesn't support contains operator. The only way to do it is keep the filter as it is in the 'Get items' and add another action 'Filter array' where you add this 'contains' operator to further filter the item returned by the incomplete filter from 'Get items'.
Vaibhav_k on at

Like
a
(0)

Report
Copy link

Link copied!

@tom_riha, I have used additional eq operator that picks up matching item and also changed the selection from multiselect to single select. However, there could be scenarios for old items where this new field is not defined. In this case it should pick up the items by old logic without this additional filter.