Hello,
I have a PowerAutomate that sends emails when a News is published on a SharePoint site. Easy you'd tell me.
Right. (feel free to ask me about the banner Image URL, because thanks to that forum, I could make it work and send it in an email !)
Here it is :
What is my problem :
Except that the auto-save of the News pages triggers the flow on loop and sends emails for each new letter added to the news article.
What I've tried :
I've seen that you can see the code of the trigger and the following could be a good workaround : Changing the recurrence's intervals, so the Power Automate should check on the new/updated files once per hour, for example. it would allow user to edit the News page and publish it.
The only problem is that this peek code is on read access only.
If I add a delay action (eg 1hr) after the trigger, it will only send emails with the speed of a machinegun.
I want to perform only one action (one time sending email) once the user click on the button "Republish".
Do you have any other idea on how to avoid triggering the flow each time a user enter a letter (or how to disable auto-saving on Pages) please ?
Thanks !
whenever an update trigger fires, start another flow that runs a timer (let's say 5 minutes). If that flow is already running, kill it and restart it.
At the end of that other flow send your email.