Power Automate Alert Flow Optimization
Budget: ₹600 – ₹1,500 INR
Hi, I have an existing Power Automate flow that reads SLA data from Excel and sends alerts to a Teams channel.
Currently, the issue is that breached cases are triggering multiple messages (one per case), which is causing spam in Teams.
I need the flow to be redesigned so that:
- Risk cases (≤4 hours) continue to send individual alerts
- Breached cases are grouped and sent as a single summary message using an HTML table
The flow already includes filtering logic (SLA Status and Alert Sent), so the main requirement is optimizing the alert mechanism and improving performance (avoiding loops for Teams messages).
Additionally, after sending alerts, the flow should update the “Alert Sent” column to avoid duplicates.
Please let me know the best approach and if you can implement this efficiently.
Currently, the issue is that breached cases are triggering multiple messages (one per case), which is causing spam in Teams.
I need the flow to be redesigned so that:
- Risk cases (≤4 hours) continue to send individual alerts
- Breached cases are grouped and sent as a single summary message using an HTML table
The flow already includes filtering logic (SLA Status and Alert Sent), so the main requirement is optimizing the alert mechanism and improving performance (avoiding loops for Teams messages).
Additionally, after sending alerts, the flow should update the “Alert Sent” column to avoid duplicates.
Please let me know the best approach and if you can implement this efficiently.