Error in adf If activity

Kenaniah Santhosh 6

I want my if condition to check if the value of Run_status column is equal to 0. If it equals to zero, it it has to exit until loop and move to next job. If not, it has to run in a loop inside until activity. I'm not able to implement this logic. Even before the value turns to 0, it has moved to next job, which is wrong. Inside my if condition, I have added this -> @equals(activity('Lookup2').output.firstrow.RUN_STATUS,0). I feel like there might be a mistake in this statement. Also, the select query which I have mentioned in lookup will give the result of Run_Status column.
Please help me with this

Nasreen Akter 10,791 Reputation points

2022-08-18T17:32:37.987+00:00

Hi @Kenaniah Santhosh , would you please provide some screenshots of your pipeline, for example, activities inside the Until Loop, Until Loop --> Settings etc. Thanks!
Kenaniah Santhosh 6 Reputation points

2022-08-19T05:40:57.437+00:00

Hi @Nasreen Akter . I'm not able to take a screenshot of pipeline as its in a vdi. So let me type out the details
This is how my pipeline looks like :
Stored proc-> web activity->until loop>webactivity->until2-> Stored proc
I have a variable defined in pipeline with as UntilFlag and its default value is False. The idea is to run the loop till the untilflag is false, if its true then it exits the loop.

Activities inside until loop:
wait(5mins) -> lookup-> if activity

Settings tab in until:
Expression : @bool(variables('UntilFlag'))
Timeout: 0.01:00:00
--(No user properties used in UNTIL)

Inside If activity:
If true -> set variable = Name: UntilFlag , Value: 'True'

Nothing is defined under false case .

1 answer

Nasreen Akter 10,791 Reputation points

2022-08-19T14:25:13.647+00:00

Hi @Kenaniah Santhosh ,

Would you please try to set the UntilFlag as @bool('True') and try again. Thanks!
Please sign in to rate this answer.

1 person found this answer helpful.
ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee

2022-09-02T08:23:20.173+00:00

Hi @Kenaniah Santhosh ,

Just checking in to see if the above answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Error in adf If activity

1 answer

Your answer