For each loop in adf

Vineet S 950

I am running for each loop using look up activity so using look up activity I am getting all the files from blob storage but for each loop is running continuously.. It has 60 files but after getting from files... It is running again... Please screenshot for any solution

Smaran Thoomu 16,230 Reputation points Microsoft Vendor

2024-07-19T05:00:23.6066667+00:00

Hi @Vineet S

I understand your concern. It's possible that the ForEach loop is not being terminated correctly, causing it to run indefinitely.

To help you troubleshoot this issue, I'd like to see a screenshot of your ADF pipeline, specifically the ForEach loop and Lookup activity configurations.
Smaran Thoomu 16,230 Reputation points Microsoft Vendor

2024-07-21T12:47:53.75+00:00

@Vineet S We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Vineet S 950 Reputation points

2024-07-21T19:45:29.0533333+00:00

done
Smaran Thoomu 16,230 Reputation points Microsoft Vendor

2024-07-24T08:24:33.95+00:00
@Vineet S The issue is that you are likely using a loop that continues to run indefinitely. To fix this, you need to add a stopping condition to your loop. Here are a few approaches:

In your look up activity: Set a counter variable to track the number of files found.

Within the loop: Increment the counter each time a file is found.

Add a loop condition: Use the counter to set a condition for the loop to stop when it reaches the desired number of files.

1 answer

Amira Bedhiafi 25,416 Reputation points

2024-07-18T17:06:56.9733333+00:00

If your "ForEach" loop is running continuously, it might be due to misconfiguration or a loop within the pipeline that's causing it to rerun.

You need to configure the Lookup activity to point to your Blob Storage dataset where you esnure that the "First row only" option is disabled, as you need to retrieve all files.

In the settings of the ForEach activity, set the "Items" field to @activity('LookupActivityName').output.value. This ensures that the ForEach activity will iterate over each item in the list of files retrieved by the Lookup activity.
Please sign in to rate this answer.
Vineet S 950 Reputation points

2024-07-18T17:19:09.6433333+00:00

Tried the same thing but still for each loop is not stopping... How we can make sure it has one iteration
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

For each loop in adf

1 answer

Your answer