Share
Report
308Hi Power Automate Community,
I have a SharePoint List with items that has expired from customers.
I am trying to create a flow that can send an email with a summary every week of the items that has expired.
My goal is to list all clients with the items that will expire. My problem is that the same client can be in the list more than once.
For that reason I would need to group the client in order to display the items for each client.
I have look different tutorials online but some of them are not clear or I will get an error.
Can someone please help me with this?
PS. This is the closest that I have get with the flow, but it would repeat the clients for the total number of expiration items that a particular client has.
1 Part:
2 Part: (Get my customer list in order to see which customer in this list is present in the expiration list.
3 Part: Filter expiration based on the customers in Get Items 4 (filtered).
4 Part: Select columns, create HTML table from select, Format HTML table.
I have set the names from the clients in Gallery 4 as "Title" and the Compose (Format HTML) as Outputs.
5 Part: Send an email with the Join expression
join(variables('varHTML'), '').
All responses (
Answers (
