Required stack
필요 기술
Power AutomateMicrosoft TeamsExcelHTMLData ProcessingAutomationPerformance TuningData Integration
Project brief
프로젝트 내용
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.