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.
Add the macro
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.
Configure / edit the list macro
Image 3: SharePoint Online List configuration (click to enlarge)
Configuration and Selection information: The current selected list (and if configured also the folder path) is shown in the upper area. When you edit an already embedded macro, the previous saved configuration is shown in front of the current selection. On inserting a new macro this part will be missing.
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.
Search option (optional): The input field can be used to filter the lists by name. The result sets will be reduced accordingly.
Filter for list type (optional): With help of this filter you can reduce the results to only show document libraries or any other kind of list (generic list).
Select a list: Clicking on a line in the result table selects the associated list that shall be displayed in the macro. The selected list will be highlighted.
Select a start folder (optional): Additionally to the list selection you are also able to show the content of a certain folder when the page first loads. To do that click on the button "Choose start folder" after you selected a list. The contained folders will be shown in the table and you are able to navigate through the different folder levels. It's also possible to search for folders on the current level. For more details see chapter 'Choose a starting folder'.
Save the configuration: If the list (and optional folder) was selected, click on the 'Save' resp. 'Insert' button to save. You can check the path that will be saved on top besides 'Selected'.
Choose a starting folder
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)
Search option As for lists there is the option to search for folders by name in this view via the input field. The search is always limited to the current visible level of folders.
Navigate deeper You are able to navigate into subfolder using the arrow button. This will show up the contained folders and also select the folder that you have navigated into. This button is only available if the folder contains further subfolders.
Return to the lists overview You are always able to clear the whole selection and return to the list overview using the 'Return to lists' button. This will also reset your selection.
Selection path and navigation The breadcrumb on top always shows you the current path of the folder you are inside. It is also possible to navigate to every folder contained in this path by clicking on it. You are always able to clear the whole selection and return to the list overview using the 'x' on the right side of the breadcrumb.
Select a folder If you found the wanted folder, click on it to select it as the starting folder for your list.
Navigate back Use the 'Go back' button to go up just one level in the current folder tree. This button only appears if you have navigated to a subfolder.
Save the configuration After selecting a folder (you can check the full folder path in the 'Selected' part in top of the window) save the configuration. If the page will be published your list will start on the selected folder.
Use the list macro
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 behaviour for documents would be triggered).
Image 6: Default View in SharePoint list macro (click to enlarge)
To open the folder in SharePoint you can click on the link right above the list that is called 'Open in SharePoint'. An other way is to right click on the wished folder in the breadcrumb and to choose 'Open in a new tab'.
Image 7: The selected list in SharePoint (click to enlarge)
Upload files to the list
For uploading files via this macro to SharePoint you can use the 'Upload files' button right above the list. In the opend dialog drag your files to the grey field or click on 'Choose file' and select the files via the explorer. By default already existing files will not be overwritten. If existing and non-existing files are uploaded together, then the non-existing files will be normally uploaded but you will get a warning that some files (the existing ones) could not be uploaded. To activate the overwrite of existing files, activate the check box above the upload button.
Image 8: Upload files dialog
If you have selected your files, click on the 'Upload' button at the bottom of the dialog. You can close the upload dialog if the upload has finished. You can also close the dialog while the upload is in progress. The upload will continue in the background. If you open the dialog again, you can see the current state and if the upload has finished. After the upload has finished you have to close the dialog. Then you can start a new upload. To cancel an upload you have to reload the page.