Need help with using Utilities.SendEmail to send emails to multiple recipients

[lumberjacklurch]

I am trying to build a flow that looks at a Person or Group field, and determines if there is more than one person.  If there is only one person, the flow sends two different emails (via Utilities.SendEmail).  If there is more than one, it sends a single email to all of them (ex person1@email.com;person2@email.com).  My problem is, I'm using an Apply To loop and in the loop I'm appending the semicolon to separate the different people/emails.  The SendEmail api doesn't like this because the loop appends a semicolon to the end of the To property (ex person1@email.com;person2@email.com;).  It complains that the email address is invalid.  The Mail connector doesn't have this issue, but I don't want to use that because the From is a generic MS name.  

How do I populate the To property, and not have the trailing semicolon?

[lumberjacklurch]

I've tried a Do Until loop, but it won't let me choose the variable for some reason.

[Hardesh15]

@lumberjacklurch  After appending all items in a string with semi colon you need to break string for each value using split().

Your first split- first(split(),';')

Second split - first(skip(split(),';'),1))

Third split - first(skip(split(),';'),2))..etc.

once each split store in compose use concat() expression and build your value.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[lumberjacklurch]

@Hardesh15 

Thank you for the reply.  That sounds fine, but what if I don't know the number of people?  How do I do that in a loop?  Sorry, I'm a noob.

[Hardesh15]

@lumberjacklurch This is the limitation of this solution. suppose you have 10 items and you defined such expression for 11th items then it will not harm you. the output for 11th item will be null.

i will try to think more on this.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[Paulie78]

I would just create an array of email addresses and use the join expression to join them together. It would not append a semi colon on to the end of the last record and would be much simpler than your current approach. If you only want the email to go to one person create a condition that works on the basis of the number of emails. If you post an image of your flow I will try to show you a sensible approach where to put it.

[Hardesh15]

@Paulie78  Agreed didn't click in my mind.

Thanks

Hardesh

[lumberjacklurch · Accepted solution]

This is exactly what my coworker suggested (shout out to @ChadVKealey).  It is MUCH simpler.  I'll spell out the process for folks in the future.

-After you get the record/item from the sharepoint list, create a Select action

-For the Input, from Dynamic Content, select the column that has the field you want (in my case it was Approver)

-For the Map value, click on the button on the right to change to text mode.  From Dynamic Content, select the property you want (in my case, it was Approver Email)

-Create an Initialize Variable action

-Name the variable (ex var_Emails).

-For the Type, choose String

-For the Value, use the Expression: join(,''',''')

-After the first parentheses and before the first comma, from Dynamic Content, select the Output from your select action.

-If you didn't change the default name of your select action, it should look like this:

                  join(body('Select'),''',''')

-Now you can use the string variable in the To line for the email step

Here's a pic of the steps in my flow for reference

MUCH simpler!