Power Community

Power Community

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

This post was originally published on this site

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

Create Brand Profiles in Customer Insights – Journeys to Create Cohesive Brand Experiences

In this blog, we will learn about one of the new features introduced by Microsoft in Dynamics 365 in...

More Articles Like This

- Advertisement -spot_img