How to get my child folder name?

[JacksonTeo]

Hi All, 

I try to upload child folder to my SharePoint document library and I would like to get the child folder name and send an email together with the child folder name. Unfortunately I use "Folder Path" in flows, but it only give me the main folder name, I cannot get the child folder name.

[v-bofeng-msft · Accepted solution]

Hi @JacksonTeo :

If your file is in a subfolder, then "Folder Path" contains the name of the subfolder. for example:

If the Full Path is

picc/SubFolder1/Document.docx

Then the folder Path should be

picc/SubFolder1/

If in this case you only want to get "SubFolder1",you could try this Expression:

split(triggerOutputs()?['body/{Path}'],'/')[sub(length(split(triggerOutputs()?['body/{Path}'],'/')),2)]

The Result

Best Regards,

Bof

[JacksonTeo]

Hi @v-bofeng-msft ,

Thanks for your reply. I tried your method, unfortunately I still get the main folder name just without a "/" at the end.

I have do some test, if I upload entire subfolder(with files) in SharePoint document library, I will keep getting the Main folder name. But If I just upload a file into my sub folder, I will get the correct folder path (main folder/sub folder).

so my question is, is it unable to get sub folder name if I upload the entire sub folder from the SharePoint Document Library?

When I upload entire folder, i will only get this

Thanks for your support!

Regards,

Jackson

[v-bofeng-msft]

Hi @JacksonTeo :

Yes that is.

Best Regards,

Bof

[JacksonTeo]

Hi @v-bofeng-msft ,

Finally I figure it out. Thanks for your help. I just change the compose Expression to:

split(triggerOutputs()?['body/{FullPath}'],'/')[sub(length(split(triggerOutputs()?['body/{FullPath}'],'/')),1)]

and it works!!

Appreciate your help!

Regards,
Jackson