Using Flow to combine multiple values from SharePoint list into single notification email
I have a large SharePoint list that contains expiry dates for items. I'm looking to create a flow that scans the list daily and emails expiry notifications 2 weeks prior and also on the expiry date.
I've got this to work, but it's sending out a separate email for each item. When there are multiple expirys on the same day, I want the flow to combine these in a single email. I believe I need to use the Create HTML Table function, but i've played around with it for hours and cannot figure it out. Any help is much appreciated! Below is the working flow that currently sends out separate emails: