Skip to main content

Notifications

Rename Files with appended date in SharePoint libraries

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.

 

trice602_0-1714451474761.png

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/

 

trice602_1-1714451570127.png

 

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}'],'.'))

 

trice602_2-1714451718026.png

 

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

 

 

 

trice602_3-1714451851011.png

 

 

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

 

trice602_4-1714452501918.png

 

 

 

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

 

trice602_5-1714452746114.png

 

 

 

 

Comments

*This post is locked for comments

  • rajeevan23 Profile Picture rajeevan23 9
    Posted at
    Rename Files with appended date in SharePoint libraries

    Hi @trice602, thank you for sharing this guide. Sometimes we get the following error when the flow runs while the file is open:

     

    rajeevan23_0-1720519435864.png


    Do you have a solution for this?

    Thank you!

  • lilkitkat Profile Picture lilkitkat
    Posted at
    Rename Files with appended date in SharePoint libraries

    Thanks so much for your quick reply @trice602 

     

    I have made these changes and tested but it is not working.  I don't have the dynamic contents in the body or the compose inputs - could that be why and how do I add that please?

     

    Another thing is, I renamed my 'Documents' library to 'Purchase Orders' so should I replace the URI 'Documents' with 'PurchaseOrders' or not?

     

    Thank you
    Screen Shot 2024-05-02 at 4.41.09 PM.png

     

    Screen Shot 2024-05-02 at 4.41.15 PM.png

     

  • trice602 Profile Picture trice602 11,643
    Posted at
    Rename Files with appended date in SharePoint libraries

    Hi @lilkitkat ,

     

    Glad to hear you trying this out!  Let's figure it out together!

     

    1. I only have option to add "Compose" not "Compose File Extension" like yours

     

    I renamed mine in this example, "compose" is the default name for the action.  You can rename it by typing in the box at the top of the action, shown below.

     

    trice602_0-1714622436477.png

     

    2. I don't have the option to add the dynamic contents like yours

     

    Type in the URL shown below (or copy/paste from here):

     

    _api/web/lists/GetByTitle('Documents')/items()/validateUpdateListItem 

     

    With your cursor between the two () in items() click on the blue lightning bolt that appears to the right of the field, that's how you can add the dynamic content to this URI.  Then select ID from the trigger.  It may appear as ID but they are the same.

     

    trice602_1-1714622668189.png

     

     

    3. In the body text, do I need to have the spaces before the code like you eg. before "formvalues" or is this not important?  How do I know how many spaces to do?

     

    You can copy the code below to help.

     

     

    {
     "formValues":[
     {
     "FieldName": "FileLeafRef",
     "FieldValue": "DYNAMIC_NAME-DYNAMIC_DATE.DYNAMIC_COMPOSE"
     }
     ]
    }

     

     

     

     

     

  • lilkitkat Profile Picture lilkitkat
    Posted at
    Rename Files with appended date in SharePoint libraries

    Hi Thomas @trice602 , thanks for your guide.  I am a total newbie to Power Automate!  I want to do exactly what this guide is for and add a date stamp to file names added to a specific library.

     

    I am having some issues with setting this up.

    1. I only have option to add "Compose" not "Compose File Extension" like yours

    2. I don't have the option to add the dynamic contents like yours

    3. In the body text, do I need to have the spaces before the code like you eg. before "formvalues" or is this not important?  How do I know how many spaces to do?

     

    Added screenshots.

     

    As I said, total newbie so apologies if these are silly questions !

     

    Thank you


    Screen Shot 2024-05-02 at 3.43.57 PM.pngScreen Shot 2024-05-02 at 3.44.18 PM.png