Currently Lookup activity for ADLS G2/Blob returns only the data. Please can we have file name(s) included in the output of the lookup activity?
i.e. if the lookup activity is looking at a root folder and returns rows from multiple files or a single file, it would be great to include the file name (+ relative path) as a column in the results
Currently we can use Get Metadata activity and For Each Loop with Lookup to achieve this. But is really cumbersome.

or upvote
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is