Setup

SharePoint Online

Content Chooser Admin App

To use the officeatwork 365 Content Chooser with files coming from your SharePoint online, your Office 365 tenant needs to be configured accordingly. This configuration can be done manually or by using the officeatwork 365 «Content Chooser Admin App».

To launch the App just click on the «Content Chooser Admin App» button below:

Content Chooser Admin App

Please note: You need to be a SharePoint administrator AND an Office 365 administrator to run the Content Chooser Setup.

Content Chooser Setup

Automatic configuration

The officeatwork 365 «Content Chooser Admin App» is a Office 365 Web App designed to help you setup and maintain your SharePoint Online configuration for the officeatwork 365 Content Chooser Office Add-in. The Web App will help you create (and maintain) a new SharePoint site collection named «officeatwork» and a subsite named «ContentChooser». Within that subsite it will also create a list named «ContentLibraries» and a picture library named «Contents». The list and the picture library will initially be populated with some sample data.

Follow these steps to perform the configuration for SharePoint online within your Office 365 tenant to start being able to use the Web Office Content Chooser Add-in for Office 365:

  • Sign-in to the officeatwork 365 «Content Chooser Admin App» (This requires SharePoint Admin rights) using your corporate or school Office 365 account.

  • Click on the «Create Repository» Button.

  • After the repository is created return to Word and re-launch the Add-in.

Manual configuration

If you want to setup SharePoint Online without the «Content Chooser Admin App» for Office 365 you can configure SharePoint Online within your Office 365 tenant manually. It is important that the names for the site collection etc. are exactly as provided below. Follow these steps:

  • Create a new Site Collection named «officeatwork»

  • Create the subsite «ContentChooser»

  • Add a new list to this site collection named «ContentLibraries»

  • Add a column of type «Hyperlink or Picture» with the name ‘Url’ to this list

  • Add a column of type «Choice» with the name ‘Applications’ to this list

  • Set the property ‘Type each choice on a separate line’ to
    Word
    Excel
    PowerPoint
    OneNote
    Outlook

  • Set the ‘Display choices using’ to ‘Checkboxes (allow multiple selections)’.

  • Set the ‘Default value’ to ‘Calculated Value’ and enter the following formula in the input box
    =”;#Word;#Excel;#PowerPoint;#OneNote;#Outlook;#”

  • Leave all other properties at default settings.

  • Add entries for each Picture or Document Library which contains contents by copying the URL of the document library into the «Url» field.

  • Give each entry a name by typing a name into the Title field of each entry.

  • Define for each entry in what Office applications the library shall be visible. New entries will be visible in all Office applications by default.

  • ReRe-load the officeatwork 365 Content Chooser Web Office Add-in in your Office application.

Tip: Any document library within your SharePoint Online tenant can be used as a content library. There are no specific requirements other than that those listed libraries must be of type SharePoint document library.

Things that can go wrong…

SharePoint Online is quite complex and therefor things can be configured in a way that will not allow you to see your libraries.

No access to the Libraries List

No access to the Libraries List

When you get this message in the list of libraries it is most likely the case that you do not have access to the SharePoint list that holds the list of all SharePoint Document Libraries that should be shown as available libraries.

  • Click on the link ‘SharePoint Online libraries list’ in the message. This will try to open the SharePoint list using your Browser. If you have no access to the list, you should be seeing the default 'no access' message form SharePoint. Contact your SharePoint administrator to ask for access to that list.