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.
4,572 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,942 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 30,246 Reputation points MVP
    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