1

Hoping to get some insights / direction here. I posted on the community MS forum but no-one really help. I'm not very technical and have been battling for months to build a full solution anyways.

Scenario: I have a SP List with columns. One of the columns I a multi-select column. I trigger a MS Flow when a certain column value changes. This all is working except the Power Automate flow when adding the multi-selectable field in the Send Mail(v2) action it adds as a (Apply to Each).

Now the flow initiates "duplicate" emails for each selected property of that column.

Can anyone help?

Thanking you in advance. I can export the flow to anyone who can help.

EDIT: Just adding my entire flow here... Part 1

Part 2

PArt 3

Improve this question

1 Answer 1

Reset to default
0

You can declare a string variable to capture all emails and then finally use that in string variable in email action like below:

enter image description here

Ensure that within "Append to string variable" you add semicolon towards the end as a separator.

References:

  1. Send one e-mail to multiple selection person or group column
  2. Multiple selection people picker causes multi emails
  3. Flow I need to send email to multiple user
Improve this answer
6
  • Ah Ganesh ..im sorry i'm trying to understand your solution. Again i'm not very technical im just not sure where to add this?.....
    – Laurence Sher
    Commented Aug 27, 2022 at 20:24
  • What is "Vandalism Des..." in apply to each in last image? What is the column type (multiple selection choice?). Do you want to send one email per selection or single email with all selection values shown in email body?
    – Ganesh Sanap - MVP
    Commented Aug 28, 2022 at 5:14
  • Hi Ganesh - yes that's the "offending" column. It is the multi-select column in the Shoeproint list, ?users can select up to 9 possible selections . If they select more than one item. Than one mail PER item is sent... I need to restrict that. I will probably leave that field out of the email if i cant get this right..
    – Laurence Sher
    Commented Aug 28, 2022 at 5:34
  • You need to convert this multi-value (array) column to single string variable to use in email body. Follow this and this.
    – Ganesh Sanap - MVP
    Commented Aug 28, 2022 at 6:12
  • Yes ive gone through these posts. Will try again . Thanks
    – Laurence Sher
    Commented Aug 28, 2022 at 7:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.