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. 🙂
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.