Unanswered

Receive a single email when no changes from an apply to each runs

(0) Share

Report

Posted on by Earl20

105

I have a SharePoint list and a scheduled flow that every day checks to see if any of the people listed in the list have a department or manager change. Currently, if there is a change I get an email saying "joe smith manager changed". If there are NO changes detected nothing happens. I want to make it that if there were no changes detected, then I would receive a single email saying "no changes detected". I tried doing it, but am receiving an email for every name on the list (238 people listed). Can anyone guide me on how I can add this.

I wrote out my flow be

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Pstork1 68,678 Most Valuable Professional on at

Like (1)

Report

Re: Receive a single email when no changes from an apply to each runs

Are you sending an email for each change that was made? Or collecting the changes into an array and sending a single email with all the changes using the array after exiting the loop? If its the later then you can use a condition after the loop exits to check the length of the array containing the changes. If the length is 0, ie. no changes, then send the email with "No Changes Detected". If you are sending an email for each change then initialize a variable before the loop and increment it each time you send an email. If its 0 when the loop exits then send the email with "no changes".

Was this reply helpful? Yes No
Earl20 105 on at

Like (0)

Report

Re: Receive a single email when no changes from an apply to each runs

An email goes out for each change. I will try the initialize variable. I have never used the increment variable feature so I will play around with it.

Was this reply helpful? Yes No