cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NVisa
Frequent Visitor

Sending notification email for multiple reminder to each user

Hi,

 

My scenario is each user has multiple certificates, I would like to create a flow that will send reminder every 3 months, 1 month, and 2 weeks before expiration date.

If one user has many certificate that met condition, it will be sent in only 1 email. 

 Below is data sample that will be uploaded to SharePoint as a list.

1.JPG

 

I have search in many topic and create the flow below:

However, this flow work only for single certification so far.

My question is how to make it work for multiple certification expiration dates?

 

page1.JPG

 

page2.JPG

 

 Thanks for your help.

 

1 REPLY 1
Jcook
MVP

Hello,

You will need to have a second loop. (Nested) to loop through all the different certificates in SharePoint.

Add the loop above the Apply to each.
Insert the certificate in the loop.
Now put the original Apply to each inside the newly created one.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (4,133)