Unanswered

How to set a condition

(0) Share

Report

Posted on by Rassyboy

I have a flow that uses HTTP connector to pull data from a table in Business By design and from that table i have a column that has data values in rows .. I am trying to set 3 conditions for that column that says :

1. i want to pull out numbers that fall within the range of 1-30 inside that column

2. i want numbers in that column that fall within the range of 31-60

3. and finally 61-90. My usage of expressions is not so great . Can anyone help please with an expression i can use for my condition ???

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @Rassyboy
There could other better techniques. But this one is mine. If you like it you can use it.
In the compose I have taken a particular number.
Then I have used one condition, that the output of above compose is less than 31. [Or you can also do less than or equal to 30]
Inside If Yes:
Inside If No, I have give another condition, that output of compose is less than 61.
In your case you will have to take an apply to each loop. And pass the value of output you are getting from http.
After that you can make 3 array variables. And when they match you can append in those arrays.

I hope you like this.

Was this reply helpful? Yes No
Rassyboy 4 on at

Like (0)

Report

My out put can not be 61 instead if i have a column A with rows of data = 5,8,89,31,63,45,25,19,71,67,29 then from the column A i want data that falls within the range of 1-30 , 31-60, and 61-90 ..

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

@Rassyboy
Just put your column in that first compose and pass it to the condition, this will automatically create an apply to each loop. I gave you an example how to do it. You just had to put your column in the 1st compose.

Was this reply helpful? Yes No