Get the folder in Sharepoint where file is

[Joumar12]

Hello

I am very new to these flows and wanted to ask how you set up flows to get the folder name where files are located

E.g. file would be 

SharepointLibrary/FolderA/ExcelFile.xls

variable would get value FolderA

br Jouni

[Anonymous]

Hello @Joumar12 

What would be the trigger for the flow to run? i.e. would you want a weekly email listing all files in your document library along with what folders each document is in?

Thanks

Bradley

[Joumar12]

Hello

In the end I am looking a way to add the folder name as metadata to the file each time a new file is added to the library. However first I need to run manually triggered flow for those files already in the library to add the Folder name as metadata to the existing files

Any help appreciated... thanks!

Br Jouni  

[fchopo · Accepted solution]

Hello @Joumar12 

You could use an expression like this:

Replace(Replace(your_element?['folder'],'SharepointLibrary/',''),'/','')

Wheree your_element will depend on the action you are using. 

Hope it helps!

Ferran

[Joumar12]

Wow! it was that simple... and I tried all kind of changing to array etc....

Many Thanks!

[Nicolas_P]

Hello @fchopo !

"Where your_element will depend on the action you are using." - that means i need to using the

Replace(Replace(triggerBody?['folder'],'SharepointLibrary/',''),'/','') to return the folder name or something else? 

Regards, N.

[fchopo]

"Where your_element will depend on the action you are using" means it depends on your trigger or action where the value to be replaced is.

Which trigger or action are you using before calling this expression?

[Nicolas_P]

I'm using the https://prnt.sc/r52epo method, it add the filename in letter draft.  So, next line i would like to add the folder name, where is this file contain. 

[fchopo]

I'm not sure I understand what you need... Do you need a string with the folder and the filename? If that's the case, you could do something like this:

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

Hope it helps!

Ferran

[Nicolas_P]

Dear Ferran! 

It's absolutely help, and the full path was return to email body, but...) 

I need only the highest folder, where file contains, not all the path, for example: 

Shared Documents/Main/10#Guide//Services_test.pdf

in my case i need only to return 10#Guide (folder name), and preferable without first two digits and symbol#, it using to sort files.

Is it's possible?
Regards, Nicolas.

[fchopo]

Why don't try something like this:

- Find where is the '#' character: indexOf(triggerBody()?['{FileNameWithExtension}'],'#')

- Find where is the last index of '/': lastIndexOf(triggerBody()?['{FileNameWithExtension}'],'/')

- Find how many characters are between them (sub function): sub(lastIndexOf(triggerBody()?['{FileNameWithExtension}'],'/'),indexOf(triggerBody()?['{FileNameWithExtension}'],'#'))

- Length of the folder (without #): 

sub(sub(lastIndexOf(triggerBody()?['{FileNameWithExtension}'],'/'),indexOf(triggerBody()?['{FileNameWithExtension}'],'#')),1)

- Get Folder Name:

substring(triggerBody()?['{FileNameWithExtension}'],add(indexOf(triggerBody()?['{FileNameWithExtension}'],'#'),1),sub(sub(lastIndexOf(triggerBody()?['{FileNameWithExtension}'],'/'),indexOf(triggerBody()?['{FileNameWithExtension}'],'#')),1))

Hope it helps!

[Nicolas_P]

((( 

Next error:

InvalidTemplate. Unable to process template language expressions in action 'Send_an_email' inputs at line '1' and column '2855': 'The template language function 'substring' parameters are out of range: 'start index' and 'length' must be non-negative integers and their sum must be no larger than the length of the string. Please see https://aka.ms/logicexpressions#substring for usage details.'.

This can be a problem with other language, different from english?

[fchopo]

Can you share a screenshot of your image so I can show you the exact expressions?

[Nicolas_P]

Hello! 

The full path on screenshot: 

So, in worflow i need only send information after #. 

Thx! 

[shravanvijay]

hi I have a similar question. To explain my flow, I manually want to trigger it, I get all the files properties inside the sharepoint. I filter it for only .xlsx files and where a custom metadata field 'Category' is empty.

I want to take the last part of the path and paste it in the Category field. Could you help me please? I'm stumped as of now