Enhancing Data Factory: Support for Nested ForEach Loops and Conditional Logic
Currently, in Data Factory, the ForEach activity does not support nesting, meaning you cannot place one ForEach loop inside another. This limitation makes it difficult to process complex, hierarchical data structures where an outer loop needs to iterate over a set of items, and an inner loop should perform additional processing for each item. Allowing nested ForEach loops would enable more flexible and scalable workflows, eliminating the need for workarounds like using multiple pipelines or flattening data before processing.
Additionally, conditional logic inside ForEach loops is another missing capability. Right now, if you need to execute certain logic only when a condition is met inside a loop, you must create separate activities outside the loop or use multiple pipelines. Enabling If activities inside ForEach loops or allowing ForEach loops inside If activities would improve efficiency by allowing more dynamic decision-making without extra pipelines or unnecessary complexity.
These enhancements would provide greater flexibility, reduce pipeline fragmentation, and simplify workflow design.
Recent ideas
Native Master Data Management Solution
Microsoft Fabric currently lacks a native Master Data Management (MDM) capability, creating a gap for organizations that need to manage and govern business-critical reference data such as customers, ...bradcoles45 seconds agoRegular VisitorNew210Views1like3CommentsCopy results as markdown from data grid
When copying results from a query on the SQL Endpoint or Data Warehouse I often have to convert from the tab delimited table to markdown for sharing the results via services like teams or github. It...Tom_Fosterbi39 minutes agoRegular VisitorNew2Views0likes0CommentsDeployment Pipelines - Remember selected stage
Every time we go into a deployment pipeline, it defaults to selecting the Development stage. I believe that it would be very rare to have a user select the Development stage. It would be helpful if d...PeterDaniels8 hours agoAdvocate IINew1View1like0CommentsDisable auto-restore previous session's tabs in new Fabric sessions
Description: Since a recent update, starting a new Fabric session — for example by opening Fabric in a new browser tab — automatically reopens all the item tabs that were left open from a previous s...MathieuVr15 hours agoFrequent VisitorNew58Views5likes1Comment