I have a discussion list, and a categories list. In the Categories list, there's a column for Moderator, which is a Person or Group. In the Discussions list, the column for Categories Allows multiple values.
This way, a person can start a discussion, and assign it more than one category. But I cannot get a workflow to email multiple moderators to a discussion.
If I uncheck Allow multiple values for Categories in a Discussion item, my workflow works - I followed the basic documentation (here: SharePoint designer workflow to lookup email in another list). But as soon as I change the settings for category column to Allow multiple values, the workflow don't work. I don't think I can use Sharepoint groups, because the recipients will be determined by which categories are assigned to that particular discussion item.
I am rather new to this. We're on Sharepoint Online, and I'm using Sharepoint Designer.
Any help will be hugely appreciated! Matthew