Today i tried to make my first flow... I want to make a flow that when a new item is created in my SP list that i receive a email with the new created item(s) I made with the following steps from flow:
When item is created > Get Items > HTML table > Send mail.
It works, but when i create two or more items, i receive 2 or more emails. Is it possible to combine the new created items to one mail? Also in the mail i get the full list, is it possible to receive only the new created items?
Thanks for the help!
Hi @MelvinGRM ,
The trigger will fire for each newly created item.
Instead of Get Items, you can use Get Item By ID and pass in the ID of the triggered item.
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up
Hi, @MelvinGRM , my three options I'd give are:
You could take a look at making a scheduled flow.
That way it can run every so often, and then if there's data, it'll send it through.
The question is how urgent is it that you know that there is data there, and what it is. That will define whether or not you make a schedule or stick with multiple emails.
You *could* make some delays in your current reactive flow, though.
So, instead of immediately sending the update, put a delay of (I dunno) 5m in there, then have it send everything from the past 5m.
This would save running a schedule which could increase your flow action counts.
You might have to then look at concurrency stuff (which I'm not too au-fait with, but) which I would assume if you set it to only allow one instance of the flow to run at once, then it wouldn't run multiples. So that your 5m delay will catch everything in that 5m. Rather than whilst your 5m delay runs, another instance of the flow starts up for new ones! 😅
Alternatively perhaps apply some of that to an "overflow" SharePoint list or something? Maybe, that temporarily collates relevant data?
On Changing the Alerts
Perhaps you could look to stopping emails altogether?
Run the alerts over different channels, like SMS, TEAMS, SLACK, etc.
Then have a SharePoint page (or a few) that show the required data.
This would, then, handily also eliminate the need for any pesky regular reports that people seem so attached to, because you could simply have them look at a bespoke SharePoint page or list view. 🙂
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.