ForEach Activity in ADF - can you skip an inner activity if one fails? QA Failure please help

Question

HellO!
@Nasreen Akter @MartinJaffer-MSFT

I have a ForEach with a Web Activity inside looking for a social security number from the employees DB. A couple of times, the Employee doesn't exist so the Web Activity fails inside the ForEach and stops my entire process. If it fails which is rare, I want to just keep on going. Is there a way to do this? Thanks!! Mike Kiser

Please see below....

Please see the following. When my Set Variable fails due to no social security number then the entire ForEach fails ....I need it just to skip the failure and keep processing. Thanks!

Answer 1

Hello @Mike Kiser ,

I think what @Nasreen Akter suggested should work but may be you can try to see if setting up the "Completion" dependency does the trick in your case .

Please do let me know how it goes .
Thanks
Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Answer 2

Hi @Mike Kiser ,

You can have a IF Condition for checking the status just before set SSN activity e.g., something like:

@contains(toUpper(activity('WEBActivity').output.runtimeStatus), 'COMPLETE')  

If your WebActivity does not return runtimeStatus, check which field you can use from the return response e.g., StatusCode, or any other custom status and use that instead.

Thanks!