Email sent to non-specified recipients

[jmac_lcon]

I have set up a very simple flow for our organisation which looks for upcoming events in an individual's calendar, then sends a reminder email to event attendees 24 hours before the event.

The flow works perfectly apart from one small quirk...

The reminder email is only supposed to go to required event attendees. This is specified by putting the dynamic content block 'Required attendees' in the 'To' field of the email action. 

For some users, the reminder email is sent to the required attendees as intended, but the user (in this case, the event organiser) is also included in the 'To' field and receives a copy of the reminder email. 

Any thoughts as to why this might be?

Thanks!

[efialttes]

I am afraid I do not have an answer for such particular behaviour, but  may I suggest a possible workaround.

I believe your 'Required attendees' event dynamic output is string with 1..n email addresses separated by semicolons. Assuming 'Required attendees'  is stored in a string variable named 'RequiredAttendees', allso 'Organizer' is stored in its own string variable calld 'Organizer'... then you can use the following expression to remove Organizer email from 'Required attendees' if present:

replace(replace(variables('RequiredAttendees'),variables('Organizer'),''),';;','')

Please note variables are not strictly needed, i.e. you can replace both variables in the WDL expression and use the equivalent event dynamic values instead
Please also note this is not the only workaround, you can also convert 'Requred Attendees' into an array by means of split(), remove the organizer by means of a 'Filter array' action block, and convert back the array into string by means of join()... and several other alternatives also.
Hope this helps

[FLMike]

Hi,

They have to be in that email group, or it wouldn't go to them. Can you look at the RUN itself and then look at that action and get the list of email addresses.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[jmac_lcon]

Hello,

I've taken a look at the RUN and the 'To:' field in the email includes both the required attendees and the personal email of the organiser.

When building the flow I used a preset called 'Required attendees' under the Dynamic Content menu. Any idea why it might be including the organiser too?

Thanks

[jmac_lcon]

Thanks for responding! 

This sounds very complicated, but I trust it might work!

Whereabouts should I include this expression? In the 'To:' field of the automated email? And if so, do I also need to include the Dynamic Content item 'Required attendees'? 

Thanks

[efialttes]

Hi! The expression manipulates the list of semicolon separated emails, by removing the organizer if present. You should add it to the 'To' input field.
Please note te expression is variables based, I am assuming you previously stored both 'Requied attendees' and 'Organizer in a couple of variables by means of 'Initialize variable' action. 
Hope this helps
==========

[jmac_lcon]

Hi again! 

I have not previously stored 'Required attendees' and 'Organizer' as variables... I was using a menu called 'Dynamic Content' that appears as part of the flow creator.

Is there any online guidance for how to use the 'Initialize variable' action?

Thanks 

[efialttes]

Hi @jmac_lcon 
Using variables is not needed.
You can build an WDL expression by adding dynamic content instead.
Please have a look to this videotutorial
https://www.youtube.com/watch?v=gugbtAZg0bg
Hope this helps
==========