Unanswered

Recurring flow with dynamic content

(1) Share

Report

Posted on by CU04021832-1

171

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!!!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Pstork1 69,026 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
CU04021832-1 171 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Pstork1 69,026 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No