cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarkB1977
Helper I
Helper I

Re: email html table

Hi all.

 

I have a SP list with approx 3000 items.

 

Each item has a title, an expiry date and a compliance column (calculated), and email address.

 

At the moment I have a flow set to run (every month) through the compliance column and if it says "Expired",  "30 Days", or "60 Days" it sends an email to the auditor advising them that item is due for renewal.

 

The issue is we receive a single email for each list item for each expiring item.

 

What I want is for flow to get items, based on the triggers above, create an html array table and email the auditor a single email with all expiring items within the table.

 

Any idea ? 

 

Tia.

 

 

 

1 REPLY 1
mahoneypat
Solution Sage
Solution Sage

Please see this previous solution for how to do this.

Solved: microsoft flow get all items with distinct Assigne... - Power Platform Community

 

Regards,

Pat

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (48,214)