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']}')

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

tom_riha 10,179 Most Valuable Professional on at

Like (1)

Report

Re: Contains in power automate

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'.

Was this reply helpful? Yes No
Vaibhav_k on at

Like (0)

Report

Re: Contains in power automate

@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.

Was this reply helpful? Yes No