cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User III
Super User III

Re: Sending notification email for multiple reminder to each user

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Users online (5,728)