Skip to end of metadata
Go to start of metadata

You can use the SharePoint List macro {sp-list} to display a SharePoint list on a Confluence wiki page. The macro can display most SharePoint list types.

Screenshot: The SharePoint List macro in Confluence


매크로 브라우저 사용하기

The Macro Browser is a graphical menu that allows you to view the list of available Confluence macros and add them to the current page or blog post.

To insert the SharePoint List macro into a page using the Macro Browser,

  1. Open the Confluence page or blog post that you want to edit, then click the 'Edit' button.
  2. Click the Macro Browser icon on the toolbar. The macro browser window will open.
  3. Scroll through the list of macros to find the one you want. Alternatively, start typing the macro name into the search box at the top right of the macro browser. Macros with a matching name will appear in the main pane.
  4. Click the desired macro.
  5. Set the macro parameters to your requirements. If desired, you can preview these changes by clicking 'Refresh'.
  6. Click 'Insert' to add the macro onto the page.

(tick) You can also insert macros via autocomplete. For more information, see Using Autocomplete in the Rich Text Editor.


편집 시, 매크로 placeholder 를 클릭하여 편집 을 선택하여 매크로 브라우저에서 이 매크로에 대한 인자를 표시할 수 있습니다.

파라미터는 Confluence 매크로가 그 내용이 매크로 출력 형식을 제어하도록 해주는 설정 옵션입니다.

아래 이 매크로에 대한 파라미터 테이블 목록은 매크로 브라우저에서 설정할 수 있습니다.





No default

The Site parameter is the nickname of the SharePoint site as specified in the SharePoint Administration settings. See the Confluence SharePoint plugin configuration guide. Note that this value is case-sensitive – use the same capital and lower-case letters as in the plugin configuration screen. In the Confluence 'Macro Browser' you will see a dropdown showing all the SharePoint sites configured in your Confluence wiki for you to choose from.


No default

Use this parameter to specify the name of the list that you want to display in Confluence.
Displaying a list in a sub-site:
If the list you want to display is stored in a "sub-site" of the configured site alias, then you must type the name of the subsite in the list parameter, followed by the list name. For example, to display a list called "Documents" that is stored in a sub-site called "Marketing", then the list parameter would be entered as:



No default

Use this parameter to reference a view in SharePoint for controlling the appearance of the list in Confluence. By creating or customising a view in SharePoint, you can control the following aspects of the list's display:

  1. The columns that are displayed, and the order in which they appear
  2. The maximum number of rows displayed
  3. The sorted order, in which the rows appear
  4. The rows that are displayed (by specifying a filter to restrict some rows from being displayed)
    You can leave the View parameter blank, in which case the macro will use the default view configured for the desired list.


No default

Use this parameter to view the contents of a folder or sub-folder within the list. To display the contents of a root (top-level) folder, just type the name of the folder. To display the contents of a sub-folder, enter the path to the sub-folder. For example, to show the sub-folder "Team A" in a folder called "Team Documents", the Folder parameter would be entered as:

Team Documents/Team A


Example 1: Document Library with Custom View

What you need to type

What you will get

{sp-list:Site=<mysharepointalias>|List=Confluence Requirements|View=Support Team}

Example 2: Sub-folder in a Contacts List

What you need to type

What you will get

{sp-list:Site=<mysharepointalias>|List=Confluence Team|Folder=Developers/SharePoint Developers}

Example 2: Links List in a sub-site

What you need to type

What you will get

{sp-list:Site=<mysharepointalias>|List=Developers/Important Links}


Working with Macros
SharePoint Connector User's Guide

  • No labels