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

When new files created in sub-folders of Folder

I have a parent folder 'a'  and I know that this will contain sub-folders with varying names e.g 'b' 'c'. I want to recognise when a file is added to any of these subfolders.

 

How can I get MSFlow to recognise 'When an item is created in a subfolder of this folder' as I won't know the specific subfolders name from the start of the flow,

 

I tried using the 'When an item is created in this folder' but it only recognises direct children, and not children of subfolders. It is only a 2 level hierachy, as I'll have parent folder -> child folder -> child document

 

Thanks!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @Anonymous,

 

Do you want to monitor if a new file is created in sub-folders of a specific folder using Microsoft Flow?

 

I afraid that there is no way to achieve your needs in Microsoft Flow currently, It is a known issue that file triggers won't fire for files being added inside of nested folders inside the folder you select.

 

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

More details about known issues and resolutions in Microsoft Flow, please check the following article:

Known issues and resolutions

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
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

22 REPLIES 22
v-xida-msft
Community Support
Community Support

Hi @Anonymous,

 

Do you want to monitor if a new file is created in sub-folders of a specific folder using Microsoft Flow?

 

I afraid that there is no way to achieve your needs in Microsoft Flow currently, It is a known issue that file triggers won't fire for files being added inside of nested folders inside the folder you select.

 

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

More details about known issues and resolutions in Microsoft Flow, please check the following article:

Known issues and resolutions

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

I don't know if this is a new feature since this post, but it's still listed as a known limitation and I've gotten it to work using the trigger - "When a file is created (properties only)".  In the Folder field, I select main folder/subfolder.  Then, for any folder I create under subfolder, I can add a file to it and it will trigger the flow.  Then, later in the flow, I use the Get file content action so I can get the attachment itself.

Anonymous
Not applicable

This did NOT work for me?! Smiley Sad

Anonymous
Not applicable

This is a simple Flow I tested and it triggers to send an email when a file is uploaded to Folder1 or to any of the subfolders under it.  I'm using SharePoint Online.

 

Capture.JPG

Anonymous
Not applicable

Hi

 

I think we talking cross purposes here. I thought this was to do with the "File System" flow trigger. 

Here is my flow that is not working on subfolder changes. 

 

Capture.PNG

I have since looked into the issue and as 

josh2
Helper II
Helper II

has anyone had any luck with this flow with dropbox as the trigger

Anonymous
Not applicable

I never got it working i'm afraid.

has anyone had any luck with this flow with sharepoint as the trigger

Anonymous
Not applicable

Yes @rupach - see my earlier comment.  I use it with SharePoint Online - When a file is created (properties only).

thank you for your reply. 

could you please help/guide me on my below requirement...

Requirement: 
Share Point has multiple folder structure with nested folder in it and each folder has a group of users and one business owner for the complete folder structure. (Shown in the example below)

I need to implement a flow which triggers an email notification to its corresponding business owners requesting to Approve/Reject when an item/file is created in a folder/sub folder.

Once Approved/Rejected I would need to update the file status on the SharePoint based on the response to the email.
How do i achieve and specify folder specific business owner emails in the flow.

Implemented: 
I have implemented a flow which sends an email when an item/file is created in any of the folder and status is also updated on the SharePoint as per the email response.

 

Road block: An email is triggered to parent  business owners from the folder structure when there is a file created only in a child  folder where it is supposed to send an email to that particular business owner when/where a file/Item is created.


Ex: My issues in the below scenario
1) The email to business owner A only when the file is created in Folder A and Sub folder B, where as it is supposed to send the email  only to Sub Folder B.



Folder A (Business Owner A)
     File 1
     Sub folder B (Business Owner B)
        Sub folder B File 1
     Sub folder C (Business Owner C)
        Sub folder C File 1

 

 

 

Folder A

Sub Folder A1

Sub Folder A2

Email Trigger

 

When an new file is added

N

N

Email only to Folder A business Owner

 

 

When an file is created in Sub folder A1

N

Email only to Sub Folder A1 Business Owner

 

 

 

I have tried to achieve this by creating an Custom List on Share point where Custom List has all folders and sub folders with their corresponding business owner email id’s. I had created an file in sub folder A1 and I tried to filter the sub folderA1 from Custom List ,I am not finding any function to retrieve sub folder A1 from folder path and use that as a filter condition to filter custom list. 

 

Could you please guide me what I am missing and also help me with the solution ?

 

Anonymous
Not applicable

@rupach  Can you use the entire folder path as the key on your Custom list instead of just the subfolder?  For example, your Custom List key field that you would use to retrieve the Business Owner could be Folder A/Sub folder B.

 

That's the easiest way.  If you need the Custom List key field to be just the subfolder, then you'll need to use some functions in your flow to find the last backslash of the folder path and determine the text from the last backslash to the end.

I tried to use the functions in flows but nothing helped me out. Could you please give me detail explanation of the answer..


@Anonymous wrote:

@rupach  Can you use the entire folder path as the key on your Custom list instead of just the subfolder?  For example, your Custom List key field that you would use to retrieve the Business Owner could be Folder A/Sub folder B.

 

That's the easiest way.  If you need the Custom List key field to be just the subfolder, then you'll need to use some functions in your flow to find the last backslash of the folder path and determine the text from the last backslash to the end.


 

Anonymous
Not applicable

Your Custom list should look something like this:

 

FolderNameBusiness Owner
Folder A/Sub Folder BJohn Doe
Folder A/Sub Folder CJane Smith

 

Then you don't need any function to retrieve the subfolder from the folder path.  The folder path will match the FolderName field in your Custom list.

Thank you this solution help me. Only concern is i have multiple nested folders with in sub folders. In this case length will be high.

Thank you!

It did the trick for me 😉

Christopher555
New Member

Hi

 

I too want to automate a process of moving CVs (Resumes) from an SFTP to a SharePoint Site document folder.

 

However Jitterbit, which I am using to move the CVs to SFTP is filing them under sub folders. So subfolder name is the role name and the CV is the applicants name with whatever extension (doc, pdf, etc).

 

However my Automate will not trigger and of course I do not know the role names therefor the sub folder names before hand.

 

I am only using MS Automate because my Graph API access has limited abilities/access!

 

I have a work around, I am going to save the CVs with RoleName_ApplicantName then use a flow to create the file in SharePoint in a folder/ApplicantName format in SharePoint (using the underscore to indicate where it folder splits from file) but my SFTP site is going to get messy with 1000's of orphan CVs!

 

Thanks in advance for getting this on next development.

Christopher

cindyc
Frequent Visitor

Guys,

I was also able to verify that using Sharepoint Trigger "When a file is created (properties only)", will drill down into sub folders and find the newly created file.  I just follow it immediately with a Sharepoint "Get file content" action and it works great. In fact the files that are created are 4 subfolders deep from the root folder, so this is exactly what I needed, thank you!,

CC

This is a very much needed feature. Unfortunately your link to the forum does not allow me access - I am a heavy users of Power platform - both for my company (where I am not an Admin) and for a domain I own. Neither accounts allow me to sign in and even view that flowidea page you provided.

 

if you google 'flow ideas' or 'power automate ideas' it will direct you to the correct page.

Helpful resources

Announcements

Celebrating the May Super User of the Month: Laurens Martens

  @LaurensM  is an exceptional contributor to the Power Platform Community. Super Users like Laurens inspire others through their example, encouragement, and active participation. We are excited to celebrated Laurens as our Super User of the Month for May 2024.   Consistent Engagement:  He consistently engages with the community by answering forum questions, sharing insights, and providing solutions. Laurens dedication helps other users find answers and overcome challenges.   Community Expertise: As a Super User, Laurens plays a crucial role in maintaining a knowledge sharing environment. Always ensuring a positive experience for everyone.   Leadership: He shares valuable insights on community growth, engagement, and future trends. Their contributions help shape the Power Platform Community.   Congratulations, Laurens Martens, for your outstanding work! Keep inspiring others and making a difference in the community!   Keep up the fantastic work!        

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Check Out the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community.  We can't wait to see what you "cook" up!    

Welcome to the Power Automate Community

You are now a part of a fast-growing vibrant group of peers and industry experts who are here to network, share knowledge, and even have a little fun.   Now that you are a member, you can enjoy the following resources:   Welcome to the Community   News & Announcements: The is your place to get all the latest news around community events and announcements. This is where we share with the community what is going on and how to participate.  Be sure to subscribe to this board and not miss an announcement.   Get Help with Power Automate Forums: If you're looking for support with any part of Power Automate, our forums are the place to go. From General Power Automate forums to Using Connectors, Building Flows and Using Flows.  You will find thousands of technical professionals, and Super Users with years of experience who are ready and eager to answer your questions. You now have the ability to post, reply and give "kudos" on the Power Automate community forums. Make sure you conduct a quick search before creating a new post because your question may have already been asked and answered. Galleries: The galleries are full of content and can assist you with information on creating a flow in our Webinars and Video Gallery, and the ability to share the flows you have created in the Power Automate Cookbook.  Stay connected with the Community Connections & How-To Videos from the Microsoft Community Team. Check out the awesome content being shared there today.   Power Automate Community Blog: Over the years, more than 700 Power Automate Community Blog articles have been written and published by our thriving community. Our community members have learned some excellent tips and have keen insights on the future of process automation. In the Power Automate Community Blog, you can read the latest Power Automate-related posts from our community blog authors around the world. Let us know if you'd like to become an author and contribute your own writing — everything Power Automate-related is welcome.   Community Support: Check out and learn more about Using the Community for tips & tricks. Let us know in the Community Feedback  board if you have any questions or comments about your community experience. Again, we are so excited to welcome you to the Microsoft Power Automate community family. Whether you are brand new to the world of process automation or you are a seasoned Power Automate veteran - our goal is to shape the community to be your 'go to' for support, networking, education, inspiration and encouragement as we enjoy this adventure together.     Power Automate Community Team

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today! https://aka.ms/PowerUp  

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Users online (6,863)