Power Platform Community Forum Thread Details

Hi team,

I have scenario in SharePoint Document library to copy excel file with file name ("TestAttachment 2.03.2025.xlsx") to same folder location and append every week Monday's date to the file name ("TestAttachment 2.10.2025.xlsx") when we manually trigger the flow to perform other sequence operations..

Can someone help me how to copy file to same location and capture file name with everyweek Monday's date and append to file name will be great help to apply in multiple flows.

Example file Name when we trigger the flow :

copy file "TestAttachment 1.27.2025.xlsx" to "TestAttachment 2.03.2025.xlsx"

copy file "TestAttachment 2.03.2025.xlsx" to "TestAttachment 2.10.2025.xlsx"

copy file "TestAttachment 2.10.2025.xlsx" to "TestAttachment 2.17.2025.xlsx"

Categories:

Building flows

You can achieve this in Power Automate by following these steps:

Solution Overview

Get the existing file from SharePoint.
Determine the next Monday's date based on the filename.
Copy the file with the new filename.
Save it in the same folder with the updated name.

Step-by-Step Implementation in Power Automate

1. Trigger

Use a Manually Triggered Flow or any other trigger as per your needs.

2. Get the File Details

Use "Get file properties" (SharePoint) action to retrieve the file's metadata.
Use "Get file content" (SharePoint) to retrieve the actual file.

3. Extract Date from File Name

Use the "Compose" action with the following expression to extract the date from the filename:

last(split(triggerOutputs()?['body/{Name}'], ' '))
- This extracts the date portion "2.03.2025.xlsx" from "TestAttachment 2.03.2025.xlsx".

4. Convert the Date and Calculate Next Monday

Add a "Compose" action with this expression:

formatDateTime(addDays('2025-02-03', 7), 'M.dd.yyyy')
- This adds 7 days to the extracted date to get the next Monday.

5. Generate New File Name

Use a "Compose" action to construct the new file name:

concat('TestAttachment ', formatDateTime(addDays('2025-02-03', 7), 'M.dd.yyyy'), '.xlsx')
- Example Output: "TestAttachment 2.10.2025.xlsx"

6. Copy and Rename the File

Use "Create file" (SharePoint) action to copy the file to the same folder with the new name.
- Folder Path: Select the same folder where the original file is located.
- File Name: Use the output from the previous step.
- File Content: Use the output from "Get file content".