33. How to Break Out of ForEach Loop on Activity Failure

[@ADFuser]

thank you for good content

[@rsm904]

Hii mam thanks for providing again scenario based questions

[@narendrakishore8526]

Very informative and useful in real time scenario 🎉

[@CGlassmates]

Thanks so much😊

[@NiteeshKumarPinjala]

Learned a lot through this series, thanks for making it. I have few questions in ADF 1. How can i get notified if any of my innner activity fails in pipeline. Ex: If i'm having 10 activities in pipeline, how can i get notified if my 2nd activity fails? should we add web activity for all the 10 activities to get notified over mail? or do we have any other work around? 2. I have 10 tables that needs to be copied from on-prem, i would like to update table name and it's status(whether it successfully copied or failed) in one sql table. how can i achieve this?

[@azurecontentannu6399]

@@NiteeshKumarPinjala 1. kzbin.info/www/bejne/o4KcgaFueqhomacsi=MeilBIDWI5Z9jmKd 2. Create a column in SQL. Update the status using lookup activity or script activity or SP activity based on copy activity output.

[@azurecontentannu6399]

2. U can take reference from this video : kzbin.info/www/bejne/npfYm4Kcos53eq8si=wVagivsDczz28IoV

[@NiteeshKumarPinjala]

@@azurecontentannu6399 Thankyou So much Anu!! This is what exactly i'm looking for!! Thanks much again!!

[@lakkilakki772]

Thank you for the detailed explanation but it still iterates and goes to true block. Is there any way to break the iteration as well..

[@azurecontentannu6399]

Hey, unfortunately that's not possible as of now.. It will still iterate and complete the loop by just running if activity but inner activities will be skipped as mentioned in the video. So it's breaking out but for inner activities, which is still a cost saving solution if needed in few cases.

[@lakkilakki772]

@@azurecontentannu6399 understood thanks for the response

[@fahadmahmood7150]

Thanks for the great session. I have one doubt is there any way where we can avoid checking if condition multiple times in for loop activity as in log every time it is checking if condition and from the compute cost wise it will help..!

[@rsm904]

I have a question. Consider following scenario I have a subject container In that container there are two folder named english and Marathi. Also 4 files. I want to store that 2 table names in one array And in another array i want all files from that 2 folders. How to do that