multiple conditions in Filter Array error

(0) Share

Report

Posted on by EpicTriffid

364

Hi all,

I have the following code in a Filter Array action, filtering an array variable called conbinedList.

@Or(
equals(item()?['displayName'], 'All team - for information'),
equals(item()?['displayName'], 'Awaiting Reply'),
equals(item()?['displayName'], 'Contacted John Smith'),
equals(item()?['displayName'], 'In progress'),
equals(item()?['displayName'], 'Needs Resolving')
)

It keeps saying expressed is invalid when i try to press "Add". Any idea why?

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

EpicTriffid 364 on at

Like (0)

Report
Copy link

Link copied!

the initial "@or" is lower case in my code, by it just appears capitalised in the code above!

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @EpicTriffid ,

I've made a test but your formula worked well on myside , could you please show me your flow?

Best Regards,
Bof

Was this reply helpful? Yes No
EpicTriffid 364 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft

It's all a bit convoluted, but the below is the last few steps, where I've joined two arrays together into a new combined array called CombinedList:
my initial post was actually incorrect in that i want to filter OUT those values above from the combinedList variable created in "Initialize variable 1":

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @EpicTriffid ,

Please copy and paste your formula directly into the red box I've marked.

Best Regards,

Bof

Was this reply helpful? Yes No