Get the folder in Sharepoint where file is

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Joumar12 7 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

fchopo 8,003 Moderator on at

Like (2)

Report

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

Was this reply helpful? Yes No
Joumar12 7 on at

Like (0)

Report

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

Many Thanks!

Was this reply helpful? Yes No
Nicolas_P 19 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

"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?

Was this reply helpful? Yes No
Nicolas_P 19 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Nicolas_P 19 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

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!

Was this reply helpful? Yes No