web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Concat 2 or more expre...

Power Automate

Answered

Concat 2 or more expressions

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi folks,

I use the following expression as a filter for a RSS feed:

@And(contains(string(item()?['title']), '[H/H]'),contains(string(item()?['title']), 'Microsoft'))

Now I want to add a second and maybe a third expression which needs to act as parallel filter options. So the second expression looks like this:

@And(contains(string(item()?['title']), '[H/H]'),contains(string(item()?['title']), 'VMware'))

How can I 'connect' these two expressions so the filter gives the result for the first expression or the second expression or....

Kind regards

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

tom_riha 10,187 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Hello @Anonymous ,

remove the @ from the expressions, put them into @or:

@Or(And(contains(string(item()?['title']), '[H/H]'),contains(string(item()?['title']), 'Microsoft')),And(contains(string(item()?['title']), '[H/H]'),contains(string(item()?['title']), 'VMware'))) *I hope I've got the brackets right

Each OR / AND can compare only 2 values/expressions, if you need more of them you must group them: e.g. evaluate the first two, then the result of the first two with the third, then the result of 1+2+3 with 4...

@or(expression1,expression2) @or(or(expression1,expression2),expression3) @or(or(or(expression1,expression2),expression3),expression4)

Was this reply helpful? Yes No
askondo Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@tom_riha Thank you for all your contributions to the forum. I appreciate it very much.

Was this reply helpful? Yes No

Join the conversation