Answered

Conditionals within a filter to retrieve relevant rows from excel doc

(0) Share

Report

Posted on by Bernard89

Hi all, I'm modifying one of my existing flows and was curious if we can insert an OR condition into a filter. Previously my code looked like this which has worked fine:

@equals(item()?['Col1Example'], 'X')

Now I'm hoping to add the conditional without the need to branch off and retrieve the result, similar to this (which doesn't work):

@equals(item()?['Col1Example'], 'X') OR @equals(item()?['Col1Example'], 'Y')

Any thoughts or suggestions? Thanks!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

v-jefferni on at

Like (1)

Report

Hi @Bernard89 ,

You can use a Filter array Control and filter on multiple conditions:

Best regards,

Was this reply helpful? Yes No
Verified answer

Bernard89 10 on at

Like (0)

Report

Thanks, I was mostly looking for help to understand how to approach writing the conditional. I've got it sorted out now:

@Anonymous(equals(item()?['X'], 'Y')
,equals(item()?['X', 'Z'))

Starting with the OR and removing the @ before each requirement.

Was this reply helpful? Yes No