I have a SharePoint list that has a site column that has around 15 different options in the column. Each site has an associated email I want to send information to. What I am wanting to do is check a "Checked In" column for nulls and then collect those records for each site. Once those records are collected I want to send an email to the associated email for each site with only their records in the list.
If I wasn't dealing with multiple sites/emails I would just use a string variable and append the records to the string variable.
I currently am using a Get items to gather the nulls for the last 7 days, I am just stuck on how to separate them out to send the items to their associated teams. (Site1 records sent to Site1 associated email, etc.)
Share
Report
All responses (
Answers (
463
