Update filename based on Folder name

[Anonymous]

I'd like to automate the renaming of a file based upon the folder where a user stores the file.  The lowest folder in the tree is where the docs are filed and is structured as follows:  "01.01.01_FolderName"; "01.01.02_FolderName" and so on.  The ideal would be to prepend the file name with the folder name, for example: "01.01.01_FolderName_FileName".  Thanks for any help here.  

[okeks]

You can use the "When a file gets created" trigger and in there you have a property called path.

As there is no simple renaming function in the Sharepoint connector, you need to use the Move file action and use the concat function to create the new file name.

To prevent unwanted nested loop effects, you need to build a condition that the filename doesn't start with the foldername.

[v-bofeng-msft · Accepted solution]

Hi  @Anonymous ,

I've made a test for your reference:

1\My Library

2\My flow

Compose

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

Headers

{ "Content-type": "application/json; odata=verbose", "If-Match": "*", "X-HTTP-Method": "MERGE", "Accept": "application/json;odata=verbose" }

Body

{ "__metadata":
  { "type":"@{outputs('Send_an_HTTP_request_to_SharePoint_to_get_type')?['body']?['d']?['ListItemEntityTypeFullName']}"},
   "FileLeafRef":"@{outputs('Compose')}"
}

I think this link will help you a lot:

https://www.enjoysharepoint.com/power-automate-rename-file/

Best Regards,

Bof

[Anonymous]

Thanks for your response @v-bofeng-msft .  I tried to set up the flow but it fails on step 3, here's the error code: "List '06_New Filing TEST site' does not exist at site with URL 'https://abcd.sharepoint.com/sites/abcd'.
clientRequestId: 7a321d5d-3734-4588-8eca-42107bee48ae
serviceRequestId: 7d2e53a0-0036-1000-747f-b0bdd8f392e3"  I have checked the folder name and its correct - what am I doing wrong?  Thanks

[v-bofeng-msft]

Hi @Anonymous ,

Could you please show me your flow?

Best Regards,

Bof