Forum Discussion
If column value of one item in list 1 match column value of items in list 2, send email (how to?)
Hi all! I have two sharepoint list: List 1 is "Market Intelligence Library" and List 2 is "MI Interest" (see example screenshot attached). List 1 acts as a library to house news articles that are t...
Certainly. Use Power Automate with a trigger set for modifications in List 1 when an item's status is "released." Create a flow that checks if values in the "Category," "#hashtag," or "Geography" columns in List 1 match those in List 2. If a match is found, send an email to the corresponding individuals in List 2. Utilize conditions and the "Send an email" action in Power Automate for this process.
Thank you Jenifar - that is the logic I assumed would work but I am having difficulties build out the actual flow to check the values. I have been playing around and watching some videos but no luck yet! Could you provide a sample flow how this could be done?
