ForEach inside IF is not allowed in Synapse

Abinash Tumulu 56 Reputation points Microsoft Employee
2021-08-31T17:18:37.407+00:00

When I try to add ForEach activity inside the IF condition - it throws validation error "cannot have ForEach inside IF"

Is there a workaround/fix for this?

This is common issue across ADF & Synapse so I'm tagging both.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,360 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,602 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 35,911 Reputation points MVP Volunteer Moderator
    2021-08-31T17:23:27.353+00:00

    Hey,
    Currently no iteration activities except Filter is supported within IF activity across ADF and synapse.
    In case if you need that, then please follow the below process:

    1) create a pipeline with the ForEach logic
    2) use Execute Pipeline activity within the IF activity and call the pipeline that contains ForEach

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.