You can use the SharePoint Online List macro to display a SharePoint list on a Confluence wiki page. The macro can display most SharePoint list types and document libraries.
Users can only see content in Confluence via "SharePoint Online List" macro they are allowed to see in SharePoint itself, too (see also What if a user doesn't have access to the SharePoint List configured for a Confluence Macro?). Special list types (for example calendar, tasks) can also be integrated but the will be displayed just like any other list (no calendar view etc.). |
Currently it is not possible to render a List macro via pasting a List URL link into the Confluence page. Please continue adding it like explained in the following section. |
Open the macro browser to embed a SharePoint list resp. document library.
Open the macro browser and search for "SharePoint Online List" macro. You can use the search field to reduce the shown macros by start typing its name.
Image 1: Add SharePoint list macro (click to enlarge)
Image 2: Select 'SharePoint Online List' in the browser.
Image 3: SharePoint Online List configuration (click to enlarge)
Site filter:
First select the site on which the list is located that you want to embed.
By default the root site collection of the SharePoint Online tenant is selected. That means that initially only documents belonging to the root site collection will be displayed.
The user that is logged in to SharePoint should have at least read access to the list and to the root site collection of your SharePoint Online tenant to be able to find the list. |
It is possible to configure a starting folder within a selected list, that will be shown on first page load. To do so, click on the 'Choose start folder' button at the bottom of the macro editor. If it is not possible to click the button, then the selected list does not contain any folders.
After clicking on the button the first level folders of the selected list will be shown in the result table:
Image 4: SharePoint Online List configuration - start folder selecting view (click to enlarge)
It is either possible to select a folder directly via clicking on the row or to navigate inside a folder via the button on the left side of the row (the folder will also be selected on navigation). The full path of your current configuration can be seen on top of the macro editor at 'Selected'.
Image 5: SharePoint Online List configuration - start folder selecting view, deeper navigation level (click to enlarge)
Because of major backend changes we had to remove the default view feature. The displayed columns are now: 'Name', 'Modified' and 'Modified by'. |
When the SharePoint Online list is added to the page, you can see the content of the list. There is the option to navigate within the list through the folders and back. It is also possible to open a document in a new tab (if it is an office document, image or pdf, otherwise the default browser behavior for documents would be triggered).
Image 6: Default View in SharePoint list macro (click to enlarge)
Image 7: The selected list in SharePoint (click to enlarge)
For uploading files via this macro to SharePoint you can use the 'Upload files' button (1) on the top right of the list and select the files via the explorer. At confirming your selection a dialog will pop up to show the current upload process. Otherwise you can easily drag files inside of the macro (2) and the upload process will start automatically.
Image 8: Upload possibilities
During the upload of a file you have the possibility to cancel (1) the upload and remove this entry from the list. By default already existing files will not be overwritten instead you will be asked which action to take on these files. If you want to overwrite existing files, click on the replace button (3). Alternatively you can also click cancel (2) and the file will not be overwritten and disappear form the list of files being uploaded.
Image 9: File upload dialog
To close the dialog and abort all your remaining uploads, click on the cancel (4) button at the bottom of the dialog. Already successfully uploaded files are will not be affected by this and they will be available at the corresponding uploaded location. Once all files are uploaded a Done button will appear instead of Cancel.