Let’s dive deeper into Microsoft SharePoint and its connectivity with PowerPoint. SharePoint is a browser-based collaboration and document management platform. At this moment, you can’t use PowerPoint and display SharePoint information in real-time on your slides, unless you use our DataPoint add-on for PowerPoint.

DataPoint allows you to connect to any SharePoint site or subsite and display entries of a list of your choice. A SharePoint list is basically an information container, similar to a simple database or spreadsheet. A list is the most common way to manage information in a SharePoint site. Each list item is seen as a row and each row has multiple columns or properties or fields.

sharepoint lists

Let’s add a new list to our SharePoint collection. Add a new list of the type Announcements. For example, let’s name our list Lobby Display.

create a new announcement list in sharepoint

Add a few announcements to this list. Before we start displaying the announcements in real-time on a television or computer screen, run the PowerPoint slide show.

announcement list content on sharepoint

Open PowerPoint and start with a new presentation. Open the DataPoint menu and click the List button of the Connections group.

datapoint menu in powerpoint

Set up a new connection in DataPoint. Select the Microsoft SharePoint node and click the Add Connection button.

datapoint add sharepoint connection

Enter the URL of your SharePoint server and set your username and password. Click the Test button to test the parameters. When everything is connecting without a problem, then click the OK button to close.

sharepoint connection properties

We have set up a connection to our SharePoint server. Next step, is to identify the SharePoint list that we want to display on our information screen(s). With this SharePoint connection selected, click the Add query button.

select sharepoint list

Select any SharePoint list available from the list. Verify and change the data refresh rate. This express how often you want to check the new information. Hit the OK button to confirm.

choose a sharepoint list

Click the Advanced button here and then check the option Remove HTML tags from the texts. Native PowerPoint cannot display HTML information because it is for a web browser.  As a result of this, HTML, formatting in Powerpoint was removed from the text field and the real text remains.

advanced options, remove html formatting

See the content of the chosen list here at the preview. If needed, you can rename the default query name into a meaningful name.

preview sharepoint list content

Start with a new PowerPoint presentation.

start with a new presentation

Select a text box and click the Text box option of the DataPoint menu.

datapoint textbox linking

Leave the data connection to this default value, since we only have one data connection set up in this presentation. Next, select the column named Body from the list of columns. The body contains the texts that we want to display. Leave the row at 1 for the first entry.

assign sharepoint list body to textbox here

The dynamic content of the SharePoint body field is now copied into this text box.

textbox dynamically linked to sharepoint list body

We have more than just one item to show of our SharePoint list. We can add another text box to host the body content of row 2, or there is a better way for a variable number of information records. Click the Scrolling button of the Slide group.

data scrolling on multiple list entries

Check the Enabled option to scroll thru the SharePoint items, one item every 5 seconds here. Click OK to close.

activate data scrolling

We want to run this slide show continuously on our television screen in the lobby. Click the Set Up Slide Show button of the Slide Show menu.

set up powerpoint slideshow as information screen

Set the Show type to Browsed at a kiosk (full screen) for a never ending slide show. Click OK to confirm.

run slide show as kiosk presentation

Start the slide show. PowerPoint and DataPoint will display all list entries of our chosen SharePoint list. We can now use another computer or smartphone to add or change the SharePoint content. DataPoint will detect changes and display the updated information on this screen; from remote and without stopping the running slide show.

running slideshow with real-time sharepoint information

Try DataPoint to Connect to Your SharePoint

Pin It on Pinterest

Share This