I have a "Training materials" SharePoint list where I keep list of training materials. It has Name, Last Updated (date), Author columns. Every training material must be revised every 3 years. One Author might have multiple materials.
I have created a Power Automate flow that will send reminder to author prior to 30 days to revise the material. However, my problem is to make it in a way so Authors to receive list of tm's only about their training materials. So each author needs to see its own material the email they receive. I want them to be grouped and sent as single email not like separate reminder for each material. My current flow sends list of tm's to be revised but it sends separate emails for each record.
My current flow looks like below
Recurrence
Initialize variable 30 days
Get items (filter 30 days)
Create HTML table
Condition (checks if there is a record in Get items)
Apply to each (value) ---> Send email
