Answered

Specific Item modified, two emails are sent instead of one.

(0) Share

Report

Posted on by belhaddi

Hi all,

I am rather new to Flows and I am just learning things, so your help is appreciated (although not sure if what I am trying to do is at all possible).

Here the situation:

I have a sharepoint list where a "requester" fills in certain fields and upon submission, an email is sent to another team (Team 2) informing them a request has been made. So far so good.

I am now creating another flow, to make sure when team 2 edits requester's entry (by filling out a column - that requester 1 left blank), this should send an email to the request updating him/her.

Now I am using a conditionf for that specific field column and then "apply to each" (maybe this is where I am wrong) to send an email. Only thing here, upon test run, I receive two emails becuase the output "apply to each" contains to emails. How do I get only one email out even though there are two emails in the output "internal signatories"? As you can see, I can only select the "internal signatories" as output, which is driving me crazy.

Any help with a clear step by step approach would be great! - Thank you all for your support.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (2)

Pstork1 68,923 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If you only want one email then you need to create a string variable and use Append to String Variable in the first apply to each to create a semicolon delimited list of user emails that you want the email sent to. That way you won't need the second Apply to each since you will use the variable to address the one email you send.

Was this reply helpful? Yes No
belhaddi on at

Like (0)

Report
Copy link

Link copied!

Thank You Pstork 1.
I made some changes and I removed the second "apply to each" (not sure if it was needed actually).
I am not sure about the value I need to add...I am new at this and my knowledge is very limited.
Can I trouble for your some additional guidance?
Thanks a million

Was this reply helpful? Yes No
Pstork1 68,923 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I don't know for sure, but I assume there are email addresses associated with the Internal signat.. You need to move the append action inside the first loop and append a ';' and the email for each Internal Signat... to the variable. Then use the variable as the TO address for your email later in the flow.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @belhaddi ,

Could you please share more details about the Internal Signatory column? Is it a Person type column and allow multiple selections?

If the Internal Signatory column is a Person type column and allow multiple selections, you could refer to screenshot below to create the flow:

And if the Internal Signatory column isn't a Person type column, you just want to send an email to the Created by email, you could refer to screenshot below to create the flow:
Please let me know if your problem could be solved or share more details so we would better understand your requirement and provide a proper workaround for you.

Best regards,
Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
belhaddi on at

Like (0)

Report
Copy link

Link copied!

Hi @v-alzhan-msft ,

I have added pictures of the full flow. In the meantime I succeeded in only getting one email. Although the "To" was a normal email address, in the body of the email I added the field (blue) of the "Internal Signatories" which is a Person field where multiple selections can be made. So when I add one signatory, I receive the email once with that Internal Signatory's name. If I had two signatories, the email would be sent twice, first referencing the first name of the signatory, second email would be identical but it would reference the second signatory. This is now fixed. I get one email that include both names of the signatories (if multiple) but the formatting is wrong. The names are not seperated by semicolon.

Thank you all for your help.

Regards,
B.
Start
Middle
End

Was this reply helpful? Yes No
Pstork1 68,923 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

When you do the Append to String Variable action where you actually add the signatures to the email you will need to include whatever punctuation you want between the names. It doesn't supply the semicolons automatically.

Was this reply helpful? Yes No
belhaddi on at

Like (0)

Report
Copy link

Link copied!

Hi @Pstork1
but that requires some code no?
If I put a semicolon behind the bleu field that I added as a value in the Append to String Variable; it will also give me the punctuation after the last signatory, whereas the sentence should just stop and end with a ".".

How do I do that? I assume I need to use some Json code in "Value"?

regards,

Was this reply helpful? Yes No
Verified answer

Pstork1 68,923 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
removing the final trailing semicolon can be done when you insert the variable into the body of the email or just before you insert it. to do that use the following fundtion around the variable.

substring(variables('variablename'),0,sub(length(variables('variablename')),1))

This will get the substring within the variable starting with position 0 and stopping one space before the end of the variable, thus cutting off the final ';'

Was this reply helpful? Yes No