data factory get metadata activity

[FZOU]

Hello Fabricators,

I'm working with datafactory and i'm using a getmetadata activity to get the list of files on my lakehouse, in azure there is the option get childitems  in get metadata activity but in fabric no ? anyone know how we can replace the get childitems in fabric ?

thank you 🙂

[NandanHegde · Accepted solution]

Get Meta data activity is supported within Fabric Data pipeline for lakehouse.

Output:

Config :

The child items is visible only when you have a path selected and not a file

[Anonymous]

Hi @FZOU

In Azure Data Factory, the activity with the option is commonly used to retrieve a list of files or folders within a directory.

However, in Microsoft Fabric, this specific option isn’t available directly.

To achieve similar functionality in Fabric, you can use a combination of activities and expressions.

You can try using the foreach activity.

You can view the link below for more details:

Get Metadata activity - Microsoft Fabric | Microsoft Learn

ForEach activity - Microsoft Fabric | Microsoft Learn

Regards, 

Nono Chen 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.