Build the ultimate Issue Tracker using Lists and Power Automate
summary
Uses the Microsoft Lists Issue Tracker template plus Power Automate to add concrete features: a scheduled flow imports Excel rows into Lists, including the 1899-12-30 date conversion to fix Excel dates; a daily scheduled flow recalculates a new Days Old only for statuses New/In Progress/Blocked; an automated flow creates a SharePoint folder per new item and writes its URL back via Send an HTTP request to SharePoint; a Teams message flow sends reminders 14 days before due as Flowbot; an instant button flow copies items to an archive list and deletes the source.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 0:39Setting up the issue tracker
- 3:31Importing data
- 5:17Automating data import
- 10:40Updating list features
- 15:25Automating logic
- 21:42Folder automation
- 30:26Adding reminders
- 36:45Archiving list items
- 44:28Conclusion
related talks
40mStreamline and Automate Low Code Solutions for Process Improvement Using Power
20mHow to reduce costs & build new analytics capabilities in Power BI with Power Automate
52mPower Up with the Power Platform
57mEngineering for Low Code Solutions
16mDiscovering the world of Low-Code with Microsoft PowerApps
46mPower Platform DIY
11mCreate a fully functional support bot in less than 10 minutes
39mUnblocking Backlog Jams