
Hi - wonder if anyone can assist with a solution to what is a complex requirement which I have struggled with ..
Background
My company’s Organisation to Contact model is N:N as we have relationships with the same person across Organisations
We have implemented a custom entity call ‘Org Contacts’ to support N:N relationship
‘Org Contacts’ stores data relating to each person’s role and phone number but NOT email addresses (as can not retrieve data from a child record)
Emailing requirements
Storing multiple email addresses
Organisations – different departments work with different email addresses. Need to store up to 5 (2 to be custom fields)
Contacts – require multiple to store personal and work email addresses. Need to store up to 5 (2 to be custom fields)
Sending emails (individual and bulk) must be performed by end user
Sending individual Emails
Organisations and Contacts - Ability to send email to one or more of the addresses held e.g. send to primary and emailaddress3
Sending bulk emails
Organisations and Contacts – ability to send an email to one or more of the email addresses we hold for that Organisation or Contact e.g bulk email an Organisation using email address 2 AND email address 4 but no other email addresses
I guess this requirement can be achieved using flow (in Power Automate) to pick up the values from the specified email address fields and send out an email using Office 365 Outlook connector.
docs.microsoft.com/.../