Create SharePoint List Using Microsoft Graph Explorer In Office 365

Microsoft Graph Explorer is a browser-based REST API client for Office 365. By using Graph explorer, we can access all applications/services in Microsoft Cloud by sending the Microsoft Graph API request.

Microsoft Graph API is a single endpoint with single authentication to access all Microsoft cloud services like Office 365 (OneDrive, SharePoint, etc..), Windows and Enterprise + Mobility.

Here, we are going to see on how to create a list in SharePoint Online using Microsoft Graph Explorer.

Authenticate and Permission Setup

• Navigate to Graph Explorer https://developer.microsoft.com/en-us/graph/graph-explorer
• Authenticate with Office 365 account by using Sign in with Microsoft button
  
  
  

Note: Graph Explorer also works with sample data, if you are not authenticated. To access the actual information, you have to sign in to the Office 365.

• After Authentication, the Sign in with Microsoft button is replaced by account information.
  
  
  
  
  
• The user should need permission to create a list. So, we have to ensure that Manage All Permission is selected in Graph Explorer permissions.
  
  
• To ensure the permission, click modify permissions Then select Site.Manage.All checkbox and click on Modify Permissions button.
  
  
  
  
  
• This will automatically logout and login to the Microsoft Graph Explorer. Before auto signing in, the application asks us to accept the permission scope.
  
  
  
  
  
• Click Accept button to accept the application to manage the lists in SharePoint Site Collections.

Graph Explorer

Now, we are ready for creating List.

• Select the Post method from the method drop-down.
• Enter the below Graph endpoint, https://graph.microsoft.com/v1.0/sites/ktskumar.sharepoint.com:/sites/dev:/lists
  
  
  
  
  
• Enter the Request body in the below format
  
  1. {
  2. "displayName": "GraphList",
  3. "list": {
  4. "template": "genericList"
  5. }
  6. 6.
  7. }

• displayName – Title for the list
• list: variable for declaring list settings
• template: child variable under list, refers to the list template type

• Ensure the Request header as below,
  
  
• Key - Content-Type
• Value - application/json
  
  
• Then, click on Run Query button to send the request to create a new list called “GraphList” under https://ktskumar.sharepoint.com/site/dev

Output

After sending the request, our request will create a new list under the provided SharePoint site. Response Preview control shows the output in JSON format as provided below.

After navigation to the SharePoint site https://ktskumar.sharepoint.com/sites/dev in a browser; we can view the newly created list “GraphList” present under the site.

Create List with Custom Columns

To create a custom list with the custom columns, alter the Request body in the below format. Add any column types under columns array in JSON.

Columns

Array variable to have column information (name, <type>, …).

The above request will create a SharePoint list called ‘GraphList’ with two additional custom columns (service as a Single line of Text and AppCount as Number)

Method - POST

Request Body

Request Header

• Key - Content-Type
• Value - application/json

Response

After navigation to the SharePoint site at URL https://ktskumar.sharepoint.com/sites/dev, we can see the newly created list called GraphList.

If, we want to create a new list with columns, send the request body as,