Introduction

This guide will show you how to integrate an Excel file stored in Microsoft SharePoint into Q-Play, so you can pull data directly from the Excel file into your presentation and display it on a screen.

1. Setting up the SharePoint Docs Integration

2. Using the integration in the DesignTool
   

Part 1: Setting up the SharePoint Docs Integration

1. Go to Integrations

• In the left-hand menu of Q-Play, click on “Integrations”.
  

2. Create a new integration

• Click the “New Integration” button in the top right corner.
  

3. Select SharePoint Docs

• From the list of available integrations, select “Sharepoint Docs”.
  

4. Name your integration and save it.

• Enter a descriptive name for the integration so you can easily identify it later.
  

• Save it before doing anything else!
  

5. Choose your authentication method

Choose whether you want to use Microsoft OAuth (Login with Microsoft), or use your own custom App Registration.

Make sure to save the integration after authenticating.

6. Add the scripts

Now it's time to add the required scripts for your integration. One script is required per document, but multiple documents (even of the same type) can be fetched using the same integration.

To add a script, press the "+" under Scheduled Scripts.

Choose the script type you want and give it a name, like this:

7. Get your SharePoint Share-URL

Log into your company's SharePoint site. Once you're in - navigate to the desired file and click the "Share" button

Then, choose the "Copy Link" option

Insert the URL in the "Presentation Share URL" field and save your script.

8. Verify that the integration works

Next step is to go to the "Integration status" tab and hit "Run" on your newly created script. It might take a minute or two, but it should result in a checkmark to the left of the script name if everything has run successfully.

9.  Troubleshoot if needed

• If the test shows an error:
  

  • Click the document icon (marked in red).
    

Use “Script Logs” to view details of what happened or where an error occurred. Attach a screenshot of this log and contact NordicScreen Support at support@nordicscreen.com

---

Part 2: Using SharePoint Do in the DesignTool

1. Insert the app in your presentation

Open the desired Playlist or Presentation in the DesignTool and find the SharePoint Docs app in the right-hand menu. Add it to your slide by clicking, or dragging it in.

---

2. Connect the app to your script

Choose the desired script under "Data sources" in the app settings. Remember to choose the appropriate Template for the kind of file you want (PowerPoint, Word, Excel).

---