Microsoft SharePoint Online (Action Flows)
The Microsoft SharePoint Online modules enable you to monitor, retrieve, create, or update items, lists, and pages in your Microsoft SharePoint Online.
Connect Microsoft SharePoint Online to Execution Management System
Go to Execution Management System and open the Microsoft SharePoint Online module's Create a connection dialog.
Enter the name of the connection to the Connection name field and click Continue.
After you click the Continue button, Execution Management System will redirect you to the Microsoft SharePoint Online website where you will be prompted to grant Execution Management System access to your account.
Confirm access by checking the Consent on behalf of your organization checkbox and clicking the Accept button.
The connection has been established. You can proceed with setting up the module.
Note
When you choose to select the Site ID from the drop-down menu, only followed sites are offered in the drop-down menu. To specify a site that is not followed, insert the Site ID manually.
See the Permissions information for various user accounts of Sharepoint Online.
Item
Retrieves item details when an item is created or updated.
Connection | |
Watch Lists | Select whether you want to watch lists for created or modified items. |
Enter Site and List ID | Select whether you want to specify the Site ID and the List ID manually or select from drop-down menus. |
Site ID | Enter (map) the site ID or select the site that contains the list you want to watch for items. |
List ID | Enter (map) the list ID or select the list you want to watch for created or modified items. |
Limit | Set the maximum number of items Execution Management System will return during one execution cycle. |
Retrieves all items on a specified list.
Connection | |
List items | Select whether you want to specify the Site ID and the List ID manually or select from drop-down menus. |
Site ID | Enter (map) the site ID or select the site that contains the list you want to retrieve items from. |
List ID | Enter (map) the list ID or select the list you want to retrieve items from. |
Limit | Set the maximum number of items Execution Management System will return during one execution cycle. |
Returns item details.
Connection | |
Get an Item | Select whether you want to specify the Site ID, the List ID, and the Item ID manually or select from drop-down menus. |
Site ID | Enter (map) the site ID or select the site that contains the list with the item you want to retrieve details for. |
List ID | Enter (map) the list ID or select the list that contains the item you want to retrieve details about. |
Item ID | Enter (map) the item ID or select the item you want to retrieve details about. |
Creates a new item in a specified list.
Connection | |
Create an item | Select whether you want to specify the Site ID and the List ID manually or select from drop-down menus. |
Site ID | Enter (map) the site ID or select the site that contains the list you want to create an item on. |
List ID | Enter (map) the list ID or select the list you want to create a new item on. |
Title | Enter the title of the new item. |
Updates an item's fields.
Connection | |
Create an item | Select whether you want to specify the Site ID and the List ID manually or select from drop-down menus. |
Site ID | Enter (map) the site ID or select the site that contains the list you want to update an item on. |
List ID | Enter (map) the list ID or select the list you want to update a new item on. |
Fields | Enter the key and value for the item's field. |
Deletes an existing item.
Connection | |
Delete an item | Select whether you want to specify the Site ID, the List ID, and the Item ID manually or select from drop-down menus. |
Site ID | Enter (map) the site ID or select the site that contains the list you want to delete an item from. |
List ID | Enter (map) the list ID or select the list you want to delete an item from. |
Item ID | Enter (map) the item ID or select the item you want to delete. |
List
Retrieves list details when a list is created or updated.
Connection | |
Watch Lists | Select whether you want to watch the site for created or modified lists. |
Enter Site ID | Select whether you want to specify the Site ID and the List ID manually or select from drop-down menus. |
Site ID | Enter (map) the site ID or select the site you want to watch for new lists. |
Limit | Set the maximum number of lists Execution Management System will return during one execution cycle. |
Retrieves all lists for the site.
Connection | |
List Lists | Select whether you want to specify the Site ID manually or select from drop-down menus. |
Site ID | Enter (map) the site ID or select the site you want to retrieve list details for. |
Limit | Set the maximum number of lists Execution Management System will return during one execution cycle. |
Returns list details.
Connection | |
Get a List | Select whether you want to specify the Site ID and the List ID manually or select from drop-down menus. |
Site ID | Enter (map) the site ID or select the site that contains the list you want to retrieve details for. |
List ID | Enter (map) the list ID or select the list you want to retrieve details for. |
Creates a new list on a specified site.
Connection | |
Enter a Site ID | Select whether you want to specify the Site ID manually or select from drop-down menus. |
Site ID | Enter (map) the site ID or select the site you want to create a list at. |
Display Name | Enter the name of the new list. |
Description | Enter the description of the new list. |
Add Columns | Specify columns of the list. |
Page (Beta)
Note
APIs under the beta version in Microsoft Graph are subject to change. The use of these APIs in production applications is not supported.
Retrieves page details when a page is modified.
Connection | |
Enter Site ID | Select whether you want to specify the Site ID manually or select from the drop-down menu. |
Site ID | Enter (map) the site ID or select the site you want to watch for modified pages. |
Limit | Set the maximum number of pages Execution Management System will return during one execution cycle. |
Retrieves all pages for a specified site.
Connection | |
List Pages | Select whether you want to specify the Site ID manually or select from the drop-down menu. |
Site ID | Enter (map) the site ID or select the site you want to retrieve pages for. |
Limit | Set the maximum number of pages Execution Management System will return during one execution cycle. |
Retrieves page details.
Connection | |
Get a Page | Select whether you want to specify the Site ID and the Page ID manually or select from drop-down menus. |
Site ID | Enter (map) the site ID or select the site that contains the page you want to retrieve details about. |
Page ID | Enter (map) the page ID or select the page you want to retrieve details for. |
Publishes the latest version of a page.
Connection | |
Publish a Page | Select whether you want to specify the Site ID and the Page ID manually or select from drop-down menus. |
Site ID | Enter (map) the site ID or select the site that contains the page you want to publish. |
Page ID | Enter (map) the page ID or select the page you want to publish. |
Site
Searches for a site by specified criteria.
Connection | |
Keyword of Display Name | Enter the search term you want to search the sites for. |
Limit | Set the maximum number of sites Execution Management System will return during one execution cycle. |
Retrieves site details.
Connection | |
Get a Site | Select whether you want to specify the Site ID manually or select from the drop-down menu. |
Site ID | Select the site you want to retrieve details about. |
Other
Allows you to perform a custom API call.
Connection | |
URL | Enter a path relative to NoteFor the list of available endpoints, refer to the SharePoint API in Microsoft Graph Documentation. |
Method | Select the HTTP method you want to use: GET to retrieve information for an entry. POST to create a new entry. PUT to update/replace an existing entry. PATCH to make a partial entry update. DELETE to delete an entry. |
Headers | Enter the desired request headers. You don't have to add authorization headers; we already did that for you. |
Query String | Enter the request query string. |
Body | Enter the body content for your API call. |
The following API call returns all the lists on a specified site using Microsoft SharePoint Online beta API:
URL:
/beta/sites/{site-ID}/lists/
Method:
GET
 |
The result can be found in the module's Output under Bundle > Body > value.
In our example, 4 lists were returned:
Permission information for Microsoft Sharepoint
Create a List -Sites.Manage.All
Create an Item - Sites.ReadWrite.All
Delete an Item -Sites.ReadWrite.All
Download a File - Files.Read.All, Sites.Read.All
Get a List - Sites.Read.All
Get an Item - Sites.Read.All
Get a Page - Sites.Read.All
Get a Site -Sites.Read.All
List Items - Sites.Read.All
List Lists - Sites.Read.All
List Pages - Sites.Read.All
Publish a Page - Sites.ReadWrite.All
Search Sites - Sites.Read.All
Update an Item - Sites.ReadWrite.All
Watch Files/Folders - Files.Read.All, Sites.Read.All
Watch Items - Sites.Read.All
Watch Lists - Sites.Read.All
Watch Pages - Sites.Read.All