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. 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. It also reports on the Overground, Ferry, TFL Rail and Tram. The status(es) of the lines can then be clicked if there is any further information i.e. delays/suspension/closure etc.
Update: Have now updated the solution so you can use Azure Logic Apps for the processing rather than Power Automate. Blog here.
I have attempted to simplify/automate the deployment of the solution as much as possible. 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!
Tfl Hit By £100m Fall In Ad Revenue Across Tube, Rail And Bus Network
No need to create the list manually, run any PowerShell to execute any commands apply a PnP Template or Site Design etc.
This solution requires a SharePoint site to be created or an existing SharePoint site can be used. If you are using an existing modern SharePoint site then preceding section below can be skipped.
This Flow deploys the Tube Status SharePoint list (columns, views (CustomFormatter) & navigation links) all from the SharePoint list deployment Flow using REST API.
The Elizabeth Line London Tube Map Is Out, And We're Baffled
Now the Flow has been imported it needs editing to add the url of the site you wish to install the tube status SharePoint list on.
You will now see the View Formatting JSON that styles the list so it looks like a London Underground status board (when the list has data). There is no need to make any changes and instead just click the Cancel button.
The steps below will go through the process of importing and then configuring a Flow which runs on a scheduled basis (currently every 15 mins but this can be adjusted) to connect to the TFL API and write to a SharePoint list.
Having Status Updates On In Train Digital Displays Can Be Very Useful. Here's One In A British Rail Class 345 Bombardier Aventra Electric Multiple Unit (emu) Train, On A Transport For London (tfl)
This Power Automate Flow connects to the TFL API using the endpoint: https://api.tfl.gov.uk/Line/Mode/tube, dlr, overground, tflrail, tram/Status using a HTTP action and the results are given in JSON format which the Flow then parses and sorts to add to the SharePoint list.
This failure is expected and is due to the SharePoint connectors in the template still pointing to a site and list in my M365 test tenant, so we will next edit the flow to point the SharePoint connectors to a site in your tenant.
This Flow will now run every 15 minutes and connect to the TFL API, retrieve the latest Tube Statuses and then update the SharePoint list if there are any changes.
Tube Status Update
We can now see your Tube Status list has been updated and we can see the it has been formatted to look like a TFL status board.
There are also some additional views on the SharePoint list that have been created and are available in the Quick Launch navigation or the View drop down.
I have specifically coded the list view formatting so the special styled view will fit into the Vertical section (special right hand side web part zone) of your modern SharePoint page.
Create A Tube Status Home Screen Widget For Ios 14
I recommend selecting the Hide command bar toggle to hide the list command bar i.e. stop users from changing views. Then you can change the View displayed to show Tubes Only if you are only interested in London Underground lines or leave this as it is to accept the default – All Modes. Once finished click the Apply button.
Well done you have successfully installed the Tube Status solution and it is now available in your SharePoint site. This list has been styled with SharePoint view formatting and this list could be then presented in SharePoint, Microsoft Teams or even Microsoft Lists etc.
This has been a fun little project that I set myself to learn SharePoint view formatting and was also interesting learning about the TFL tube API then parsing the JSON returned from the TFL API using Power Automate.We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent.Cookie SettingsAccept All
These Signs You See Every Day On The Tube Are About To Change
This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
This is purely a convenience, so that the visitor won’t need to re-type all their information again when they want to leave another comment.
Focus Transport: London Underground Nighttime Operation Update
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
First Tube Map Featuring New Elizabeth Line Unveiled
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Analytical cookies are used to understand how visitors interact with the website. These cookies provide information on metrics the number of visitors, bounce rate, traffic source, etc.
