Disclaimer
This feature demonstrates a social media aggregator made via Power Automate. It depends on the social media API, and Powell does not support the integrity of these APIs.
Powell proposes a model that does not guarantee this functionality's support or integrity.

Social Wall

We created a Social Wall that aggregates social network data through a Sharepoint list via a Power Automate feed linked to Facebook, Instagram, Twitter, and Youtube API. This list is then displayed with a Powell Graph Web part. 

Link to the Powell Social Wall

Prerequisite

You will need to meet specific prerequisites for each social network to leverage their API. 

Facebook

Official documentation : Création d’une application - Développement d’applications (facebook.com)

• Application Facebook type company with admin rights on the company page.
• Product ‘Facebook login.’
• Permissions and features : public_profile & pages_read_user_content.
• Valid OAuth redirect URIs: https://global.consent.azure-apim.net/redirect
• Create a token: https://developers.facebook.com/docs/facebook-login/guides/access-tokens#apptokens

YouTube

Official documentation : https://developers.google.com/youtube/v3/

• Create credentials : https://console.cloud.google.com/apis/credentials
• Get channel id

Instagram

Official documentation : https://developers.facebook.com/docs/instagram-api

• Application Facebook type other.
• Product ‘Instagram Basic Display.’
• Valid OAuth redirect URIs : https://global.consent.azure-apim.net/redirect
• Add account to the testers

• Validate the application in the Instagram settings :

• Get a long-lived access token : https://developers.facebook.com/docs/instagram-basic-display-api/guides/long-lived-access-tokens#get-a-long-lived-token

Power Automate

Now that you have fulfilled all the prerequisites to leverage social network data, you need to create a Power Automate flow to gather all the data and feed it into a SharePoint list via the Powell connector. 

Here is a global view of the Flow; you can download the related zip here :
https://cdnassets.powell-software.com/manager/assets/Agregated.zip

( Note that this is the Flow as we created it when creating this documentation. It is only an example, and Powell does not ensure its integrity. )

Explanation of the different scopes :

Scope Facebook

• Set the property Facebook

• Retrieve the ids of the posts following the id of the Facebook page.
• Loop over the different posts to make a query to get more info about the post.
• Add the posts to a table.

Scope Instagram

• Set the property Instagram Token

• Retrieve account information (id, name).
• Retrieve the ids of the posts from the Instagram account.
• Loop over the different posts to make a query to get more info from the post.
• Add the posts to a table.

Scope Twitter

• Set the twitter user 

• Connector Twitter.
• Loop over the different Twitter posts to get the information
• Add the posts to a table

Scope Youtube

• Set the property Youtube ChannelId & Token

• Retrieve Youtube videos.
• Loop over the different videos to get the information
• Add the posts to a table.

Scope SharePoint

• Set the value Site url & List Name

• Loop over the different social network posts to add them to the SharePoint list.

Dedicated SharePoint list

You need to create a dedicated SharePoint list to gather all the data from power Automate and aggregate it. 

Here is an example of the list we created

If you want to re-use the same list we created, the model is available as a list template : Aggregated Social Networks Feeds.

Set Graph web part

List Configuration

Once your list is created and linked to your Flow, you can add a Graph web part to your page.

Add the list you created earlier to aggregate all social content in the list configuration. ( In the example above, we named the list "Aggregate Social Networks Feeds" )

Display

Choose a display template, and select the display template of your choice. ( News list and news tiles, for example) 

If you want to have the same view as the one we created, create a custom view in the manager ( Widget view section ) for the Search Web part, and add the following code to this page : 
https://powprodeuwgenstg.blob.core.windows.net/cdn/documentation/social-wall.txt

This is the HTML structure we created for the custom view of the social wall.

Mapping

Here is an example of the mapping we used on the Search Web part

imageURL : imageUrl

URL: media URL

platform : networked

description : content38571

public URL: media URL

Date : created time

author  : Appauthor