Azure logic apps Odata filter query with if statment on two columns
Good morning,
I have a unique requirement where I have to apply a filter on "Get entities" from Azure table based on a condition, filters come from HTTP get request.
There are two filters - a and b.
If both filters passed to the flow are empty, no filter is applied. If either one of the filters is not empty, the filter must be applied on that column. If both filters are not empty, the filters must be applied on both columns.
Is it possible to apply an If statement in an ODATA filter query? I can't seem to find a good answer.
For this requirement, we can just use "Condition" in logic app to implement it. It's not a smart solution, but it works.
First I use two variables to simulate your two filters from http request.
Then use another variable to store the result filter(s).
Now add a "Condition" to judge if filter1 is not equal to "empty".
If true, add another condition "Condition 2" to judge if filter2 is not equal to "empty" and set the value for filterResult.
If false, also add another condition "Condition 3" to judge if filter2 is not equal to "empty" and set the value for filterResult. Note: use expression string(' ') in "Set variable 4", or it will not allow us to save the logic app.
After that, we can use filterResult in "Get entities". The expression in below screenshot is trim(variables('filterResult')).
- Check if a value is within a range of numbers
- OCaml This variant expression is expected to have type unit
- Cleaner if statement sequence in C++
- Why can if statement works using an object (like Map) with ".has()" and no working with ".includes"?
- How to combine multiple conditions in a PowerShell if-statement
- I get an error when I end the if statement with a concluding else statement
- Does PHP have short-circuit evaluation?
- Why is this code still adding 1 to i even when the if statment that does so isnt called in C?
- error compiling in c user input
- R Conditional IfElse With Random Values
- Can not get past illogical line pep8 error
- smarty help with if statement
- 'if' must have both main and 'else' branches if used as an expression
- What is the standard for choosing "when" vs "if/else" in Kotlin?
- Python script continuously repeats the first if - else statement
- Why does python use 'else' after for and while loops?
- Use of ternary operator instead of if-else in C++
- Evaluate boolean environment variable in Python
- How to use if/else statement in terraform for loop
- change number grade to letter grade
- How to debug this substring matching code?
- If condition is getting skipped even if the condition is true
- Assign value to all rows based on condition being fulfilled or not
- Looping through a list in Python
- Why does if (fork() || fork() || fork()) behave differently?
- Python if not == vs if !=
- Discord.py | If statement not working correctly
- Angular 17 - In @if syntax, how to store returned value from a function in a variable and use it in the same @if block
- Angular: ng-content doesn't render with *ngIf then else
- How to get the next Bi-weekly date based on a given start date and today's date in Google Sheets