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
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
Super User
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, 

Highlighted
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!



Super User
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 

Super User
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

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
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

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 Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 314 members 1,824 guests
Please welcome our newest community members: