Send multiple emails from SharePoint list

[mithushalk]

Hi, need help in fixing my flow,

I am building a flow to send email to the teams based on the form response. 
I am able to send email, if user chooses only 1 option but when user chooses 2 or more options email isn't processing.
Flow runs successful but mail won't be delivered.

Question in the form

My List on the SharePoint

My Flow 

Filter Query - 

replace(replace(outputs('Project_Collect_Response')?['body/rede014bb885a4ad4b331cd09384a409c'],'["',''),'"]','')


Email To - 

outputs('Get_items')?['body/value']?[0]?['Team_x0020_Email_x0020_Address']

Please help me how can I proceed with this?

[tom_riha]

Hello @mithushalk ,

try to store the result of the replace(...) expression in a 'Compose' action before 'Get items', you'll see why it's not sending anything.

(you're searching for item where Title eq 'Finance,Legal,Privacy' and there's no such item)

Try to use the split(...) expression to split the Forms response by ',' to get an array with the single values. Then you can loop through the values and use 'Get items' for each of them separately, and send the email.

[PrasadAthalye · Accepted solution]

Create a String variable and inside Apply to each, append email address to that variable using Append to string variable. Then move Send email action outside Apply to each and use string variable.

[mithushalk]

@PrasadAthalye 

I cannot use Initialize variable as it can be used only on top the flow. 

[mithushalk]

@tom_riha 

I followed the steps.
Can you please confirm what should I use in TO field while sending a mail?

[mithushalk]

Hi @tom_riha 

Flow ran successful but email wasn't sent.

Splits - 

split(outputs('Project_Collect_Response')?['body/rede014bb885a4ad4b331cd09384a409c'],',')

[PrasadAthalye]

Initialize variable on the top of the flow and then use Append to string variable action to append....

[MinotaurUK]

Could you not use a condition based on each response, when the condition has been met (choice of legal, finance or privacy) then use the get items array ?

[mithushalk]

@MinotaurUK 

Can you please explain more so I can follow & try with my flow. 

[MinotaurUK]

you use the condition control to be triggered when the user chooses one of more of the options, it means having quite a few conditions set up but when a conditions are met then you can set up get the mail groups list to email.

I have a flow that has 10 conditions set up, if one of the conditions is triggered it continues the flow...see below:

[mithushalk]

@MinotaurUK Thank you. 

I think I can work to get three emails but is there any way to work 10+ emails?

[MinotaurUK]

you can set up multiple email message/notifications actions on each condition..e.g if condition A is met then send 4 email notification actions,  if condition B is met send 2 email notification actions etc

[mithushalk]

@MinotaurUK 
I totally understand the logic but it would become a very lengthy flow. Instead, don't we have any other way like expressions as such?

[mithushalk]

Hi @PrasadAthalye 

This step is somewhere in between my flow so I cannot go to the top of the flow & add Initialize variable. Please can you tell me an alternative?
Also, it can be of great assistance if you can show me a demo with the same technique.

[PrasadAthalye]

It does not matter where you use variable. You can declare anywhere in the root of the canvas. For example, under Senduseremail. Then you can use SET variable anywhere you would like to. 

[mithushalk]

Hi @PrasadAthalye 

As I am very new to Power Automate, I request you show me a demo so I can follow it.
I built one based on your instructions but I believe I got that wrong so email wasn't out.

[PrasadAthalye]

@mithushalk - Please find Entire solution below. Hope this helps...

• Add Forms Trigger and Response Actions..

• Use Join and provide your question as mapping. Use JSON Function. Add Comma as delimiter in Join. 

json( outputs('Get_response_details')?['body/r6c6ad0ab931a4a26b0564e655ebd153c'])

• Now use Compose and Split the output of Join using comma as separator and initialize variable to store emails.

split( body('Join'), ',')

• Your array is ready now. Run a loop on this array. Inside loop, Use GetItems to query SharePoint List using Filter. Please note that I am filtering on Title. You should filter on your column. Use Current Item property from the current loop. You will find it in the selector.

• Now Add Append to string variable and select email property for the person column from Get Items. Reason you see another Apply to each because it is a collection. But it will only run once so no worries. Make sure to append semi colon after email so that it generates semi colon separated email list.

• After the end of this, your variable will have all emails. Outside all the loops, now use SendEmail action and use variable. 

Hope this helps...

[mithushalk]

Hi @PrasadAthalye 

Thank you for the continuous support.

After following the instructions I was able to build the flow & found this error 
The 'inputs.parameters' of workflow operation 'Send_an_email_(V2)_2' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'emailMessage/To' is required to be of type 'String/email'. The runtime value '".mithushal.kandula@cj.com;;"' to be converted doesn't have the expected format 'string/email'.

[mithushalk]

@PrasadAthalye 

The flow is able to pick only one email address but fails whereas in the form I selected all three options (Finance, Legal, Privacy) as shown in the above picture.

Also in my dynamic list Get Items 4 doesn't appear, I have tries multiple times. 

I even tried at a different level of the flow but Get doesn't appear.

[PrasadAthalye]

There is no Get Items 4. When you add Get Items action multiple times it increments number. Its just Get Items Action only.

Can you check why there is a dot before your name in the variable ? Also Send email should be outside all loops on main canvas...