cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
v-bacao-msft
Community Support
Community Support

 

Hi @Anonymous ,

 

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
RezaDorrani
Community Champion
Community Champion

Hi @Anonymous 

 

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

Hi @RezaDorrani 

 

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

 

@Anonymous , 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!

Learn more from my blog
Power Automate Video Tutorials
Anonymous
Not applicable

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, 

Anonymous
Not applicable

Hello, @abm 

 

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

 

Thanks, 

Hi @Anonymous ,

 

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!

Learn more from my blog
Power Automate Video Tutorials

Hi @Anonymous 

 

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

Hi @RezaDorrani  & @Anonymous ,

 

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/104499

 

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!

Learn more from my blog
Power Automate Video Tutorials
Anonymous
Not applicable

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 

Hi @Anonymous 

 

? 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

v-bacao-msft
Community Support
Community Support

 

Hi @Anonymous ,

 

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.
Anonymous
Not applicable

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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,091)