ADF - Foreach activity within an If activity

Question

ADF - Foreach activity within an If activity

Kothai Ramanathan 946 Microsoft Employee

I am not able to have a foreach activity within an IF activity. Would be good to understand the reason for this.

Thanks,
Kothai.

HarithaMaddi-MSFT 10,146 Reputation points

2020-08-20T05:17:50.347+00:00

Hi @Kothai Ramanathan ,

Welcome to Microsoft Q&A Platform.

I have discussed with the product team and it is specified as current design as internally IF activity uses LogicApps and they cannot have multiple nested layers. As @Vaibhav Chaudhari mentioned, the workaround would be to use "Execute Pipeline" Activity. Please share your requirement so that we can suggest on design approach for the same.

Hope this helps!
HarithaMaddi-MSFT 10,146 Reputation points

2020-08-21T15:45:37.897+00:00

Hi @Kothai Ramanathan ,

We have not heard back from you. If the below answer helped you, would you please share it with the community. Otherwise, let us know and we will continue to engage with you on the issue.
HarithaMaddi-MSFT 10,146 Reputation points

2020-08-24T05:16:12.14+00:00

Hi @Kothai Ramanathan ,

Following up to check if the below answer helped you, would you please share it with the community. Otherwise, let us know and we will continue to engage with you on the issue.
Geoffrey Freeman 1 Reputation point

2021-01-15T02:00:01.1+00:00

Not OP, but running into the same limitation. It seems like a pretty basic requirement - I would like the ability to nest a foreach activity inside an if activity, and to have nested if activities. I understand that I can have nested pipelines instead, but that seems like an unnecessary division of logic.
Anthony Smart 30 Reputation points

2023-02-12T18:36:46.6066667+00:00

It's definitely basic functionality. I've got a pipeline that gets a list of files back from Blob storage. If the file count == x then I want to iterate the files and process them via a for loop. Otherwise I will abort and wait for all of the files to arrive.

2 answers

Your answer

HarithaMaddi-MSFT 10,146 Reputation points

2020-08-20T05:17:50.347+00:00

Hi @Kothai Ramanathan ,

Welcome to Microsoft Q&A Platform.

I have discussed with the product team and it is specified as current design as internally IF activity uses LogicApps and they cannot have multiple nested layers. As @Vaibhav Chaudhari mentioned, the workaround would be to use "Execute Pipeline" Activity. Please share your requirement so that we can suggest on design approach for the same.

Hope this helps!
HarithaMaddi-MSFT 10,146 Reputation points

2020-08-21T15:45:37.897+00:00

Hi @Kothai Ramanathan ,

We have not heard back from you. If the below answer helped you, would you please share it with the community. Otherwise, let us know and we will continue to engage with you on the issue.
HarithaMaddi-MSFT 10,146 Reputation points

2020-08-24T05:16:12.14+00:00

Hi @Kothai Ramanathan ,

Following up to check if the below answer helped you, would you please share it with the community. Otherwise, let us know and we will continue to engage with you on the issue.
Geoffrey Freeman 1 Reputation point

2021-01-15T02:00:01.1+00:00

Not OP, but running into the same limitation. It seems like a pretty basic requirement - I would like the ability to nest a foreach activity inside an if activity, and to have nested if activities. I understand that I can have nested pipelines instead, but that seems like an unnecessary division of logic.
Anthony Smart 30 Reputation points

2023-02-12T18:36:46.6066667+00:00

It's definitely basic functionality. I've got a pipeline that gets a list of files back from Blob storage. If the file count == x then I want to iterate the files and process them via a for loop. Otherwise I will abort and wait for all of the files to arrive.

Answer 1

Vaibhav Chaudhari 38,916 Volunteer Moderator

Maybe it's as per the design or they had difficulties in implementing it.. Not sure!

For now, we can raise or upvote existing similar feedback raised here - 40911322-support-foreach-activity-under-if-condition-and-sw

ADF Product team monitor these feedback and work on it based on no of votes, priority..

On similar note, ADF also has few more limitations like IF not allowed inside IF, Foreach not allowed inside ForEach. In such cases, most of the user implement workaround mostly using parent-child pipeline concept.

=========================================================
Please don't forget to "Accept Answer" and upvote if the response helped -- Vaibhav

Alan Niedelman 0 Reputation points

2024-02-22T16:30:37.8333333+00:00

The upvote link gives an error

Answer 2

Alan Hebo Jensen 16

Since we pay per pipeline executed that is a pretty greedy suggestion.

I have several issues where i need to run "until" or "forEach" but only if certain criteria is met. I wish we could go back SSIS. There are too many key features missing from ADF at this point

Share via

ADF - Foreach activity within an If activity

2 answers

Your answer