User Profile
MatanG6
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Flow to send email to different individuals based off SharePoint List
Hi All! I will attempt to state the following as clearly as possible 🙂 I have a flow set up to send me a notification. It's triggered when the SharePoint List column 'Development Date' (date format) hits 90 days past the specified date. At times this can be multiple line items that have the same Development Date. This works well with no problems. My next goal I am hoping can be accomplished is to have the flow send an email to the individual who is tied to that respective line item/row. It is a column in the List, 'Point of Contact'. I don't see an issue with this if there was ONLY one line item that hits the +90 day 'Development Date', but this sounds tricky when there are multiple line items. My hope is to have the automation look at the first column, 'Opportunity', and send an email to the Point of Contact that is tied to that Opportunity without including the other line items that DO NOT pertain to that specific individual. The email context will be the same other than those dynamic field. I was thinking that I couldn't leverage the Switch Control condition because the 'Opportunity' does not equal the same every time. Opportunity names change and Point of Contacts change per opportunity. Please let me know if I can further clarify any of the above! Thanks in advance and much appreciated!
Groups
Recent Blog Articles
No content to show