Answered

Expiry notification sends multiple time

(0) Share

Report

Posted on by rinu007

i have a document library with field "ExpiryDate" and "StakeHolders" (People and groups with multiple selection enabled ) i want to sent emails notification if the expiry date is equal to 90 days to the stake holders field associated with the record.

i have managed that but multiple emails have been sent by the system. How do i consolidate it into one?

Please see the flow below.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Pstork1 68,923 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It looks like the flow is sending one email per item. If you have the same stakeholders for two documents then they will get two emails. Are you saying that stakeholders are getting multiple emails for the same document or multiple emails for different documents? To send out a single email with multiple documents in it you would have to figure out a way to parse the list multiple times and send one email for each matching set of stakeholders. That is going to be very difficult to do.

An easier approach might be to start with a loop that builds an array of all the stakeholders. Then a second loop that processes all the documents again one stakeholder at a time and sends an email for all the documents for that stakeholder.

Was this reply helpful? Yes No
rinu007 on at

Like (0)

Report
Copy link

Link copied!

Thanks Pstork,
"An easier approach might be to start with a loop that builds an array of all the stakeholders. Then a second loop that processes all the documents again one stakeholder at a time and sends an email for all the documents for that stakeholder."

I am pretty new to this Can you show me an example?

Was this reply helpful? Yes No
rinu007 on at

Like (0)

Report
Copy link

Link copied!

hi It is sending multiple emails for different documents

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @rinu007 ,

If you want the flow to only send one email, you could move the send an email action outside the Apply to each.

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