Setting folder path from file in document library as a variable

[Anonymous]

Hi everyone,

I'm working with a SharePoint document library that has three levels of folders and subfolders. I need to have a flow, triggered on file creation or file modification in the library, that captures each file URL, splits each folder level in the URL out into variables, and applies each variable to 4 string columns. Example screeshot below:

I'm hoping that I've provided enough information here, and that there is an easy solution to this? Any help would be really appreciated 🙂

[v-bacao-msft · Accepted solution]

Hi @Anonymous ,

You could use split() function to get the folder name.

split(triggerBody()?['{Path}'],'/')

outputs('FolderPath')[0]

outputs('FolderPath')[1]

outputs('FolderPath')[2]

Image reference:

Best Regards,

[Anonymous]

Perfect @v-bacao-msft , that's exactly what I need. Thank you 🙂