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,
Solved! Go to 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.
=INT((Created-DATE(YEAR(Created-WEEKDAY(Created-1)+4),1,3)+WEEKDAY(DATE(YEAR(Created-WEEKDAY(Created-1)+4),1,3))+5)/7)
Image reference:
Hope it helps.
Best Regards,
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHello 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,
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @Anonymous
Number of week
use below expression
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?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThanks 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
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.
=INT((Created-DATE(YEAR(Created-WEEKDAY(Created-1)+4),1,3)+WEEKDAY(DATE(YEAR(Created-WEEKDAY(Created-1)+4),1,3))+5)/7)
Image reference:
Hope it helps.
Best Regards,
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,
User | Count |
---|---|
88 | |
37 | |
26 | |
13 | |
13 |
User | Count |
---|---|
121 | |
55 | |
37 | |
24 | |
21 |