INTL
Freelancer
보통
외주
원격 가능
Power Automate Alert Flow Optimization
예산
$600~$1,500 INR
예상 기간
1~2주
난이도
보통
기술 스택
Power Automate
Microsoft Teams
Excel
HTML
Data Processing
Automation
Performance Tuning
Data Integration
AI 분석 요약
기존 Power Automate 플로우를 최적화하여 엑셀 SLA 데이터를 읽고 Teams에 알림을 보냅니다. 주요 목표는 과도한 '위반' 알림을 HTML 테이블을 사용한 단일 요약 메시지로 그룹화하고, '위험' 알림은 개별적으로 유지하며, 알림 전송 후 'Alert Sent' 열을 업데이트하여 중복을 방지하는 것입니다. Power Automate, 엑셀 데이터 처리, Teams 연동 및 성능 최적화 역량이 요구됩니다.
프로젝트 원문 설명
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.
Freelancer에서 원본 확인
원본 보기