Home · Business tools · Put a live job board on the workshop TV from an Excel file in SharePoint
Recipe 10 min
Put a live job board on the workshop TV from an Excel file in SharePoint
Everyone asks 'what's on today?'. Keep the job list in one Excel file in SharePoint and show it on the TV in Power BI, refreshing from the file.
The prompt · ChatGPT
Design a job board for our workshop TV. If my data from this tool is available to you in this chat through a connected app, use it and tell me which records you used; if not, work only from the export or text I've pasted below. Our jobs: [e.g. job number, customer, what, due date, assigned to, status] What the team needs to see: [e.g. due today, late, waiting for parts, done this week] Who updates the list: [e.g. office manager, each fitter on their phone] Ask me up to 3 short questions first if anything important is missing. Wait for my answers. Then: 1. An Excel table layout with column names and allowed status values. 2. Formulas for Late, Due today and Days to due. 3. DAX measures for the board tiles. 4. A board layout: up to six tiles, readable from 3 metres, with colours for late and due today. 5. A 'data as of' tile. The board is only as fresh as the last export or refresh, so show the 'data as of' date and time on the board. A Power BI TV account needs Pro or PPU (or the report on Premium / Fabric F64+ capacity) to view shared content. Only use what I've told you, leave blanks for anything I haven't given, and don't invent facts or figures. UK English. Stay in this ChatGPT chat. Do not turn on apps or connectors, and do not use memory from another chat.
What you get (sample answer)
Excel columns: JobNo | Customer | What | DueDate | AssignedTo | Status (Queued/In progress/Waiting parts/Done). Formulas: Late = DueDate<TODAY() and Status<>Done; DueToday = DueDate=TODAY(). Tiles: Due today | Late | Waiting parts | Done this week | Jobs by person | Data as of. Colours: late = red, due today = amber. TV account needs Pro or PPU (or capacity).
Loading the outline…