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

[Anonymous]

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, 

[RezaDorrani]

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

[abm]

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

[Anonymous]

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]

Hello, @abm 

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

Thanks, 

[abm]

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

[RezaDorrani]

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

[abm]

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

[Anonymous]

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 

[RezaDorrani]

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 · Accepted solution]

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)

• 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:

• Finally, you could consider deleting the initial file.

Hope it helps.

Best Regards,

[Anonymous]

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,