when sending email to 2 SharePoint groups, getting email triggered for 1 SharePoint group attached flow steps but no error found in the flow steps

[Veblitz]

Issue details Email is getting triggered to HR SharePoint groups but email is not getting triggered for  Leaders SharePoint groups.

Apply to each detailed steps as per above screenshot

[Expiscornovus]

Hi @Veblitz,

If you use the append to string approach and append a semi colon character at the end of every item the last item will also have a closing semi colon character. The email field will expect another email address since there is another semi colon character. However, that email address is empty/null.

Can you double check if that is the case in your setup?

In your case it probably is

john@contoso.com;jane@contoso.com;

While it should be:

john@contoso.com;jane@contoso.com

[Veblitz]

Thanks for quick inputs.

Yes I checked the flow and in apply to each step its output is

user@abc.com ;  

May I know how to fix the issue to the existing flow of my steps?

Thanks in advance.

[Expiscornovus]

Hi @Veblitz,

Yes, sure. Below is an example with a Select action and a join function.

1. Add a Select action. Use the results property from your Parse Json in the From field.

2. Switch the Map field of the Select action to text mode (with button on the right side). Select the Email field

3. Use a Set variable action. Use the expression below to join the items of the Select action outputs together with a semi colon character

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

[Veblitz]

Many Thanks.

I added the above steps but i am not sure if i got to remove my another  apply to each 2 where i appended previously(pls refer above threads of step by step flow)

SO, now my flow steps looks as below where i have one apply to each section and added your inputs and refer below

Note: I removed my existing apply to each 2 step where I appended right

Expected output:

Leader sharepoint group 

user1@abc.com

user2@abc.com

HR SharePoint group

user1@abc.com

After adding above apply 2 each steps user1,user2 received one email(i.e. Leader SharePoint group folks) email got triggered but user1@abc.com  who is also part of HR SharePoint group should receive one more email right if my point is correct or please correct me if anything wrong with my logic

[Expiscornovus]

Hi @Veblitz,

Yes, sorry. I was only looking at the Leaders SP Group part. 

Below setup loops through the output of the Select. For each item it append the value (mail address) to the curremail Array variable.

Outside of all the loops you can join the values together with a semi colon character. The expression would be:

join(variables('curremail'), ';')

If you want to use unique emails you could use this expression instead:

join(union(variables('curremail'),variables('curremail')), ';')

[Veblitz]

Thank you for your kind inputs.

I validated the same and facing below list of errors ,below are my flow steps

Overall flow steps

Step by step flow steps

Apply to each (1st loop)

Choosing below values in select step

Above steps is Apply to each2 loop inside apply to each loop step

Issues in apply 2 each loop

And i am facing below issues in apply to each 2 loop on below contexts

1)While appending to array variable I am unable to see the curremail value and it is only listing group values

Note: I am unable to see the curremail when trying to choose from the list and its not listed and only groups variable is getting displayed.

2)While adding below expression in set variable2, Outside of all the loops by using  join the values together with a semi colon character. getting below error

join(variables('curremail'), ';')

Thanks in advance for all your kind suggestions.

[Expiscornovus · Accepted solution]

Hi @Veblitz,

Just to double check. Did use Array as type for the curremail variable?

In my case it is an array, not string.

[Veblitz]

Thanks for inputs and in my case it was string that's why it caused so much errors also I would test the same and keep you posted once its fine.

Apart from the above ,Finally ,I would need to only add the below step in apply to each 2 and to apply your  union expression and pass output value to email.

Apply to each loop(first)

Apply to each loop 2

Compose expressions :

Please correct the above flow incase if there are any thing wrong in above steps also I would test from my end and keep you informed if it worked as expected.

[Veblitz]

Thanks a lot for your Kind and valuable suggestions .

Marked it as solution and brilliant solution