+4Hi everyone
I am looking to send one e-mail based on when multiple items in a Sharepoint Online list are updated. ie I don’t want an e-mail for every item, just one e-mail saying that these items have been updated.
What is the logic to achieve this?
Regards
Kirk
Best answer by kate
Hey
Thanks for sharing the context! It sounds like Scheduled workflow is still your best bet.
If it’s a monthly activity where items are being updated, then you should set a Scheduled workflow to run monthly (or any other frequency that better suits your process). Add a Query action to fetch all items that are considered ‘incomplete’ - This should pull everything that was added in the current month, but also look into the history for any items that are still outstanding. If there are no items, end workflow.
Otherwise, unfortunately there is no way to group or batch Sharepoint events in the way you’re hoping for.
Let us know if you have any further questions!
Kate
Hi Kirk,
Can provide more details around your scenario? This may help the community to find more suitable solutions.
For now, the best option I can think of is to run a Scheduled workflow that queries all items modified since the last scheduled run.
Regards,
Kate Huynh
+4Thanks
The scenario is that a bunch of new items is uploaded to a Sharepoint Online list every month. Then during the month these items are worked on and completed usually. Perhaps there is still a few left that are not completed by the next month. The next month, a bunch of new items is loaded again.
I need to notify the people working on these items that the new bunch of items has been added. They do not need to see 30 new notifications for 30 new items loaded, just a single notification for the new bunch of items where they can then go to the list themselves and look at the items.
I hope this helps!
Hey
Thanks for sharing the context! It sounds like Scheduled workflow is still your best bet.
If it’s a monthly activity where items are being updated, then you should set a Scheduled workflow to run monthly (or any other frequency that better suits your process). Add a Query action to fetch all items that are considered ‘incomplete’ - This should pull everything that was added in the current month, but also look into the history for any items that are still outstanding. If there are no items, end workflow.
Otherwise, unfortunately there is no way to group or batch Sharepoint events in the way you’re hoping for.
Let us know if you have any further questions!
Kate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
