Changing a file name in sharepoint

[adrian-m]

Hello again!

Trying to create a flow where paper documents are scanned in, their contents saved to SharePoint and the files are named with a shipment number contained on the paper documents. 

The scanner sends the scan to an email address which triggers a flow that saves the attachment to sharepoint.

I have a second flow that is triggered when a document is created in the sharepoint folder. An AI model that extracts a shipment number form the scan image.

The bit I'm stuck on is I now want to rename the scan document to be the same as the shipment number. I have tried using the create file and copy file options but havnt had much luck.  
When I did the create file option - it created a file successfully with the shipment number as the name, but it was just a blank file.
When Im trying the copy file, I can figure out how to change the name.

(The teams message is just for testing so that I knew the AI bit was working)

[ScottShearer]

@adrian-m 

Essentially, you'll need to create a new file with the new name and delete the original when you're done.

Here is a link to a blog post that explains all but the delete.

The problem that you'll have is that you'll create an infinite loop - the Flow will run again when the new file is created.   You might add a condition that says of the file was created by you, then exit the Flow to work around this issue.

[ekarim2020]

Here is another method which uses the file check out and check in actions:

Renaming a SharePoint file using REST API with Power Automate

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[adrian-m]

thanks for the reply, in the get file content action - which file identifier should i use? (Im not sure this method will even work - it wants me to specify a single existing document rather than anyway to get it to dynamically do it for files in a folder)

New files may come in quickly - the users stand at tray fed scanner and just pour orders in, one email/pdf will be created per order but they might do 20 orders one after another. So PDF's might stack up in the folder - Cant have the flow relying on there only being a single document in the folder to work. 
When a document is created - we need to specifically identify that document that was just created regardless of what else is in the folder.

[ekarim2020]

Try using one of the When a file is created triggers, for example:

 

 

Ellis

[adrian-m]

seems like i need two triggers? When a File is created (properties only) - to get the file ID and "When a file is created" in order to get the file contents.

However when I try to use two triggers teh flow just stalls on the second trigger 😞 (i assume you cant have 2 in the same flow?)

[ekarim2020]

The flow should only use one trigger. Start with a simple flow, using the When a File is created (properties only) trigger, then get the file content using path for use in your AI builder action.

Ellis

[adrian-m]

file contents doesnt seem to be an option from the AI model action. 

Also, it seems the AI model action wont work with the Properties only "when a file is created" - it cant get the file contents to work on

[ekarim2020]

Can you try something like this?

 

Ellis

[JoeF-MSFT]

Nice use case for AI Builder @adrian-m!

Here is an example flow of how this can be achieved. Here I'm using the extracted value 'Sales order number value' returned by the AI Builder model as the new name of the file.

The following link explains in more details the Send an HTTP request to SharePoint action: Rename a file in SharePoint with a single Power Automate action (tomriha.com)

[adrian-m]

Thanks for the reply....I am getting an error on the http request -

{

  "status": 404,

  "message": "List 'Documents/Shared Documents/Inbound Files' does not exist at site with URL 'https://company.sharepoint.com/sites/SBTransport528'.\r\nclientRequestId: 1aedddc2-bb9b-48cd-b074-fdf1e5025953\r\nserviceRequestId: 799f29a0-608e-3000-ec2a-ba1888d3e6c6",

  "source": "https://company.sharepoint.com/sites/SBTransport528/_api/web/lists/GetByTitle('Documents/Shared%20Do...",

  "errors": [

    "-1",

    "System.ArgumentException"

  ]

}



and yet it can find that location just fine with the trigger and when creating the file at the beginning etc

[adrian-m]

I've tried every possible combination of file path I can think of 😞

[adrian-m]

NEVER MIND!  lol

I went back to trying to use the "create file" action which created documents that I thought were just blank - but then i Downloaded one and noticed its file size was significant. Realised the file was being created just fine only without the file extension which I have now fixed 😄


One last question - the shipping numbers are all in the format 4000789654  is there an easy way to truncate the leading 4000 ?

[JoeF-MSFT]

Hi @adrian-m - congrats on successfully building this automation! 🙂

Apologies for taking some time to response to your last question. The following expression should take care of truncating the first four digits:

substring(Put here the shipping number output, 4, sub(length(Put here the shipping number output), 4))

[adrian-m]

like this?

[JoeF-MSFT · Accepted solution]

Hi @adrian-m - more like this, using the Expression menu. 

[adrian-m]

thats worked perfectly thanks!!!

[ekarim2020]

Power Automate now has a new function called slice. See: Reference guide for expression functions - Azure Logic Apps | Microsoft Docs

Example:

slice('4000789654',4) returns 789654

Hope this helps.

Ellis

[reidb]

I am getting an error in "Send HTTP Request" step where the file cannot be found.

My files are actually in a subfolder of "Documents" called TermList

Both Trigger and GET file Metadata work fine to ID the actual file.

All i need to accomplish is to rename the file from xyz.csv to xyz.xlsx - change filetype.

I have tried several iterations of the folder structure in the uri 

GetByTitle('Documents/TermList')/items

... ('Shared Documents/TermList')/items

neither work..

error: (with a different file path, but get same error no matter what path i put in)

[JoeF-MSFT]

Hi @reidb - what you should put in the URI is the name of the document library. By default in many cases is Documents. Here is where you see it in SharePoint:

Have you tried with: _api/web/lists/GetByTitle('Documents')/items(<PUT YOUR FILE ID HERE>)/validateUpdateListItem 

Happy new year! 🎇