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 / SharePoint: Alerting O...
Power Automate
Suggested Answer

SharePoint: Alerting Owner when their file has not been updated within a period of time

(1) ShareShare
ReportReport
Posted on by SC-20081517-0 2

Hello,

Our company has a SharePoint site dedicated to our Company Policies. All policies live in a single document library on the site. The site has a content type attached which includes file, file name, department, division, policy owner, modified by and last modified date. What is the best way to setup a global alert on that site that will inform the assigned policy owners when their file's last modified date is greater than 1 year? I started in the Microsoft Community and they redirected me here. I am brand new to Power Automate.

 

Thank you!

Categories:
General topics
I have the same question (0)
  • Suggested answer
    David_MA Profile Picture
    David_MA 14,090 Super User 2026 Season 1 on at
    You basically want to do the following:
    • Create a scheduled flow to run once per day.
    • Add a Get items action with a filter query to where the current date -365 days equals the modified date. Be sure to format the filter query to use an ISO8601 formatted date (yyyy-MM-dd). 
    • Use a condition with a length expression to make sure at least 1 item is found.
    • Then use an Apply to each on the items found to send the e-mail notification.
    • You will want to include a Get user profile to make sure that the owner account is still active and then add a catch/release if the account is invalid.
    • If it is valid, send the e-mail and if it is not valid, decide what you want to do.
  • Suggested answer
    N__A Profile Picture
    N__A 18 on at

    ​​​​​​1- Create a Flow in Power Automate:

    • Go to Power Automate and sign in with your Microsoft account.
    • Click on “Create” and select “Scheduled Cloud Flow”.
    • Choose the trigger “Recurrence” to run the flow on a schedule (e.g., daily, weekly).
    • Set the frequency according to your needs (e.g., once a day).
    2- Get Files from SharePoint:
    • Add a new step and select “Get files (properties only)” from the SharePoint connector.
    • Configure it to point to your document library where the policies are stored.
     
    3- Filter Files Based on Last Modified Date:
    • Add a “Filter array” action to filter the files retrieved.
    • Use the following expression to filter files where the last modified date is greater than one year:


    4- Send Email to Policy Owners:
    • Add an “Apply to each” action to loop through the filtered files.
    • Inside the loop, add a “Send an email (V2)” action from the Office 365 Outlook connector.
    • Configure the email to be sent to the policy owner with a message indicating that their policy needs review.
    ​​​​​​​ 

    ---

    If this post helps you with your problem, please mark this answer as Accepted Solution.

    If you like my response, please give it a Thumbs Up.

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
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 281 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

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
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans