Lakehouse File name

[wanwar]

Using an activator to trigger a pipeline based on a new file created in the Lakehouse, the pipeline accepts a paramter for filename, in the pipeline i have added the folder in the File path and for the file name i want to use the parameter value thats coming from the activator but I can't seem the find a Tag to get just the file name to pass, i have tried __source and @__subject both are giving me full folder path so the pipeline fails with "Not found"

any ideas.

Thanks

[v-anbandari · Accepted solution]

Hi @wanwar ,
Thank you for reaching out to the Microsoft Fabric Community.

You can just take the file name from the trigger value by using this expression:

@last(split(triggerBody()?['__source'], '/'))

Here, triggerBody()?['__source'] gives the full path, then split breaks it using “/”, and last picks the final part which is the file name (like data.csv). Use this while passing the parameter to your pipeline so it only gets the file name.

Please refer to this for more details:
https://learn.microsoft.com/en-us/fabric/real-time-intelligence/data-activator/activator-trigger-mod...

If you need any additional assistance, feel free to reach out to us.
Thank You.