Flow to automatically append date to filename in sharepoint whenever someone creates a new file or modifies ?

(0) Share

Report

Posted on by Nreddy

Categories:

Building flows

I have the same question (0)

All responses (21)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Nreddy

Can you share more details? There is no direct action to rename a file in SharePoint

You can always follow the below steps:

1. Trigger: When a file is created in a folder

2. Split file name on - and check if the first part includes todays date. if yes do nothing. If no,

3. Get file content

4. Create a new file (In the name of this file, add utcnow(dd-MM-yyyy)-filename.extension)

5. Delete the original file.

Hope this helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Nreddy 6 on at

Like (0)

Report

Hi Yash,

Thank you for your prompt reply! The trigger is whenever a user adds new file in a document library or modifies I want the file name to be appended with date. I will follow your instructions and let you know if it worked out for me.
Once again thank you 🙂
Nreddy

Was this reply helpful? Yes No
Nreddy 6 on at

Like (0)

Report

Hi Yash,
If you dont mind would it be possible to send me screenshots of how to accomplish this? I am amateur to flows actually. Your help is very much appreciated please.
Thank you in advance!
Nreddy

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Hi @Nreddy

You can set up something as shown in the image below:

Expressions:

Condition Left: first(split(triggerOutputs()['headers']['x-ms-file-name-encoded'],'_')) Condition Right: utcNow('dd-MM-yyyy') File Name: utcNow('dd-MM-yyyy')

Remember to add the '_' in the file name for this to work.

The file identifier in the delete file action comes from the output of the trigger action.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Nreddy 6 on at

Like (0)

Report

Hi Yash,
I tried the steps mentioned and I was able to see that when I add a file date is getting appended to the file name. But I dont want the date to get appended to the file which was already appended with date and if it did not get modified. See the screenshot please. I see that everytime I add new file to the folder, date is getting appended to all the files causing the files to have multiple dates. Also If I modify the existing file I want the previous date to be placed by current data of modification.
Hope I did not confuse and conveyed my message right.
I appreciate you help alot , thank you 🙂

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Nreddy

Can you share a screenshot of your flow? I tested the flow shared and it worked fine for all the scenarios. Also, if the file is modified the same day more than once, it shouldn't really matter as the current day date is already appended to it.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
neethika 15 on at

Like (0)

Report

Was this reply helpful? Yes No
neethika 15 on at

Like (0)

Report

The expressions I used in flow are:
left :first(split(triggerOutputs()['headers']['x-ms-file-name-encoded'],'_'))
right :utcNow('dd-MM-yyyy')
file name: utcNow('dd-MM-yyyy')
Thank you,
Nreddy

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

@neethika @Nreddy

There is a crucial difference between @yashag2255 suggestion and your current flow implementation.

In your implementation, when building the new file name; original file name is stored first, then you add a '_' symbol, then current date.

@yashag2255 implementation in just the opposite

THis is the reason your condition will always fail

Hope this helps

Was this reply helpful? Yes No
neethika 15 on at

Like (0)

Report

Hi, I did change mine as per Yash's still I see the same thing happening. And for some reason even when I do not add any file or modify the date is appending multiple times. Not sure why thats happening.Please let me know where I am going wrong.
Really appreciate your time and help, thanks!
Nreddy

Was this reply helpful? Yes No