web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Build a flow that will...
Power Automate
Suggested Answer

Build a flow that will spin through sharepoint folders and email the results

(0) ShareShare
ReportReport
Posted on by TF-22041522-0
I have about 400 project folders on sharepoint which all have multiple sub-folders.  These are updated by numerous people.
 
What I would like is power Automate to scroll through all of these folders and check if a file has been added or updated. and record the name of the folder it is in.   Collate these recorded folders and email them to me daily
 
Is This possible?
 
Thanks
Categories:
Building flows
I have the same question (0)
  • Suggested answer
    Sunil Kumar Pashikanti Profile Picture
    Sunil Kumar Pashikanti 2,074 Moderator on at
     
    Yes, this is possible, but not by “looping” all folders daily.
     
    Recommended (scalable) approach
    Use event‑based tracking, not folder scanning.

    How it works

    Trigger:
    Use SharePoint – When a file is created or modified (properties only) at the document library root.
    Capture metadata:
    From the trigger you already get:
    • File path
    • Folder name (project folder)
    • Modified date
    Store results:
    Write the folder name (or derive it from the path) into:
    • A SharePoint list, or
    • An array variable (grouped by date)
    Daily email:
    Use a scheduled flow to:
    • Get that day’s entries
    • De‑duplicate folder names
    • Email the list to yourself
    This scales
    No performance limits hit
    No 400‑folder loops
     
    ❌ What not to do
    Loop through all folders daily (Get files (recursive))
    Nested “Apply to each” across 400+ folders
    ➡️ This is slow, expensive, and will hit flow limits.

    Final verdict
    Yes, this is absolutely possible. The correct pattern is to track file changes using the SharePoint “file created or modified” trigger, capture the parent folder name, store it, and send a daily summary email. Avoid scanning folders, use event‑based tracking instead.
     
    ✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
    👍 Feel free to Like the post if you found it useful.

    Sunil Kumar Pashikanti, Moderator
    Blog: https://sunilpashikanti.com/posts/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 889

#2
Valantis Profile Picture

Valantis 830

#3
Haque Profile Picture

Haque 505

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans