@Jay466 There are two ways you could approach your flow.
1) Append the Current Date to the End of your File Name
I'm assuming you only run this flow once a week based on the name of the file.
2) Get the last file created and take the number that has been appended to the end of the file and increase that number by one.
I'm using the Classic Designer for my demo below—you'll need to switch to the Classic Designer to follow along. Both of these options will start the same. Remember to rename your actions to keep your flow organized.
Get File to Copy
You'll need a Get file content or Get file content using path action in your flow to get the file content of the file you want to copy. I'm assuming you have a template file you want to copy. However, if you want to use the content from the previously created file—a few adjustments will need to be made to this flow.
Select your Site Address and your file.
Option 1: Append Current Date to the End of File Name
This would be the easiest to implement as you just need to create a new file with the file content from your template file and append the current date to the end of the file name.
Get Today's Date
Whenever you are using dates and times in your flow—it's best practice to use a Convert Time Zone action. In the base time field, insert the utcNow() expression.
Source Time Zone: Coordinated Universal Time
Destination Time Zone: Local Time Zone
Format String: Round Trip
Add a Compose action (this is optional). However, I like to use Compose actions to test out the filename syntax to ensure it's exactly how I want it before I add any additional actions to my flow.
Add your static text to the Compose action and a space (or underscore—customize this to suit your needs). Add an expression and insert the formatDateTime() function.
Click on the dynamic content tab and insert the Converted Time dynamic content.
Add a comma and single quotes and a date/time format pattern. Customize the date/time format pattern to suit your needs.
Don't forget to add the file extension to the end of your file name. 
Run a test. Review the output of the Compose action and ensure it's what you are expecting. If not, go back and edit the Compose action until the Compose action outputs the file name you expect.
Create the File
Add a Create File action to your flow. Select your site address and folder path. In the File Name field, insert the output from the Compose action above. In the File Content field, insert the File Content dynamic content.
Run a test.
Option 2: Get Last File Name and Increment by 1
Get Last File Created Details
Add a Get Files (properties only) action to your flow. Fun fact, this action returns files and folders. To limit this action to files only, you'll need to use a filter query:
FSObjType eq 0
You can use a 1 to return folders only.
To get the last created file, you'll need to define an orderBy query:
Created desc
This will order the files returned by Created date in descending order.
Also, since you only need the last file created you can limit the number of files returned by specifying a Top Count. Enter 1 into this field.
The Get files (properties only) action will always return an array of items even if it's a single item. To get the details of the item, you'll need to use an expression. Add a Compose action and insert an expression. Use the first() function.
Click on the Dynamic Content tab and insert the value dynamic content from the Get files (properties only) action.
Run a test. Review the output of the Compose action. This action should display the details of the last file created.
Scroll down until you see the file name without an extension. The red text between the double quotes is the dynamic content key which is what we'll need.
Click on the dynamic content label of the Compose action to edit the expression. Add the following to the end of the expression:
?['{Name}']
This expression will now return the file name (without extension) only.
Get the Number
Add another Compose action to your flow and insert an expression. Use the split() function.
Insert the Output from the Compose action storing the file name.
Add a comma and single quotes. Between the single quotes, enter your separator that appears before the number you want to increment. In my case it's an underscore—so I'll enter an underscore.
Run a test. The split() function will split the file name by the separator. The output is an array. Since the number is the last item in the array we need to edit the expression to return the number only.
At the beginning of the expression insert the word last with an opening parenthesis.
Go to the end of the expression by pressing the down arrow key and enter a closing parenthesis. Don't forget to press Update.
Run a test. Review the output of the Compose action. It should only return the number.
Increment the Number
Now that you have the number you want to increment, you'll need to increment the number by 1. First you'll need to convert the string of text to an integer. Wrap the entire expression in the int() function. At the start of the expression enter the word int with an opening parenthesis.
Go to the end of the expression by pressing the down arrow key and enter a closing parenthesis.
To increment the number by 1, you'll need to use the add() function. Go back to the start of the expression by pressing the up arrow key and enter the word add with an opening parenthesis.
Go to the end of the expression by pressing the down arrow key and enter a comma, a 1 and closing parenthesis. Don't forget to press Update.
Run a test. Review the output of the Compose action.
Compose the File Name
I've renamed the number compose action to New File name and added static text as well as a file extension.
Run a test. Review the output of the Compose action.
Create the File
Just like the previous option. Add a Create File action. Insert the output of the Compose action above into the File name field.
Run a test.
For more flow troubleshooting tips—check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows
IN THIS VIDEO:
✅ How to troubleshoot a false Condition action result
✅ How to get dynamic content when it isn’t selectable from the list of dynamic content
✅ How to troubleshoot an Apply to Each action that isn’t looping through
✅ How to troubleshoot a skipped Apply to Each action
✅ How to troubleshoot a Filter Query
✅ How to use a SharePoint yes/no column in a Filter Query
✅ How to use Compose actions to troubleshoot a Power Automate flow
✅ How to troubleshoot multiple emails being sent
✅ How to troubleshoot multiple Teams messages being sent
Hope this helps!
If I helped you solve your problem—please mark my post as a solution
✅.
Consider giving me a
👍 if you liked my response!
👉 Level up your Power Automate skills by checking out my tutorials on
YouTube👉 Tips and Tricks on
TikTok and
Instagram
