Creating A Weather Forecast Feature With Microsoft Flow, SharePoint And MSN Weather

Hello Guys!

Today, we are going to create a solution using Microsoft Flow, Microsoft SharePoint, and MSN Weather to control the weather forecast feature of my company's branches in our intranet and I will show you how can we show this information to the users in a simple way. Let's go!

(The images in this article are in Brazilian Portuguese but I hope you understand).

In SharePoint, I created a custom list to my company's branches with the fields Weather and City (Temperatura and Cidade respectively), that we will use to save the information that our Flow will give us.

Now, open the Microsoft Flow (http://flow.microsoft.com) and go to "My Flows" to create a Flow from the begining.

Microsoft Flow
Let's create a flow that returns and changes daily temperature. Let's use the Schedule trigger.

Microsoft Flow
Microsoft Flow

Now, use the daily recurrence.

Microsoft Flow

Let´s add an action to get our company's branches from the SharePoint list.

Microsoft Flow

Look for the SharePoint Connector.

Microsoft Flow

Look for "Get Items" action.

Microsoft Flow

Select your SharePoint site and list (using our branches list).

Microsoft Flow

Microsoft Flow

Now, we are going to add a repetition action so that in each item, we have an action to recover the weather.

Microsoft Flow

Microsoft Flow

Now, for each item that is found on Get Items action, we are going to execute the MSN Weather action called Get current weather. We could also use the Get forecast for today's action. The basic difference in both is that "the current weather" gets the temperature at the moment and the "get forecast for today" action gets the weather information for the day (like maximum and minimum temperature, humidity, and other information).

Microsoft Flow

The "get current weather" action requires the location for which it should retrieve the weather. We are going to use the City (Cidade in Portuguese) column of our branches list from our item (reminding that we are inside a Get Items repetition in our flow). The field unit is used to choose if we will want the temperature in Celsius (metric) or Fahrenheit (imperial).

Microsoft Flow

Now, we are going to look at SharePoint "Update Item" action to update the column Temperature (Temperatura in portuguese) with the found value at the MSN Weather action.

Microsoft Flow

Remember that we need to put other SharePoint columns that have value at the update moment.

Microsoft Flow

Microsoft Flow

At the column temperature, we are going to put the MSN Weather action Temperature value,

Microsoft Flow

Give a name to your Flow and click on the "Create flow" button.

Microsoft Flow
Microsoft Flow

The Microsoft Flow will work automatically.

Microsoft Flow

Our list has been updated to the current temperature value.

Microsoft Flow

This opens up several possibilities for us to give this information on our intranet without necessarily having to develop a code integration to get the temperature of a city.

I hope it helps you.