question

CaseyLovell-4335 avatar image
0 Votes"
CaseyLovell-4335 asked YiLu-MSFT commented

Limit the number of emails generated for modified items

Im wondering if its possible to limit the number of alerts generated by a Flow.

In my case, my business partner wants to be able to generate an alert whenever a news article we're working on transitions from a Status Column tag of "Pending" to "Final," so I currently have a flow configured to alert when items in the Status Column are modified, it'll generate an email... the issue is that the business partner only wants that notification once... instead, they're receiving an email anytime the item is modified afterwards.

Is there a way to add an action that checks to see if a notification has already been sent, or a limit, etc?

Thanks

office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

YiLu-MSFT avatar image
0 Votes"
YiLu-MSFT answered YiLu-MSFT commented

Hi @CaseyLovell-4335
As far as I know, there is no such way to check if a notification email has already been sent or limit the notifications.

As a workaround, you could add a judgment condition to verify if the notification has been sent before:

1.First add a Yes/No column “Sent email” in your list ,set the default value as “No”

123819-image.png


2.Add a condition with two rows in your flow as following:

123888-image.png


3.If yes, we need to add two action: Send an email notification and Update item as following:

123932-image.png


4.Finally save the flow and test it.

When you modify the status from “pending” to “final” and Sent email column is No, email notification will be sent and “Sent email”column will be changed to yes automatically.

In this way, your business partner will only receive the alert one time.


If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



image.png (12.9 KiB)
image.png (21.6 KiB)
image.png (33.1 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @CaseyLovell-4335
Would you please provide some update of this issue? I am free to listen to you.

0 Votes 0 ·

Hi @CaseyLovell-4335
I am checking to see whether this issue has been resolved. If you have any doubt about this flow, don't hesitate to tell me.

0 Votes 0 ·