cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sidhant_02
Post Prodigy
Post Prodigy

Moving Files into another folder in Teams channel and revoking edit access for users for older files

Hi everyone,
Previously I had created a automated flow (that gets triggered every Monday morning) which contains all employee details (like name, email and dates of the current week excluding weekends). The employee information was retrieved from a Teams group and the excel file was shared in the Teams channel (named: Attendance), the flow looked like this:

Sidhant_02_0-1713245729804.png

 

(The varcounter acts like a counter to count the members, initially I am creating the excel file in my OneDrive and then in Microsoft Teams group). 
In the teams channel the files are uploaded as follows:

Sidhant_02_1-1713245812853.png

 

So as you can see all the files are reside here (the highlighted file is the latest one i.e. for the current week) but currently the structure looks a bit messy that is every week the user explicitly has to order the files (by clicking on Modified) so the latest file comes at top, instead I was thinking is there a way that we can move all the files except the latest one into an Archive folder and only the latest file (currently : Attendance_15_04_2024.xlsx at root level and all the other files in another folder) like:

Sidhant_02_2-1713245996386.png

 

And all the files that are in archive should not be editable to users (except Owner which incase is me). So I thought about a way like constructing a recurrence flow (automated flow) that runs on every Monday but after some time (like my first flow runs around 9:30 am so this flow can run around 10 am to avoid any issues) and then compare all the file creation date/modified date with current date if it matches then skip that file (don't move it) else move it to the sub-folder (Here its named Folder/Archive folder)
So I was thinking of some expression like:

 

 

 

['LastModified'],'yyyy-MM-dd'),formatDateTime(utcnow(),'yyyy-MM-dd')

 

 

 

But not sure whether it is correct. The excel file that gets generated looks as follows:

Sidhant_02_3-1713246271705.png

 

And the automated message that is sent in the Teams channel every start of the week (Monday morning)

Sidhant_02_4-1713246319479.png

 

And once the file is moved into the Archive folder : They should not be editable to the users/members of the Teams channel (except the owner: which in this case will be me), so for this do we need to create 2 different flows one to move files into archive folder and other to  revoke permissions or can it be done in flow itself?.

If anyone has any idea about the same please do let me know, it will be helpful.
(Also I have posted another query which is related to the same use case if you guys can have a look it will help: SubQuery)

Regards,
Sidhant 

2 ACCEPTED SOLUTIONS

Accepted Solutions

Hey Sidhant, 

A Team channel Folder Location is simply a SharePoint Folder location. 

To find your location go to your channel and files and find the Open in SharePoint button. 

JordanRyan_0-1713254951023.png

You should now know your share point folder for your existing files and then you can also do this for your Archive.

You can then use this template to move from one folder to another:
Move files from one SharePoint folder to another | Microsoft Power Automate

Now onto your second point about making these read only. We simply need to manage the Sharepoint folder permissions for the Archive Folder.

So on the sharepoint site for the Archive Folder go back to Documents, find your archive folder and click the 3 dots on the right, you should then see a list like below in which you can select Manage access:

JordanRyan_1-1713255365840.png

 

in here there should see groups called Owners, Members and Visitors.

Owners will have Edit Access and you cannot change this, Visitors will have View Access only and Members will have Edit Access.

So you need to click on Can edit button:

JordanRyan_3-1713255519850.png

 

Expand the Direct Access: can edit (if its not already expanded). Then you can change the permissions to Can view.

JordanRyan_4-1713255591784.png

You then just need Apply this change and then members of the Team can only view any files in the Archive Folder. 

Hopefully this is a viable solution.



 

 




 

View solution in original post

Hi Sidhant, 

If you want a full solution for the moving of the folder weekly I would use the following and make sure it runs before your current automation.

First set a recurrence which is before your other Automation:

JordanRyan_0-1713275964805.png

You then want to get the files in the folder:

JordanRyan_1-1713276046227.png

Site address would be your teams sharepoint site. File Identifier would be the General folder you found earlier (This is the default Channel folder). 

I would create the Archive Folder Under Documents instead of General as we will be taking everything from this file path and moving it to the Archive. 

In your Foreach you would use the body from the get files.

JordanRyan_2-1713276227572.png

Then inside the for each we would use the Move File step.
This is what you need to pick up  items('Foreach')?['Id']

JordanRyan_4-1713276435513.png

 

Both site addresses should be your sharepoint site again, then in the Destination folder you should find your new Archive folder. 

Hopefully this is more of a whole solution rather than a guideline. 

 

View solution in original post

4 REPLIES 4

Hey Sidhant, 

A Team channel Folder Location is simply a SharePoint Folder location. 

To find your location go to your channel and files and find the Open in SharePoint button. 

JordanRyan_0-1713254951023.png

You should now know your share point folder for your existing files and then you can also do this for your Archive.

You can then use this template to move from one folder to another:
Move files from one SharePoint folder to another | Microsoft Power Automate

Now onto your second point about making these read only. We simply need to manage the Sharepoint folder permissions for the Archive Folder.

So on the sharepoint site for the Archive Folder go back to Documents, find your archive folder and click the 3 dots on the right, you should then see a list like below in which you can select Manage access:

JordanRyan_1-1713255365840.png

 

in here there should see groups called Owners, Members and Visitors.

Owners will have Edit Access and you cannot change this, Visitors will have View Access only and Members will have Edit Access.

So you need to click on Can edit button:

JordanRyan_3-1713255519850.png

 

Expand the Direct Access: can edit (if its not already expanded). Then you can change the permissions to Can view.

JordanRyan_4-1713255591784.png

You then just need Apply this change and then members of the Team can only view any files in the Archive Folder. 

Hopefully this is a viable solution.



 

 




 

Hi @Jordan-Ryan ,
Thanks for the response I will check it, just had one doubt. Currently the files are created in Documents-General  section which is 

Sidhant_02_0-1713265349488.png

So let's say next week on 22/04/2024 when the flow will be triggered at that moment except the latest file which will be : 'Attendance_22_04_2024' all the other files should be moved to the archive folder so how will this check be done in the template that you shared in your reply.

Sidhant_02_0-1713266031179.png

(The template that you mentioned has 3 action items as shown above) so where do I need to specify the source which will be : Documents-> General (In Attendance Teams channel) and the destination would be: Documents-> General->folder (archive). And this flow should run at the start of week (like the original flow which creates the work mode attendance sheet but after some time like around 10 am) and move all the files except the file that is generated most recently


Regards,
Sidhant

Hi Sidhant, 

If you want a full solution for the moving of the folder weekly I would use the following and make sure it runs before your current automation.

First set a recurrence which is before your other Automation:

JordanRyan_0-1713275964805.png

You then want to get the files in the folder:

JordanRyan_1-1713276046227.png

Site address would be your teams sharepoint site. File Identifier would be the General folder you found earlier (This is the default Channel folder). 

I would create the Archive Folder Under Documents instead of General as we will be taking everything from this file path and moving it to the Archive. 

In your Foreach you would use the body from the get files.

JordanRyan_2-1713276227572.png

Then inside the for each we would use the Move File step.
This is what you need to pick up  items('Foreach')?['Id']

JordanRyan_4-1713276435513.png

 

Both site addresses should be your sharepoint site again, then in the Destination folder you should find your new Archive folder. 

Hopefully this is more of a whole solution rather than a guideline. 

 

Thank you @Jordan-Ryan for the detailed step-by-step instructions it was quite helpful. I incorporated the steps that you mentioned in your previous reply, I tried it in one of Demo Site named 'Trial' (before using it on my main site i.e. Attendance)

Sidhant_02_1-1713353748051.png

 


-

Sidhant_02_0-1713353702368.png

I had uploaded 3 pdf files in the General file section (inside Documents) and triggered the above flow around 16:40 pm and it moved those 3 files in Archive as per expectations (which you can see in the above image)

Thanks & Regards,
Sidhant.

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24  17 @Anil_g  7 @ManishSolanki  13 @eetuRobo  5 @David_MA  10 @VishnuReddy1997  5 @SpongYe  9JhonatanOB19932 (tie) @Nived_Nambiar  8 @maltie  2 (tie)   @PA-Noob  2 (tie)   @LukeMcG  2 (tie)   @tgut03  2 (tie)       Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate  @Deenuji  12@ManishSolanki 19 @Anil_g  10 @NathanAlvares24  17 @VishnuReddy1997  6 @Expiscornovus  10 @Tjan  5 @Nived_Nambiar  10 @eetuRobo  3 @SudeepGhatakNZ 8     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22   Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 4:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji11FLMike31Sayan11ManishSolanki16VishnuReddy199710creativeopinion14Akshansh-Sharma3SudeepGhatakNZ7claudiovc2CFernandes5 misc2Nived_Nambiar5 Usernametwice232rzaneti5 eetuRobo2   Anil_g2   SharonS2  

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Users online (1,497)