Getting fileName from Sharepoint Tool

[prakhar021]

Hi Folks, 

I have a input as Sharepoint Tool. In that I am selecting a excel file from a folder. I want to fetch the file name of this Excel file. Is is possible in Alteryx ? I couldn't find a generic function for this. However  In Sharepoint tool there is an option "Read only full paths" But that just Gives a file name. I need data and file name both. It would be better if for each records I could get File name as a different column

[aatalai · Accepted solution]

@prakhar021 yes this can be done, you need to select the file and then in the configure file tab of the sharepoint input tool scroll to attach meta data and select "LinkFilename"

And then you will get the file name  (with extension) in a new column. Please let me know how you get on

[prakhar021]

That worked