If you need to create a new SharePoint connection, select Create new in the Import setup pane.Create a new modern SharePoint site from either the SharePoint admin centre ( ) or from SharePoint home.If you are using an existing modern SharePoint site then preceding section below can be skipped. This solution requires a SharePoint site to be created or an existing SharePoint site can be used. You must have a modern SharePoint site where you can store the data for the app.Ĭreate Tube Status Site and/or Tube Status List.You must have a valid SharePoint Online license and permission to create lists.You must be licenced and able to create Power Automate flows.1 x Flow – This Flow will then run frequently on schedule and connects to the TFL Status web API and retrieves the status of each line, then writes the data to the SharePoint list if there are any changes.1 x Flow – Run one time to deploy the SharePoint list (creates columns, views, applies view formatting JSON and quick launch navigation links) to save you needing to create all of this manually.No need to create the list manually, run any PowerShell to execute any commands apply a PnP Template or Site Design etc. I have combined this into two flow templates which with a few very minor changes do all the work for you to deploy and configure this solution! I have attempted to simplify/automate the deployment of the solution as much as possible. Power Automate (used for creating the Tube Status SharePoint list using SharePoint REST API and then on a scheduled basis retrieve the latest TFL tube statuses).View Formatting (JSON used to style the list view into the familiar TFL Status board).List (used to store the latest TFL line status data).Update: Have now updated the solution so you can use Azure Logic Apps for the processing rather than Power Automate. Why not follow this blog post and place this on your SharePoint Intranet today? The status(es) of the lines can then be clicked if there is any further information i.e. It also reports on the Overground, Ferry, TFL Rail and Tram. The results are retrieved by Power Automate (Flow), then written to a SharePoint list and using SharePoint view formatting the list view is styled so it looks like a familiar TFL tube status board with correct line colours. Display on the homepage of your SharePoint intranet a live feed of London Underground line statuses using the publicly available Transport for London (TFL) API.

Tfl license checker