cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Phineas
Post Partisan
Post Partisan

Flow that Sends Email

I need a flow that sends and email whenever a threshold is reached.

 

I have a List (List1). On List1 are columns 'CQTitle' and 'DaysRemaining'.

 

I have created a recurring Flow (Compliance Flow).

 

There are 1300 items on the list. The flow should only act upon those items with a 'CQTitle' that matches the string in the Condition, and only upon those whose Due Date is equal to '30'.

 

Will the below do what I desire? And, if I need a email for '60 Days' and '90 Days' is it more appropriate to create three flows (one for each notification), or can each be addressed in this one flow?

 

Task: Once per day;
         Get items from List1 (items to get: CQTitle and DaysRemaining);
         Compare CQTitle to predetermined titles (based on string in Condition)
         Determine if DaysRemaining equals '30' (based on sting in Condition)
         if true send email,
         if false do nothing


Compliance Flow Construction -
     Recurrence: 1 Day
     Get items: List1
     Apply to each: Value
     Condition: List1/CQTitles is qual to string('"Driver","Conductor","Brakeman"')
               and
     Condition: List1/DaysRemaining is equal to string('"30"')
     If yes: Send an email
     If no:

2 REPLIES 2
ganeshsanap
Super User
Super User

@Phineas 

Yes, it is achievable using the Power Automate flow with the configuration steps you mentioned.

 

No need to create three flows for '60 Days' and '90 Days' email notifications, you can easily manage it in the same flow.

 

Check this documentation for creating a recurring flow: Run flows on a schedule

 

There is a predefined template for similar requirements, this will help you to get started with: Send notification email for SharePoint list items on a recurring basis

 

Also, check below article which might help you while configuring the flow:

Send email reminders from Microsoft Lists using Power Automate


Please click Accept as solution & ‌‌👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

 

Best Regards,

Ganesh Sanap

Blog site 

I believe I've almost got it.

 

The flow now sends an email for ONLY the Title in the Get items filter.

 

However, it sends 60 emails because there are 60 items with that name.

 

However, when the Condition (DaysRemaining is equal to "30" [I manually entered the 30 into the right side of the Condition], this did not send out an email, even though there is one Title that matches that has a DaysRemaining of 30.

 

When the condition was equals to or less than "31" I got 60 emails.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,084)