cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AymericH31
Level: Power Up

Automatize the Change a part of the name of a file on a weekly basis

Hello everyone, 

 

On the projects I lead, each friday my colleagues have to upload on Teams a file that is a balance sheet of theirs activities of the week. The file has a specific nommage, eg : PersonName_ProjectNameBalanceSheet_Wxx.pptx

 

I am trying to create a flow that automatically change the 'xx' ( of Wxx ) to the right number of week of the year , eg: W33 , when the file is uploaded to Teams. 

 

Also, the number has also to automatically change each week. 

 

Is it possible ?

 

Thanks in advance for your help, 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Automatize the Change a part of the name of a file on a weekly basis

 

Hi @AymericH31 ,

 

Since you want to change the file name uploaded to Teams, you only need to change the files in the corresponding SharePoint Library.

All files uploaded to Teams are stored in the Document Library of the corresponding Group site.

In this case, you could first use a Calculated Column in the Library to get the weeknumber of the upload date, and then update the weeknumber to the file name.

 

Assuming the file type is PPTX, you could refer to the following method to configure Flow.

  • Create a calculated column in the specified Library to get the weeknumber, please refer to the formula below.
=INT((Created-DATE(YEAR(Created-WEEKDAY(Created-1)+4),1,3)+WEEKDAY(DATE(YEAR(Created-WEEKDAY(Created-1)+4),1,3))+5)/7)

128.PNG

  • Flow is executed when a new file is created in the specified folder.
  • Originally, we need to use HTTP request to change the file name. Instead, we could change the file name by creating a new file.

Image reference:

127.PNG

  • Finally, you could consider deleting the initial file.

129.PNG

Hope it helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

11 REPLIES 11
Dual Super User
Dual Super User

Re: Automatize the Change a part of the name of a file on a weekly basis

Hi @AymericH31 

 

Yes you can run the Flow on a schedule

read file properties , get the name

do a replace expression to change the name 

example : replace (filename, 'xx','33') 

and then reupload te file by renaming it

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Super User
Super User

Re: Automatize the Change a part of the name of a file on a weekly basis

Hi @RezaDorrani 

 

How to find the number of week of the year? In my knowledge there are no expression function available in flow?

 

@AymericH31 , believe you want the week of the year constructed automatically from today's date?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



AymericH31
Level: Power Up

Re: Automatize the Change a part of the name of a file on a weekly basis

Hello RezzaDorrani, 

 

Thanks for your quick answer, 

 

I had the idea of running it with a Schedule, but when it comes to the change of the name , I am looking to use a function to change automatically the number of week , but I did not find it so far .. 

 

Thanks again, 

AymericH31
Level: Power Up

Re: Automatize the Change a part of the name of a file on a weekly basis

Hello, @abm 

 

That's is completly right. And It's that part that I am strugling with .. 

 

Thanks, 

Super User
Super User

Re: Automatize the Change a part of the name of a file on a weekly basis

Hi @AymericH31 ,

 

Thanks for your reply. Currently there are no expression functions available to find the number of week. 

 

If you have Azure subscribtion create a function to return the week and call from flow. Then construct the filename.

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



Dual Super User
Dual Super User

Re: Automatize the Change a part of the name of a file on a weekly basis

Hi @AymericH31 

 

Number of week

use below expression

int(div(dayOfYear(utcNow()),7))
 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Super User
Super User

Re: Automatize the Change a part of the name of a file on a weekly basis

Hi @RezaDorrani  & @AymericH31 ,

 

Please see this thread. There is already a discussion about this? Not sure this works for every year?

 

https://powerusers.microsoft.com/t5/Flow-Ideas/How-to-calculate-week-number-in-a-year-in-flows/idi-p...

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



AymericH31
Level: Power Up

Re: Automatize the Change a part of the name of a file on a weekly basis

Thanks for your answer and your help @abm & @RezaDorrani , 

 

One last question for you @RezaDorrani , I am still a beginner on Teams, when do I have to use the expression ?Because it seems that I cannot use it when I am initializing or creating a variable. 

 

Thanks again 

Dual Super User
Dual Super User

Re: Automatize the Change a part of the name of a file on a weekly basis

Hi @AymericH31 

 

? is only used when traversing arrays or objects in expressions

 

example : outputs('Compose')?['result']

The question mark ? syntax checks to see if result exists as a node in the Compose output before fetching it

 

If you avoid ? and use  outputs('Compose')['result'] as an example

This will also work but will always expect the result node to be present

If it is not your Flow will error

 

hence ? is a good practice which always helps to check if the node is not null

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Highlighted
Community Support Team
Community Support Team

Re: Automatize the Change a part of the name of a file on a weekly basis

 

Hi @AymericH31 ,

 

Since you want to change the file name uploaded to Teams, you only need to change the files in the corresponding SharePoint Library.

All files uploaded to Teams are stored in the Document Library of the corresponding Group site.

In this case, you could first use a Calculated Column in the Library to get the weeknumber of the upload date, and then update the weeknumber to the file name.

 

Assuming the file type is PPTX, you could refer to the following method to configure Flow.

  • Create a calculated column in the specified Library to get the weeknumber, please refer to the formula below.
=INT((Created-DATE(YEAR(Created-WEEKDAY(Created-1)+4),1,3)+WEEKDAY(DATE(YEAR(Created-WEEKDAY(Created-1)+4),1,3))+5)/7)

128.PNG

  • Flow is executed when a new file is created in the specified folder.
  • Originally, we need to use HTTP request to change the file name. Instead, we could change the file name by creating a new file.

Image reference:

127.PNG

  • Finally, you could consider deleting the initial file.

129.PNG

Hope it helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

AymericH31
Level: Power Up

Re: Automatize the Change a part of the name of a file on a weekly basis

Hi @RezaDorrani , 

 

I think there was a misunderstanding in my last message 'cause it was not about the use of '?'. 

In fact , my question was about the implementation of your expression as a variable in my flow. 

 

I hope it is more clear now. 

 

Thanks again, 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,947)