{"type":"doc","content":[{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"topPage"},"legacyAnchorId":{"value":"Confluence:AddanduseSharePointlists(Cloud)-topPage"}},"macroMetadata":{"macroId":{"value":"77153173794e27423505b279b8c28f60569c0189511633ff79dec8e0ed4e175a"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"3c63bb4a-c696-409c-8e5f-c5fffd81d4b7"}},{"text":"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. ","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Users can only see content in Confluence via \"SharePoint Online List\" macro they are allowed to see in SharePoint itself, too ","type":"text","marks":[{"type":"annotation","attrs":{"annotationType":"inlineComment","id":"3ede855a-2f0a-47d6-aed3-0a1076c82bb8"}},{"type":"textColor","attrs":{"color":"#333333"}}]},{"text":"(see also ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]},{"text":"What if a user doesn't have access to the SharePoint List configured for a Confluence Macro?","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}},{"type":"link","attrs":{"href":"https://communardo.atlassian.net/wiki/x/aBUlg"}}]},{"text":").","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]},{"type":"paragraph","content":[{"text":"Special list types (e.g. calendar, tasks) can also be integrated but the will be displayed just like any other list (no calendar view etc.).","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"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.","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Add the macro","type":"text"}]},{"type":"paragraph","content":[{"text":"Open the macro browser and search for \"SharePoint Online List\" macro. ","type":"text"},{"text":"You can use the search field to reduce the shown macros by start typing its name.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#091e42"}}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":771,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1280,"id":"3743f4ea-ab5e-4bd8-894d-39992218b057","collection":"contentId-9013062","type":"file","height":459}},{"type":"caption","content":[{"text":" Image 1: Add SharePoint list macro (click to enlarge)","type":"text","marks":[{"type":"em"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":615,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":882,"id":"8ef9a6c8-1ddf-42cf-b06c-7d6d461f03a5","collection":"contentId-9013062","type":"file","height":550}},{"type":"caption","content":[{"text":"Image 2: Select 'SharePoint Online List' in the browser.","type":"text","marks":[{"type":"em"}]}]}]},{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Configure / edit the list macro","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":641,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1068,"id":"1c14a6c1-08ad-4dc4-b974-6702628a97c7","collection":"contentId-9013062","type":"file","height":870}},{"type":"caption","content":[{"text":"Image 3: SharePoint Online List configuration (click to enlarge)","type":"text","marks":[{"type":"em"}]}]}]},{"type":"paragraph"},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Configuration and Selection information:","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"The currently selected list (and if configured also the folder path) is shown in the upper area. ","type":"text"},{"type":"hardBreak"},{"text":"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.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Site filter: ","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"Start by choosing the site on which the list you want to embed is located.","type":"text"},{"type":"hardBreak"},{"text":"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.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Search option (optional):","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"The input field can be used to filter the lists by name. The result sets will be reduced accordingly.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Filter for list type (optional): ","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"By using this filter, you can narrow down the results to only display document libraries or other types of lists (generic lists).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select a list:","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"Clicking on a row in the result table selects the associated list that shall be displayed in the macro. The selected list will be highlighted.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select a start folder (optional):","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"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. ","type":"text"},{"text":"For more details see ","type":"text","marks":[{"type":"annotation","attrs":{"annotationType":"inlineComment","id":"83e2a3c6-3d8f-4f90-96a8-3eea3d5e2036"}}]},{"text":"Choose a starting folder","type":"text","marks":[{"type":"link","attrs":{"href":"#startFold"}}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the configuration:","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"If the list (and optional folder) was selected, click on the 'Insert' button to save. You can check the path that will be saved on top, near the 'Selected' label.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Configure the view:","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"If a list (and optional folder) was selected, you can configure which and how information shall be displayed. For more details, see ","type":"text"},{"text":"Configure the view.","type":"text","marks":[{"type":"link","attrs":{"href":"#confView"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Support & Feedback:","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"By clicking this button, you will open the Support and Feedback menu. You can read more about this ","type":"text"},{"text":"here","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SPONLINE/pages/9014060"}}]},{"text":".","type":"text"},{"type":"hardBreak"}]}]}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"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.","type":"text"}]}]},{"type":"heading","attrs":{"level":3},"content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"startFold"},"legacyAnchorId":{"value":"Confluence:AddanduseSharePointlists(Cloud)-startFold"}},"macroMetadata":{"macroId":{"value":"65bae19f8fbddfcd3d98ad9b5fc54e3f98a0dc9a14bdf83ef418e2e68dbf98fe"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"a286f1f8-fbd7-4653-8172-605ea31201fd"}},{"text":"Choose a starting folder","type":"text"}]},{"type":"paragraph","content":[{"text":"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. ","type":"text"},{"text":"If it is not possible to click the button, then the selected list does not contain any folders. ","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"After clicking on the button the first level folders of the selected list will be shown in the result table:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":641,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":828,"id":"95fd857d-305e-452e-b5e4-acaf1c53b224","collection":"contentId-9013062","type":"file","height":675}},{"type":"caption","content":[{"text":"Image 4: SharePoint Online List configuration - start folder selecting view (click to enlarge)","type":"text","marks":[{"type":"em"}]}]}]},{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"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'.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":70.0},"content":[{"type":"media","attrs":{"width":868,"id":"3df64f8a-7b35-43d2-90be-5a3ee2d51e0d","collection":"contentId-9013062","type":"file","height":709}},{"type":"caption","content":[{"text":"Image 5: SharePoint Online List configuration - start folder selecting view, deeper navigation level (click to enlarge)","type":"text","marks":[{"type":"em"}]}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Search option","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"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.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Navigate deeper","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"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.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Return to the lists overview","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"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.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Selection path and navigation","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"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. ","type":"text"},{"type":"hardBreak"},{"text":"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.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select a folder","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"If you found the wanted folder, click on it to select it as the starting folder for your list.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Navigate back","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"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.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Save the configuration","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"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.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"confView"},"legacyAnchorId":{"value":"Confluence:AddanduseSharePointlists(Cloud)-confView"}},"macroMetadata":{"macroId":{"value":"f798a71e88444e4d121f49c85ce457fae323c8abd86f4a85fbcbe8dece595e8b"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"fcc17077-d84b-4d58-bce1-662d64d01052"}},{"text":"Configure the view","type":"text"}]},{"type":"paragraph","content":[{"text":"After selecting a list you are able to configure which and how information shall be displayed.","type":"text"}]},{"type":"paragraph"},{"type":"mediaSingle","attrs":{"layout":"center","width":688,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":600,"alt":"image-20240610-133331.png","id":"68fe2f16-8445-4c43-96b3-2ad78e687fe4","collection":"contentId-9013062","type":"file","height":585}},{"type":"caption","content":[{"text":"Image 6: SharePoint Online List configuration - configure the view (click to enlarge)","type":"text","marks":[{"type":"em"}]}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Items per page","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"If the current list or folder contains a big amount of items they will get displayed in pages. This option allows you to adjust how many items shall be displayed per page.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Available Columns","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"The box on left side contains all available columns on the list. If you want to display a certain column you can simply add (or move them per drag and drop) to the selected columns on the right side.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Selected Columns","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"The list on the right side contains all selected columns which are currently displayed when viewing the macro. The order of the columns can be adjusted (via drag and drop) and will also be used for viewing the macro. To not show a certain column anymore you can simply remove (or move them per drag and drop) to the available columns on the left side.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Preview","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"The preview provides you a live sample based on your current configuration. This allows you to verify your column selection and see the data from the first entries.","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

The preview will not show all list items which are contained in the selected list! This section should just be used for preview purposes and verification on how data is formatted.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"The preview ","type":"text"},{"text":"will not show ","type":"text","marks":[{"type":"strong"}]},{"text":"all list items which are contained in the selected list! This section should just be used for preview purposes and verification on how data is formatted.","type":"text"}]}]}],"version":1},"reason":"An info macro in a list item can't be created or edited in the new editor."}}}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Use the list macro","type":"text"}]},{"type":"paragraph","content":[{"text":"When the SharePoint Online list is added to the page, you can see the content of the list. ","type":"text"}]},{"type":"paragraph","content":[{"text":"If the embedded list is a document library there are additional options to navigate within the list through the folders. 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).","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"For technical reasons, the values displayed here may look different than when they are displayed directly in SharePoint.","type":"text"}]}]},{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}]},{"type":"mediaSingle","attrs":{"layout":"center","width":675,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1280,"id":"b3634568-d21b-4e3b-aa44-151f541e9c2d","collection":"contentId-9013062","type":"file","height":397}},{"type":"caption","content":[{"text":"Image 7: View in SharePoint list macro (click to enlarge)","type":"text","marks":[{"type":"em"}]}]}]},{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open in SharePoint:","type":"text","marks":[{"type":"strong"}]},{"text":" Opens the corresponding folder of the configured SharePoint list in a new tab","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Upload:","type":"text","marks":[{"type":"strong"}]},{"text":" Upload files to the current folder. Read more about it in the next section. ","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

This feature is only available in document libraries!

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"This feature is only available in document libraries!","type":"text"}]}]}],"version":1},"reason":"An info macro in a list item can't be created or edited in the new editor."}}}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Support & Feedback:","type":"text","marks":[{"type":"strong"}]},{"text":" Opens the Support & Feedback menu. You can read more ","type":"text"},{"text":"here","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SPONLINE/pages/9014060"}}]},{"text":".","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Upload files to the list","type":"text"}]},{"type":"paragraph","content":[{"text":"You can upload files to SharePoint directly in our macro by clicking on the “Upload files” (1) button on the top right corner. You can then use the file explorer to navigate and choose the file. After confirming your selection, a pop up will show the progress of the uploading process. You can alternatively drag files inside the macro (2) and the upload process will start automatically. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":548,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1168,"id":"e8fdeb9b-9edb-4b8a-be01-44d96d526c46","collection":"contentId-9013062","type":"file","height":898}},{"type":"caption","content":[{"text":"Image 9: Upload possibilities","type":"text","marks":[{"type":"em"}]}]}]},{"type":"paragraph","content":[{"text":"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 ","type":"text"},{"text":"will not be","type":"text","marks":[{"type":"strong"}]},{"text":" overwritten. Instead, you will be asked which action to perform. If you want to overwrite existing files, click on the replace button (3). If you click cancel (2) the file will not be overwritten and disappear form the list of files being uploaded.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":570,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":800,"id":"acc6d780-8d6b-46ae-9604-5509041eea2a","collection":"contentId-9013062","type":"file","height":558}},{"type":"caption","content":[{"text":"Image 10: File upload dialog","type":"text","marks":[{"type":"em"}]}]}]},{"type":"paragraph","content":[{"text":"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 ","type":"text"},{"text":"will not be affected by this","type":"text","marks":[{"type":"strong"}]},{"text":" and they will be available at the corresponding uploaded location. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Once all files are uploaded a Done button will appear instead of Cancel. ","type":"text"},{"type":"hardBreak"}]},{"type":"rule"},{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"Back to Top","type":"text","marks":[{"type":"link","attrs":{"href":"#topPage"}}]}]}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Page Content"}},"macroMetadata":{"macroId":{"value":"3ca13a94-8ce6-4bff-a52c-0b9780829390"},"schemaVersion":{"value":"1"},"title":"Panel"}},"localId":"5587d951-22ed-46a1-808d-fb493d318188"},"content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"maxLevel":{"value":"4"},"minLevel":{"value":"2"}},"macroMetadata":{"macroId":{"value":"723d1989-1f50-4b66-b521-f0c4da0dcf75"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"d625fe76-ae69-47ed-b3a9-115364825f2b"}}]},{"type":"panel","attrs":{"panelType":"custom"},"content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"include","parameters":{"macroParams":{"":{"value":"_Version Switch"}},"macroMetadata":{"macroId":{"value":"a1f3fb79-dc25-4cb8-9fe2-4c69611f7b89"},"schemaVersion":{"value":"1"},"title":"Include Page"}}}}],"version":1}}}}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]}],"version":1}

Browser not supported