ODATA filter query with an if condition

Like (0) Share

Report

Posted on 20 Oct 2020 18:43:23 by MsKautha

Hi,

I have a unique requirement where I have to apply a filter on "Get rows" from SQL Server based on a condition.

There are two columns - column A and column B.

If both variables passed to the flow are empty, no filter is applied.
If either one of the variables is not empty, the filter must be applied on that column.
If both variables are not empty, the filter must be applied on both columns.

One option I see is to use multiple Conditions and query database based on the result but that means all subsequent actions must be replicated in all branches of conditions. That will make maintenance of flow difficult.

Is it possible to apply an If statement in an ODATA filter query?

I tried the following expression shown in the screenshot but it is not valid.

Thank you!

All responses (5)

Answers (1)

Verified answer

MsKautha 42 on 20 Oct 2020 at 20:38:21

Like (1)

Report

Re: ODATA filter query with an if condition

Hi @Paulie78 , I ended up composing the query before get rows action because that's the only way I could include a single quotes in the filter query. Here's the series of actions I used to make it work.
'Application' and 'Manager' are Column 1 and 2, respectively.