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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / A single notification ...
Power Automate
Unanswered

A single notification message for multiple files

(0) ShareShare
ReportReport
Posted on by 15

I am sending email notifications to the last "modifed by" user for files in a sharepoint library that have not been modified in a year.   It would be nice to schedule this every month and send a single notification with links to all the users out of date files.    Any ideas on how to accomplish this?

Categories:
I have the same question (0)
  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    1) Add a recurrence trigger

    2) Get the documents using an Odata filter on the SharePoint library. The expression I have used is 

    addDays(utcNow(),-365,'yyyy-MM-dd') and store it in a variable

    SudeepGhatakNZ_0-1664320678485.png

    3) Save the results in an array

    4) Loop through the array for each distinct user and create an HTML table

    SudeepGhatakNZ_1-1664320877814.png

     

    5) Insert the HTML table in email

    SudeepGhatakNZ_2-1664320909282.png

     

     

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard