Send one email when multiple items in sharepoint list are updated

(0) Share

Report

Posted on by RobertJames

I have a sharepoint list like below:

I have a flow like below:

I want to send one email when the Priority of multiple items in the Sharepoint list changes to "Critical".

The current flow is sending one email per item. However I want to send one email only when multiple items

Priority is changed to "Critical"

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report

@RobertJames ,

The moment one an item is created / modified is unique and it is the source of the trigger When an item is created or modified, even if for us seems that items creation/modification is on the same time. There is no trigger to be executed when multiple items are created/modified, because there is no unique event that can be identified.

So, maybe somehow you can catch the moment when the bulk item updates is executed.

How you update the “Priority” column ?

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @RobertJames ,

Are there any other conditions to designate the multiple items you mentioned above? You have trigger for one item is modified, but how many other items with Priority equal to Critical?

I think you need a flow where get all items that Priority equal to Critical at a specific time EVERYDAY, and then send them all to some recipient within a single email. Does this make sense?

Best regards,

Was this reply helpful? Yes No
RobertJames 49 on at

Like (0)

Report

Say there are total 10 tickets and 5 of them are already marked as Critical. So a user may either select 3 tickets together whose Priority is Normal and change it to Critical or one by one mark them as Critical. However I want one email containing all the 3 three tickets whose priority was marked as Critical. Email should not have the tickets which were already marked as Critical.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @RobertJames ,

OK, I understood. But as workflows Power Automate can only notice what has done, those what'are about to do cannot "be speculated". So, one item gets changed, one flow being triggered because of the trigger and get details of THIS item return from trigger. There is no logical relationship of necessity in your requirement. As the result, I'm afraid there is no way to achieve that need.

Best regards,

Was this reply helpful? Yes No
RobertJames 49 on at

Like (0)

Report

I do a bulk update of the Priority column.

Was this reply helpful? Yes No
RobertJames 49 on at

Like (0)

Report

Is there any other way to achieve this?

Was this reply helpful? Yes No