Admin Password Change from the default to secure your panel
Ticket Series Start Number Current next ticket ID. Increase to skip ahead.
OneDrive Excel — Backup / Export Only
ℹ SQL Server is the single live source of truth for all tickets. OneDrive Excel is a manual backup — use the "Sync to Excel" / "Load All Tickets" buttons below on demand. Tickets no longer auto-save to Excel.
Power Automate — New Ticket Flow URL Triggered when any new ticket is submitted
Power Automate — Updated Flow URL Triggered when admin saves changes to a ticket
Power Automate — Resolved Flow URL Triggered when ticket is marked resolved
Power Automate — Closed Flow URL Triggered when ticket is confirmed closed
Power Automate — Reminder Flow URL Called daily to send due-date reminders
📘 OneDrive Excel Setup Guide
Step 1 — Create Excel file on OneDrive
Go to onedrive.live.com → New → Excel workbook → rename it BlendERP_Tickets.
Add headers in Row 1: TicketID, Subject, Category, SubCategory, Priority, Status, RaisedBy, Mobile, RequesterEmail, AssignedTo, AssigneeEmail, TargetDate, RaisedOn, ClosedOn, Description, Source, Attachments.
Select row 1 → Insert → Table → tick "My table has headers" → rename table to TicketsTable.
Step 2 — Import legacy tickets
In the admin panel click Export Excel → download file → copy all data rows → paste into OneDrive Excel from row 2.
Step 3 — Create Power Automate Flows (one per event above)
In Power Automate → New flow → Instant cloud flow → When an HTTP request is received.
Add action: Excel Online (Business) → Add a row into a table → select BlendERP_Tickets.xlsx → TicketsTable → map each column to the matching JSON field.
Also add: Send an email (V2) to RequesterEmail, and Teams → Post a message to AssigneeEmail.
Copy the HTTP POST URL and paste it in the fields above. Repeat for all 4 event flows.
Step 4 — Reminder Flow
Create a Scheduled cloud flow → every day at 8 AM.
Action: Excel Online → List rows from TicketsTable (filter: Status ne 'Closed').
Loop each row → Condition: TargetDate equals addDays(utcNow(),1,'yyyy-MM-dd').
If yes: Post Teams message + Send email to AssigneeEmail: "⏰ Ticket #TicketID due TOMORROW."
Step 5 — GitHub Pages Deployment
Rename this file to index.html → push to GitHub repo → Settings → Pages → Source: main/root.
Your URL: https://YOUR-ORG.github.io/blend-erp-support/
Add as Teams tab: Channel → ＋ → Website → paste URL.
Security Note: The HTML file on GitHub contains no ticket data. All data lives in your OneDrive Excel (private Microsoft 365 account). The admin password protects the admin panel. Change it from admin123 before going live.
🔒 Confirm Ticket Closure
✏ Editing Ticket
BLEND
📎 Add more attachments
💬 Comments
📱 Mobile & cross-device tickets
Every ticket raised from any device is sent to Teams ERP Tickets channel instantly via Power Automate.
To see mobile tickets here in admin: configure Power Automate to write to Excel, then click 📥 Load All Tickets.
