Notify subscribers based on multiple choice field

[Anonymous]

Looking to see if anyone has a easier solution to this issue, or if I need to continue down the rabbit hole I've entered 😉

We have a List where users can post information related to different Products, about 25 so far (Cloud, data analytics, social, etc...) and they want it as a Multiple choice field. So, if they post information, and it is related to Cloud and Social, they can choose both.

They then want to be able to send out daily notifications to "subscribers" based on the Products chosen for the articles entered that day.

At first they attempted to create filtered views based on the Choice column, and set alerts on the view. But since it is one article, with multiple choices, the built in SharePoint Alert doesn't always work. They also want to make it so only 1 email goes out to each users. I.E. If a user subscribed to Cloud and Social, and someone selected both from the products, the subscriber will only get one email.

So, here is what I have so far (only 2 of the 25+ products) (the variable is what I'm going to use to track who an email was sent to):

and here is what I have for each "Apply to" step(example Cloud Product):

From a 2nd list, we get the subscribers for Cloud and send an email:

I then append the email address sent to in my variable:

The Next step (Business Registration) has a conditional check on the Variable:

As you can see this is a massive undertaking to go through for 25+ Products.. Oh, did I mention there is a second multiple choice field that they also want to check and send emails out if that was chosen?? 😮

[v-litu-msft]

Hi @Anonymous,

How can users select more than one of their subscriptions, via update item?

If possible, could you please share an item from a Sharepoint list? (Please sheld the key information).

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

The Subscription list is a separate list where users can add a item and, using a Multi-choice field, select which products they want to subscribe to.

When someone posts an article, they have the same Multiple choices to select from. Then once a day the Flow will go through the new articles entered, find the subscribers and send out an email. Using the Variable will allow me to make sure only 1 email a day is sent to the users linking back to the main site where the articles will be added.