Hi,
I have a flow that pulls data from SharePoint and sends an email with a table of filtered content to the unique people in an assigned to field that works perfectly well.
I have another people field (responsible) in the same SharePoint list that I'd like to now include so that individuals get one email with all the items that they are either assigned to, or responsible for. I can append the different fields to a variable and use Union to establish the unique email addresses but this then removes the filter and they get every list item included in their emails.
Any suggestions on what I need to do. Screenshots on the main flow is below for info.
I then clean the HTML, apply CSS and send the email.


Report
All responses (
Answers (