cancel
Showing results for 
Search instead for 
Did you mean: 
trice602

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

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

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"
       }
     ]
}

 

 

 

 

 

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

 

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!

About the Author
  • Experienced Consultant with a demonstrated history of working in the information technology and services industry. Skilled in Office 365, Azure, SharePoint Online, PowerShell, Nintex, K2, SharePoint Designer workflow automation, PowerApps, Microsoft Flow, PowerShell, Active Directory, Operating Systems, Networking, and JavaScript. Strong consulting professional with a Bachelor of Engineering (B.E.) focused in Information Technology from Mumbai University.
  • I am a Microsoft Business Applications MVP and a Senior Manager at EY. I am a technology enthusiast and problem solver. I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Apps, Power Automate, SharePoint, and Teams Etc. I am helping global clients on Power Platform adoption and empowering them with Power Platform possibilities, capabilities, and easiness. I am a leader of the Houston Power Platform User Group and Power Automate community superuser. I love traveling , exploring new places, and meeting people from different cultures.
  • Read more about me and my achievements at: https://ganeshsanapblogs.wordpress.com/about MCT | SharePoint, Microsoft 365 and Power Platform Consultant | Contributor on SharePoint StackExchange, MSFT Techcommunity
  • Encodian Owner / Founder - Ex Microsoft Consulting Services - Architect / Developer - 20 years in SharePoint - PowerPlatform Fan
  • Founder of SKILLFUL SARDINE, a company focused on productivity and the Power Platform. You can find me on LinkedIn: https://linkedin.com/in/manueltgomes and twitter http://twitter.com/manueltgomes. I also write at https://www.manueltgomes.com, so if you want some Power Automate, SharePoint or Power Apps content I'm your guy 🙂
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 15 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • Big fan of Power Platform technologies and implemented many solutions.
  • Passionate #Programmer #SharePoint #SPFx #M365 #Power Platform| Microsoft MVP | SharePoint StackOverflow, Github, PnP contributor
  • Web site – https://kamdaryash.wordpress.com Youtube channel - https://www.youtube.com/channel/UCM149rFkLNgerSvgDVeYTZQ/