From the course: Microsoft Power Automate Essential Training

Capture tweets in a SharePoint list

- [Instructor] How do we create a flow from a template? Well, that's what we're going to do in this movie. We are going to create a flow that will capture tweets in Twitter and list them in a SharePoint list for us. Let's go to our Templates page. Now, we see a lot of templates in here. There are literally hundreds and hundreds of templates. We want to find one that has to do with Twitter. So let's try and narrow this down. Up at the top, you see different categories. And if we come all the way over to the right, you see these three ellipses. If we click there, we get our list of categories and almost down to the bottom, we see Social media. So we're going to click there. And now we see only templates that have to do with social media flows. And we see a couple for Twitter. We see a few here, but there are other social media connectors as well. If we don't want to scroll through here and scour this looking for what we want, we're going to narrow our field a little bit more by clicking up here in the search box, where it says Search templates, and we're going to type in Twitter, hit Enter. Now it's only showing us templates that have to do with Twitter. And the one I want is actually right here. Save tweets that include a specific hashtag to a SharePoint list. All right, we're going to click on that to bring up our template. You're going to see how nice templates are. They're really great if you're just getting started with Power Automate. We have the template. We see Twitter and SharePoint connectors. And when we scroll down, we see that this flow will connect to and it shows us our accounts. Cecilia@landonhotel.com, that's our Microsoft Office 365 account and LandonCecilia, that is the Landon Hotel Twitter account and Cecilia is the person who has the permissions, the login for it. Now, if we had not already added this connection to Power Automate, we would've seen something that looked a little bit more like this And we would need to sign into Twitter and give Power Automate permission to access that account. But we already have it here, so we're going to click on Continue. And it takes us to our Power Automate page, our flow page here, and the flow is pretty much done. All we have to do is add in some more information, like what do we want this flow to search for? And we know exactly what we want it to look for. #landonhotel. Okay, that's what it's looking for. Now, where are we going to put it? Where is the SharePoint site? Well, I've already got the SharePoint site in mind. I'm going to click on that little dropdown and it's going to go to the marketing team site and it looks for the list name. Now I've already created a SharePoint list to house these tweets, and it is called Twitter Captures. And when I select that, it brings up two fields here, title and tweet text. Now, before we go any further, I'm going to show you this SharePoint list. We're going to come here to SharePoint to our marketing team site. And we see this SharePoint list and we see there are two columns, Title and Tweet Text. I created this SharePoint list and these are the columns that I've added. Obviously SharePoint lists by default have a Title column, and I added the column for Tweet Text. And that is what Power Automate is seeing. And it even went ahead and put dynamic content in that Title field. You'll see the red star next to Title that lets me know this is a required field. Now I don't want Tweet Text in the Title. Obviously I want Tweet Text in the Tweet Text column. So I'm going to delete that and you'll see it pulls up my dynamic content. And what I want is Tweeted by. I'm going to select that to put in the Title column. Then in Tweet Text, I'm going to add the dynamic content for Tweet Text. And if I show advanced options, it just gives us this option to limit columns by view. I'm not going to worry about that. And we're going to save our flow and you'll see now at the top, your flow is ready to go, we recommend you test it. But we're not going to test it here because a flow like this is constantly running. What we need to do now is wait for a tweet to come in with the hashtag landonhotel. And I'm going to tell you Landon Hotel isn't a real organization and we're not going to see a lot of tweets for it. I'm going to have to go and tweet from my Twitter account, but it could take time. I've had this where it's taken an hour to find the tweet. I've had it where it's taken just a couple of minutes. So I'm going to go offline, tweet and in our next movie, we'll see what happens. But now you know how to use a template to create a flow that will capture tweets from Twitter and list them in a SharePoint list.

Contents