All about Power Platform

In this blog, I will describe on how to use power automate to extract tweet details from Twitter page.

To start with,

• Login to https://make.powerapps.com.
• Navigate to Flows and create an automated cloud flow.
• Let us use the trigger When a Tweet is posted.
• Click on Add Connection and set the Twitter Account details which needs to tracked.
• In the Search Text, enter the search terms – #Searchtext or “search text” or from: @username.
• Power Automate will only trigger when the search criteria is met.

Initialize an array variable to get the User Details Array information from the Tweet.

• Call the trigger – Get User
• Insert user name parameter from previous step ( ‘when a new tweet is posted’)

• Now pass information to user details array we initialized. For this we will use the action – Append to Array,

• Test the results by passing it to a html table,
• Lets use the create html table action and pass the array we set in the previous step with user details.
• You can either choose the columns to be ‘Automatic’ or give custom values,

If custom value is choosen , each column name need to be created and value needs to be assigned as below,

@{variables(‘arrayname’)?[0]?[‘FieldName’]}

In our case to get full name – @{variables(‘userdetailsarray’)?[0]?[‘FullName’]}

• Save the Flow. Now create a Tweet from associated Twitter account with the search input matching the search term specified in flow.
• The UserDetails Array holds the following information,

The html table would appear like below,

• Please Note : Incase location is coming as blank – make sure in Twitter User profile the location and location settings are set properly,

Complete steps for flow is as below,

• Login to https://make.powerapps.com
• Choose the environment.
• click on Flows.
• Choose the Instant Cloud Flow -> create a name and choose the PowerApps (V2) Trigger.
• Add a Step and choose PowerApps as admin ->Get Apps as Admin

• To know the Environment ID in Environment Name field ,
• Click on Settings ->Session details->PowerApp Session Details ->Copy the value against Environment ID.

• Add a new Action below Get Apps as Admin step -> List rows present in table.
• Choose the Location. In my case I have kept the excel file in SharePoint.
• Choose the Document Library, File and table name from excel file from where we need to read the data.

• We need to loop through the list data output and create records in Data verse.
• For this , choose the loop control Apply to Each.
• Select the Output from previous step with ‘value’ returned from the List above.

• Choose the Microsoft Data verse ->Add a new Row action.
• Select the entity . In my case I am reading data from excel to create records in contact entity.

• Map the mandatory attributes from value set to columns .
• Save the Flow.
• Apply the flow check and test the flow.

The Flow is complete and ready to use.

Reference to SharePoint list used in the flow,