I have a SharePoint list with the following mandatory fields where multiple selections/values are allowed:
I need to create a Flow when a new item is submitted that sends an email to the people in Field 1 with the people selected in Field 2 cc'd in. The selections in Field 3 need to be in the body of the email.
Each time I try to do this, it puts the 'Send an Email' action into an 'Apply to Each' control, which results in multiple emails being sent, however I only need/want one email to be sent per submission.
If I amend the fields to only allow one selection, then this works perfectly.
Is it possible to do this with multiple values? Any help would be greatly appreciated.
For reference I have attached a screenshot of the current config of the flow.
Solved! Go to Solution.
Hi @Sam12, have a look at the flow below which will just send 1 email with the values selected (in my example they are A and C):
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
Hi @Sam12 ,
Basically, the method provided by @RobElliott has solved your problem.
It should be noted that if you integrate email address, it is recommended to set the variable type to String and add a semicolon at the end of the Value.
Also if you need choice values separated by commas, please consider using Join action.
Best Regards,
Hi @Sam12, have a look at the flow below which will just send 1 email with the values selected (in my example they are A and C):
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
Hi @Sam12 ,
Basically, the method provided by @RobElliott has solved your problem.
It should be noted that if you integrate email address, it is recommended to set the variable type to String and add a semicolon at the end of the Value.
Also if you need choice values separated by commas, please consider using Join action.
Best Regards,
User | Count |
---|---|
88 | |
79 | |
45 | |
29 | |
25 |
User | Count |
---|---|
38 | |
29 | |
26 | |
22 | |
18 |