Power Platform Community Forum Thread Details

Hi all, (My apologies, I cannot tag or accept your replies as answers, so if you do help me, i really do appreciate it)

I have a sharepoint list that holds volunteer details for helping out a charity. I am building an app to be able to send them all emails depending on what stage they are at.

I currently have three checkboxes Email all, Applied and assessment. Oncheck collect- capture the following:

Collect(ColEmailAll,ShowColumns('EoI Database','Your first name','Your email address'))
 
Is there away to link the "Send To email box" to the sharepoint list and/or use the "check boxes" and collections to get the email address and name.? So if I selected/Check "Email all". when I press Send, it emails all email addresses in the collection
and adds in their first name before the message box. The user then just populates Subject,Message, attachments etc.  If possible, it would be good to use both the "Send email to" and the Checkboxes if that is possible.
 
Only one Check box will be checked at any time.
 
My current email code is:

Set(_emailRecipientString, Concat(MyPeople, Mail & ";"));           
Office365Outlook.SendEmailV2(_emailRecipientString, TextEmailSubject2_1.Text, RTEBody.HtmlText, {Attachments:RenameColumns(AttachmentControl.Attachments,Value,ContentBytes), Importance:"Normal"});         
Reset(TextEmailSubject2_1);           
Reset(RTEBody);
Reset(AttachmentControl);           
Clear(MyPeople)

Hopefully that makes sense, thank you for taking the time to read my post. (PS do not worry about the Event link, thats being removed) Any direction or help would be great as this is way above my head but i am willing to learn.