Share via

Cant get hold of the array from a ForeEach activity

Klaus Nørregaard 1 Reputation point
2021-07-09T13:24:45.54+00:00

I get this error:

The expression 'length(activity('Copy Excel to Cache Sink').output.value)' cannot be evaluated because property 'value' doesn't exist, available properties are 'runStatus, effectiveIntegrationRuntime, billingReference, reportLineageToCatalog'.

I have a DataFlow. It output to activity

113411-b1.png
In my ForEach Activity in my Pipeline I try to do the following : @activity('Copy Excel to Cache Sink').output.value

BUT the error returns like this
113412-b2.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,645 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,921 Reputation points Volunteer Moderator
    2021-07-09T14:53:45.153+00:00

    If you are just trying to get excel data and feed it to ForEach activity, simply use Lookup activity in pipeline (instead of using Data flow)

    Make sure you turn off "First row only" box

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    1 person found this answer 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.