web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Rename new files in a ...

Power Automate

Answered

Rename new files in a sharepoint folder adding ascending numerical order

(0) Share

Report

Report

Posted on by rnadolny

Hello,

I need help creating a flow to rename new files from a specific sharepoint folder online, I need this flow to act whenever a file is created or moved to the folder, it needs to keep the original name of the file plus an ascending numerical order.

Example:

New file created in the folder called "archive_test.pdf"

The function should rename the file to "00001 - archive_test.pdf"

Categories:

Using connectors

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-mingkz-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @rnadolny,
Do you want to rename file when a new file created in sharepoint library?
I did some test according to your requirements.
Please try:

Get the last but one file in order of Created desc.
The condition formula is:

length(last(outputs('Get_files_(properties_only)')?['body/value']))

Compose3:

last(outputs('Get_files_(properties_only)')?['body/value'])?['{Name}']

Compose4:

formatNumber(add(int(substring(outputs('Compose_3'),0,5)),1),'D5')

You cannot rename the file directly so you need to get file content and create a new file and delete the old one.

Best Regards,
Kyrie

Was this reply helpful? Yes No

Join the conversation