Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Recurring flow with dynamic content

(1) ShareShare
ReportReport
Posted on by 153
Hello. Have a sharepoint with a list of projects (and the last date the project was touched), as well as users. I want to create a recurring (say twice a month) email that is sent to the users who have projects that have not been updated in a while, and list out their "out-dated" projects. How can I do this within the standard flows within PowerApp? For example, when I go to search for a Trigger within Flows, I can see a Recurrence trigger but I get a warning that I can't add a Trigger as an Action? THANKS!!!
  • Pstork1 Profile Picture
    Pstork1 64,907 on at
    Recurring flow with dynamic content
    OData queries will make it more efficient, but you can just retrieve the entire list and then do a Filter Array on the results. Its not as efficient, but is much easier to setup. A lot of it depends on how big the list will get to be.
  • CedarTree72 Profile Picture
    CedarTree72 153 on at
    Recurring flow with dynamic content
    Thanks. Assuming I'm doing this right, I would need to learn to do ODATA query strings? Also, can I send an email to Bob with just his aging projects, and one to Sally with her aging projects? etc. Thanks!
  • Pstork1 Profile Picture
    Pstork1 64,907 on at
    Recurring flow with dynamic content
    You Would do this by building a Recurrence flow in Power Automate with the flow set to run twice a month.  In the flow you would do a get items on the list of projects and filter out any project where the modified date was less than two weeks old.  then create an HTML table from the projects that are left and send that out as an email. Power Apps would not be involved directly in the process.  The error you are seeing is because you already have a flow with a trigger and can't add a different trigger as an action.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard