question

AbinashTumulu-5836 avatar image
0 Votes"
AbinashTumulu-5836 asked AbinashTumulu-5836 commented

ForEach inside IF is not allowed in Synapse

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-data-factoryazure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered AbinashTumulu-5836 commented

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

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Though I've accepted the answer, would like to know if there is any plans to have this restriction removed?
This is one of the basic requirements and using "Execute Pipeline" is just a workaround but not the best solution.

0 Votes 0 ·

Hey,
I do agree that this is a limitation.

@PRADEEPCHEEKATLA-MSFT @KranthiPakala-MSFT : Do we have any idea w.r.t limitation being removed?

0 Votes 0 ·

Hi @AbinashTumulu-5836, @NandanHegde-7720 ,

AFAIK there is no plan for PG to remove this limitation at the moment.

If you have any specific feedback regarding this, I would recommend you to please submit an idea as per the instruction provided in this article: How to send ideas and suggestions to the Synapse team. Once the suggestion/idea is posted one of our engineer will take this feedback forward to ADF product team.


0 Votes 0 ·
Show more comments