| Excerpt | ||
|---|---|---|
| ||
Learn how to add SharePoint lists to your Confluence pages. |
| Table of Contents |
|---|
About lists
Lists are great for sharing large amounts of data with your team, and with SharePoint Lists, you have everything in one place and always updated.
Adding a list to your page
Adding a list to your page is quite simple:
Copy the URL from the list on SharePoint;
On your Confluence page, enter edit mode
...
using the / shortcut
using the insert menu
;
Type /lists and select SharePoint Lists from the menu. Alternatively, you can click the Insert menu (the + icon on the Confluence toolbar and type lists);
Select the macro and click the edit button
...
adding a list link
go to sharepoint, copy URL
Paste link in the app modal
click button
...
;
Paste the URL on the SharePoint Lists modal;
Click the “Attach” button;
If you haven’t before, you’ll need to authenticate with your SharePoint account to view the list content;
[Optional] Select the layout options to be applied (you can edit this later);
Click the “Insert” button.
| Tip |
|---|
All done. You can now view your list on the Confluence page. |
Open in SharePoint
You can also open lists on your pages directly in SharePoint to access advanced features without having to open SharePoint and look for the list manually:
Click the context menu;
Select the option “Open in SharePoint”.
| Tip |
|---|
All done. The list opens in SharePoint in a few moments. |
Authentication
oauth sharePoint
All users must authenticate with a
...
Layout options
...
SharePoint account with access to the content to view the list on Confluence. The Authentication is done with the standard Oauth 2.0 and works exactly as in SharePoint.
Authentication is required:
the first time a user adds a list;
the first time a user wants to view a list shared by another user.
[screenshot of locked list]
We converted the first case when adding a list to a page, and for the second, the user needs to click the “Authenticate” button and follow the required steps. After that, the list will be available.
Sign out
Users can revoke the authentication anytime, and the list won’t be visible to them.
Click the context menu;
Select the “Sign out” option;
Confirm you want to sign out.
| Tip |
|---|
All done. The list isn’t visible anymore until you authenticate again. |
Layout options
You can edit the layout options when adding the list for the first time. After that you can always enter the page’s edit mode and then edit the macro to change the layout options.
[Screenshot of layout options]
You're in control of the preview layout
...
select columns to be displayed.
select the width for each column
select if you want to convert columns to labels.
you can edit layout options at any moment
Customize the layout and the content
...
of your list:
Visibility: You can toggle the visibility of each column. Clear the checkmark to hide a column;
Width: You can define the width of each column. The default is Auto (100%);
Label: You can choose to display any columns as labels, by clicking the toggle to turn it on.
Removing a list from your page
To remove a list from a page:
Enter the page edit mode;
Select the macro of the list you want to delete;
Click the “Delete” button;
Publish the changes to the page.
| Tip |
|---|
All done. The list won’t show anymore in your page but it’s still safe in SharePoint and you can add it again later if you need. |
Wrap up
That's all on adding and using SharePoint lists on your pages.
If you still have questions about any topics covered on this page, visit our support portal and send us your questions. Our team is always happy to help.