How do I set up SharePoint? 

Microsoft SharePoint is a part of the Microsoft Suite cloud storage solution.

You (as an administrator of both systems) may integrate SpeakUp data with your organization’s SharePoint. In doing so, the system will automatically export SpeakUp data once a day to the specified folder in your SharePoint environment. The data is exported in a single .xlsx file, with multiple tabs.

You can use this automatically updated export file to integrate the SpeakUp data with your own business intelligence tool (for example Power BI dashboard).

Who can do this?

• SpeakUp System administrator

• Microsoft Suite System administrator

1. Notepad

Open Notepad, or any other note taking software. You will use this to keep track of some information.

You can copy this notepad and fill it in as you go: 

Display name:


Site ID:


SharePoint Tenant:


SharePoint Group:


Application (client) ID:


Secret Value:


Directory (tenant) ID:


Export Folder:

2. Create the App Registration (Azure Portal)

1. Go to https://portal.azure.com

2. Navigate to Microsoft Entra ID → App registrations

3. Click + New registration

4. Enter a name (e.g., SpeakUp SharePoint Integration App)

5. Choose:

1. • Supported account types: Accounts in this organizational directory only

   • Redirect URI: leave blank or use http://localhost if needed

   
   

   6. Click Register

3. Add Microsoft Graph Application Permission: Sites.Selected

1. In your app registration, go to API permissions → + Add a permission

2. Select:

   • Microsoft Graph

   • Application permissions

   • Search for and select: Sites.Selected

3. Click Add permissions

4. Back on the API permissions screen, click Grant admin consent for [Tenant]

This gives the app no access to SharePoint until you explicitly assign it to a site.

4. Get the App’s Client ID

1. Go to the app’s Overview

5. Ensure You Are Site Collection Admin on the Target Site

You must be a Site Collection Administrator of the SharePoint site you want the app to access.

Example site:

• Open the site in a browser

• In the top bar, go to ⚙️ → Site permissions → Advanced permission settings

• Make sure your user has Full Control

If not, your SharePoint admin can promote you.

6. Open Microsoft Graph Explorer

1. Go to: Microsoft Graph Explorer

2. Sign in (right top) as the Site Collection Admin from step 5

7. Consent to Graph Explorer Permissions (One-Time Only)

1. In Graph Explorer:

   • Set method to GET

   • Use this URL as base and change the values xxxxxxx with the values you used on point 5 for Sharepoint tenant; and yyyy for sharepoint group):

     https://graph.microsoft.com/v1.0/sites/xxxxxxx.sharepoint.com:/sites/yyyy

2. Click Permissions (Modify permissions)

3. Search for and enable:

   • Sites.FullControl.All (Application or Delegated — Graph Explorer uses delegated)

4. Click Consent (you’ll need to do this with admin privileges)

8. Get the Site ID

1. Run the query

9. Assign the App Access to the Site

1. Set method to POST

2. Use this URL:

1. Replace {site-id} with the full ID from step 8

2. Use this Request body (replace the Application (client) ID and Display name):

{
  "roles": [ "write" ],
  "grantedToIdentities": [
    {
      "application": {
        "id": "put the Application (client) ID here",
        "displayName": "put the Display name here"
      }
    }
  ]
}

3. Click Run query

4. Check if the response was: “ Created - 201”

10. Create Secret Value

1. Go back to the Microsoft Entra ID App

2. Under Manage, find Certificates & secrets

3. Under Client Secrets, click [ + New client secret ]

4. Give it a description and set the expiration.

11. SharePoint folder

1. Decide which folder within your SharePoint site the data exports should be uploaded to; if the folder does not yet exist, make sure to create it now

   • Example: In the site, go to Documents and create a folder named “SpeakUp Exports”.

12. SpeakUp configuration

1. Open SpeakUp

2. Go to the SpeakUp Export - SharePoint Integration page and fill the following information in the textboxes:

   • SharePoint Tenant

   • SharePoint Group

   • Application (Client) ID

   • Secret Value

   • Directory (tenant) ID

   • Export Folder

3. Click save and wait for a confirmation

4. Upon successful integration, an export is created immediately and from then once every day