Rename Files with appended date in SharePoint libraries

[trice602]

Often times there are requests to append file names with a timestamp, customerID, or another identifier when files are created in SharePoint Libraries. This short flow will show you how to do it, step by step.

In this example, I have a trigger, When a file is created (properties only), that fires when a new file is created in a specific folder /Shared Documents/123_ABC/

Next I have a quick compose action that is getting the value after the last "." for the file extension.  I understand there are other ways to do this, here is one way.

The expression is:  

last(split(triggerOutputs()?['body/{FilenameWithExtension}'],'.'))

The final action is to use the Send an HTTP request to SharePoint action and rename the file.

The method is POST.

Enter the URI as shown below, with the dynamic content from the trigger body/ID.

Lastly, enter the body as shown below.  There are three dynamic contents:

1) body/name

2) formatDateTime(utcNow(), 'yyyy-MM-dd')

3) output from compose that contains the file extension

In this example an Excel spreadsheet "testa.xlsx" was created and it was renamed to testa-04-30-2024.xlsx

And that is it!  It's pretty quick and easy and works as an automated flow.  I've answered a handful of related/ancillary questions over the last 9 months, and I hope you enjoyed this quick walkthrough!

I look forward to catching up with you on the next community post.  Always glad to help! Tom