Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
P_work
Helper I
Helper I

FOREACH single activity inside sub-activity fails at times expectedly.

I have a FOREACH activity. Sub-activity inside has an activity within that can fail at times. This is fine. However, this now causes the FOREACH activity to also be marked as failed, and follow the fail path. There is no built-in method to suppress this behavior of the internal activity. or the Foreach activity.

1 ACCEPTED SOLUTION
NandanHegde
Super User
Super User

NandanHegde_0-1753848093110.png

 

as seen foreach is success even if the inner activities have failed.

 

you need to use try catch scenario :

NandanHegde_1-1753848150439.png

Blog for additional details :

https://datasharkx.wordpress.com/2021/08/19/error-logging-and-the-art-of-avoiding-redundant-activiti...




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

View solution in original post

4 REPLIES 4
v-nmadadi-msft
Community Support
Community Support

Hi @P_work 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.


Thank you

v-nmadadi-msft
Community Support
Community Support

Hi @P_work 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.


Thank you.

v-nmadadi-msft
Community Support
Community Support

Hi @P_work  ,
Thanks for reaching out to the Microsoft fabric community forum.

Thank you @NandanHegde  for your valuable points,

In Try-Catch approach,

 

When previous activity succeeds: node Upon Failure is skipped and its parent node succeeds; overall pipeline succeeds

When previous activity fails: node Upon Failure is enacted; overall pipeline succeeds
here is more information on wait activity

Wait activity - Microsoft Fabric | Microsoft Learn


 

I hope this information helps. Please do let us know if you have any further queries.
Thank you

NandanHegde
Super User
Super User

NandanHegde_0-1753848093110.png

 

as seen foreach is success even if the inner activities have failed.

 

you need to use try catch scenario :

NandanHegde_1-1753848150439.png

Blog for additional details :

https://datasharkx.wordpress.com/2021/08/19/error-logging-and-the-art-of-avoiding-redundant-activiti...




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

Helpful resources

Announcements
August Fabric Update Carousel

Fabric Monthly Update - August 2025

Check out the August 2025 Fabric update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.