Power Automate (Microsoft Flow) actions

Provides advanced set of Power Automate (Microsoft Flow) actions for SharePoint. It allows you to change permissions on sites, lists, list items. You can create sites from templates and many more.

Before starting, ensure that you added Plumsail connector to Power Automate (Microsoft Flow).

List of actions in this connector

Change Permissions on SharePoint site, list or list item

“Change Permissions” is a complex action that includes 12 different operations for granting, removing or restoring permissions on sites, lists, and list items.

Once you added this action to your Flow, you need to specify two initial parameters:

  • Action type - type of action for changing permissions: Grant, Remove, RemoveAll, RestoreInheritance

  • Target - target of action: Site, List, Item

Change SharePoint Permissions Example

Once you did this, you will see the rest of parameters for this particular operation.

You can find the documentation for all operations included in “Change Permissions” action below:

Grant Permissions on SharePoint Site

Grant specific permissions on site to a SharePoint user or Group with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘Grant’ for this case.

Grant

Target

The target of action: Site, List, Item. You should pick ‘Site’ for this case.

Site

User or group

Login, Email or Name of a User or Group. Also you can specify multiple items using semicolon ‘;’ delimited

user@contoso.com

Role Type

permission levels:
  • Full control

  • Design

  • Edit

  • Contribute

  • Read

  • ViewOnly

Read

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Grant Permissions on SharePoint Site Example

Remove Permissions from SharePoint Site

Delete permissions from site for specified SharePoint user or group with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘Remove’ for this case.

Remove

Target

The target of action: Site, List, Item. You should pick ‘Site’ for this case.

Site

User or group

Login, Email or Name of a User or Group. Also you can specify multiple items using semicolon ‘;’ delimited

user@contoso.com

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Remove Permissions from SharePoint Site Example

Remove All Permissions from SharePoint Site

Removing all user permissions from a SharePoint site with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘RemoveAll’ for this case.

RemoveAll

Target

The target of action: Site, List, Item. You should pick ‘Site’ for this case.

Site

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Remove All Permissions from SharePoint Site Example

Restore Permissions Inheritance for SharePoint Site

Remove unique permissions and restore permission inheritance on current SharePoint site with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘RestoreInheritance’ for this case.

RestoreInheritance

Target

The target of action: Site, List, Item. You should pick ‘Site’ for this case.

Site

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Restore Permissions Inheritance for SharePoint Site Example

Grant Permissions on SharePoint List

Grant specific permissions to a user on a SharePoint list with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘Grant’ for this case.

Grant

Target

The target of action: Site, List, Item. You should pick ‘List’ for this case.

List

List name

Title or Url of a list

Sales

User or group

Login, Email or Name of a User or Group. Also you can specify multiple items using semicolon ‘;’ delimited

user@contoso.com

Role Type

permission levels:
  • Full control

  • Design

  • Edit

  • Contribute

  • Read

  • ViewOnly

Read

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Grant Permissions on SharePoint List Example

Remove Permissions from SharePoint List

Delete permissions from a user on a SharePoint list with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘Remove’ for this case.

Remove

Target

The target of action: Site, List, Item. You should pick ‘List’ for this case.

List

List name

Title or Url of a list

Sales

User or group

Login, Email or Name of a User or Group. Also you can specify multiple items using semicolon ‘;’ delimited

user@contoso.com

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Remove Permissions from SharePoint List Example

Remove All Permissions from SharePoint List

Remove all user permissions from a SharePoint list with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘RemoveAll’ for this case.

RemoveAll

Target

The target of action: Site, List, Item. You should pick ‘List’ for this case.

List

List name

Title or Url of a list

Sales

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Remove All Permissions from SharePoint List Example

Restore Permissions Inheritance for SharePoint List

Remove unique permissions and restore permission inheritance on a SharePoint list with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘RestoreInheritance’ for this case.

RestoreInheritance

Target

The target of action: Site, List, Item. You should pick ‘List’ for this case.

List

List name

Title or Url of a list

Sales

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Restore Permissions Inheritance for SharePoint List Example

Grant Permissions on SharePoint Item

Grant specific permissions to a user on a SharePoint list item with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘Grant’ for this case.

Grant

Target

The target of action: Site, List, Item. You should pick ‘Item’ for this case.

Item

Item ID

ID of the item

7

List name

Title or Url of a list

Sales

User or group

Login, Email or Name of a User or Group. Also you can specify multiple items using semicolon ‘;’ delimited

user@contoso.com

Role Type

permission levels:
  • Full control

  • Design

  • Edit

  • Contribute

  • Read

  • ViewOnly

Read

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Grant Permissions on SharePoint Item Example

Remove Permissions from SharePoint Item

Delete permissions from a user on a SharePoint list item with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘Remove’ for this case.

Remove

Target

The target of action: Site, List, Item. You should pick ‘Item’ for this case.

Item

Item ID

ID of the item

7

List name

Title or Url of a list

Sales

User or group

Login, Email or Name of a User or Group. Also you can specify multiple items using semicolon ‘;’ delimited

user@contoso.com

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Remove Permissions from SharePoint Item Example

Remove All Permissions from SharePoint Item

Removing all user permissions from a SharePoint Item with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘RemoveAll’ for this case.

RemoveAll

Target

The target of action: Site, List, Item. You should pick ‘Item’ for this case.

Item

Item ID

ID of the item

7

List name

Title or Url of a list

Sales

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Remove All Permissions from SharePoint Item Example

Restore Permissions Inheritance for SharePoint Item

Remove unique permissions and restore permission inheritance on a SharePoint list item with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘RestoreInheritance’ for this case.

RestoreInheritance

Target

The target of action: Site, List, Item. You should pick ‘Item’ for this case.

Item

Item ID

ID of the item

7

List name

Title or Url of a list

Sales

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Restore Permissions Inheritance for SharePoint Item Example

Grant Permissions on SharePoint Folder

Grant specific permissions on folder to a SharePoint user or Group with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘Grant’ for this case.

Grant

Target

The target of action: Site, List, Item, Folder, Document. You should pick ‘Folder’ for this case.

Folder

Role Type

permission levels:
  • Full control

  • Design

  • Edit

  • Contribute

  • Read

  • ViewOnly

Read

Folder URL

The URL of the source folder. You can use full URL as well as domain relative URL.

/Sales/96 https://contoso.sharepoint.com/sites/subSite/Sales/96

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

User or group

Login, Email or Name of a User or Group. Also you can specify multiple items using semicolon ‘;’ delimited

user@contoso.com

Example

Grant Permissions on SharePoint Folder Example

Remove Permissions from SharePoint Folder

Delete permissions from a user on a SharePoint folder with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘Remove’ for this case.

Remove

Target

The target of action: Site, List, Item, Folder, Document. You should pick ‘Folder’ for this case.

Folder

Folder URL

The URL of the source folder. You can use full URL as well as domain relative URL.

/Sales/96 https://contoso.sharepoint.com/sites/subSite/Sales/96

User or group

Login, Email or Name of a User or Group. Also you can specify multiple items using semicolon ‘;’ delimited

user@contoso.com

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Remove Permissions from SharePoint Folder Example

Remove All Permissions from SharePoint Folder

Removing all user permissions from a SharePoint Folder with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘RemoveAll’ for this case.

RemoveAll

Target

The target of action: Site, List, Item, Folder, Document. You should pick ‘Folder’ for this case.

Folder

Folder URL

The URL of the source folder. You can use full URL as well as domain relative URL.

/Sales/96 https://contoso.sharepoint.com/sites/subSite/Sales/96

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Remove All Permissions from SharePoint Folder Example

Restore Permissions Inheritance for SharePoint Folder

Remove unique permissions and restore permission inheritance on a SharePoint folder with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘RestoreInheritance’ for this case.

RestoreInheritance

Target

The target of action: Site, List, Item, Folder, Document. You should pick ‘Folder’ for this case.

Folder

Folder URL

The URL of the source folder. You can use full URL as well as domain relative URL.

/Sales/96 https://contoso.sharepoint.com/sites/subSite/Sales/96

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Restore Permissions Inheritance for SharePoint Folder Example

Grant Permissions on SharePoint Document

Grant specific permissions on document to a SharePoint user or Group with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘Grant’ for this case.

Grant

Target

The target of action: Site, List, Item, Folder, Document. You should pick ‘Document’ for this case.

Document

Role Type

permission levels:
  • Full control

  • Design

  • Edit

  • Contribute

  • Read

  • ViewOnly

Read

Document URL

The URL of the source document. You can use full URL as well as domain relative URL.

/Lib/Doc.docx https://contoso.sharepoint.com/sites/subSite/Lib/Doc.docx

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

User or group

Login, Email or Name of a User or Group. Also you can specify multiple items using semicolon ‘;’ delimited

user@contoso.com

Example

Grant Permissions on SharePoint Document Example

Remove Permissions from SharePoint Document

Delete permissions from a user on a SharePoint document with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘Remove’ for this case.

Remove

Target

The target of action: Site, List, Item, Folder, Document. You should pick ‘Document’ for this case.

Document

Document URL

The URL of the source document. You can use full URL as well as domain relative URL.

/Lib/Doc.docx https://contoso.sharepoint.com/sites/subSite/Lib/Doc.docx

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

User or group

Login, Email or Name of a User or Group. Also you can specify multiple items using semicolon ‘;’ delimited

user@contoso.com

Example

Remove Permissions from SharePoint Document Example

Remove All Permissions from SharePoint Document

Removing all user permissions from a SharePoint Document with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘RemoveAll’ for this case.

RemoveAll

Target

The target of action: Site, List, Item, Folder, Document. You should pick ‘Document’ for this case.

Document

Document URL

The URL of the source document. You can use full URL as well as domain relative URL.

/Lib/Doc.docx https://contoso.sharepoint.com/sites/subSite/Lib/Doc.docx

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Remove All Permissions from SharePoint Document Example

Restore Permissions Inheritance for SharePoint Document

Remove unique permissions and restore permission inheritance on a SharePoint document with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Action type

The type of action for changing permissions. You should pick ‘RestoreInheritance’ for this case.

RestoreInheritance

Target

The target of action: Site, List, Item, Folder, Document. You should pick ‘Document’ for this case.

Document

Document URL

The URL of the source document. You can use full URL as well as domain relative URL.

/Lib/Doc.docx https://contoso.sharepoint.com/sites/subSite/Lib/Doc.docx

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Restore Permissions Inheritance for SharePoint Document Example

Provision PnP template to SharePoint

The action provisions a PnP template to an existing SharePoint site. You can use it to create lists, libraries, pages, etc. Read the article How to create a SharePoint site using PnP provisioning template for more information.

Note

The supported version of PnP schema is V202002 (or earlier). You should specify it in the accordant parameter explicitly when getting a template:

Get-PnPSiteTemplate -Out template.xml -Schema V202002

Parameters

Parameter

Description

Example

Template Content

PnP Provision template as xml text or .pnp file

Review examples of Power Automate (Microsoft Flow)s:

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Overwrite System PropertyBag Values

Specify this parameter if you want to overwrite and/or create properties that are known to be system entries (starting with vti_, dlc_, etc.)

Yes

Ignore Duplicate Data Row Errors

Ignore duplicate data row errors when the data row in the template already exists.

Yes

Clear Navigation

If you specify this value the navigation nodes will always be removed before adding the nodes in the template

Yes

Provision Content Types To SubWebs

If set content types will be provisioned if the target web is a subweb.

Yes

Provision Fields To SubWebs

If set fields will be provisioned if the target web is a subweb.

No

Handlers

If set allows you to only process a specific part of the template. Notice that this might fail, as some of the handlers require other artifacts in place if they are not part of what your applying. Check this link for possible values.

Lists, Files

Parameters

It will populate the parameter in the template the values as specified and in the template you can refer to those values with the {parameter:} token.

“ListTitle”=”Projects”;”parameter2”=”a second value”

Example

PnP Provision Example

Provision PnP Tenant template to SharePoint

The action provisions a PnP tenant template to an existing SharePoint tenant. You can use both xml and pnp templates. Xml templates are better to use for simple templates with schema only. If you want to use resource and content files - better to use PnP templates.

Find more information in the article Provision a SharePoint site using PnP tenant template.

Note

The supported version of PnP schema is V202002 (or older).

Parameters

Parameter

Description

Example

Template Content

PnP Provision template as xml text or .pnp file

Review examples of microsoft templates here

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

SequenceId

You can specify sequence in the template.

tenantSequence

Overwrite System PropertyBag Values

Specify this parameter if you want to overwrite and/or create properties that are known to be system entries (starting with vti_, dlc_, etc.)

Yes

Ignore Duplicate Data Row Errors

Ignore duplicate data row errors when the data row in the template already exists.

Yes

Clear Navigation

If you specify this value the navigation nodes will always be removed before adding the nodes in the template

Yes

Provision Content Types To SubWebs

If set content types will be provisioned if the target web is a subweb.

Yes

Provision Fields To SubWebs

If set fields will be provisioned if the target web is a subweb.

No

Handlers

If set allows you to only process a specific part of the template. Notice that this might fail, as some of the handlers require other artifacts in place if they are not part of what your applying. Check this link for possible values.

Lists, Files

Exclude Handlers

If set allows you to run all handlers, excluding the ones specified.. Check this link for possible values.

Lists, Files

Parameters

It will populate the parameter in the template the values as specified and in the template you can refer to those values with the {parameter:} token.

“ListTitle”=”Projects”;”parameter2”=”a second value”

Example

PnP Tenant Provision Example

Activate SharePoint Feature

Activate a SharePoint feature with specific ID with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Feature ID

Unique ID of the feature to activate

{D7891031-E7F5-4734-8077-9189DD35551C}

Force

Yes to force activation of the Feature even if there are errors; otherwise, false.

Yes

Is Web Feature

Yes if it is web feature otherwise, false.

Yes

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Activate SharePoint Feature Example

Create SharePoint List or Library

Create SharePoint list by template with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Title

Title of a list.

Sales reports

Template

Title of the template that will be used for this list.

Custom List

Partial Url

Usually, when you create a list you can’t control which URL it will get. For example, if you create a document library with the name “Some document lib” it will get the following URL: Some%20doc%20lib. But in some cases more useful to choose other URL, using this field, you can specify the required value. This is an optional field you can leave it blank. By default, URL will be automatically generated.

Sales_Department

Description

Description of a list.

Library contains sales reports

On Quick Nav

Display this list on the Quick Launch.

Yes

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Create SharePoint List or Library Example

Create SharePoint Subsite from Template

Create a new SharePoint subsite based on specific template with the help of Power Automate (Microsoft Flow). The article Create SharePoint subsite by custom template provides an expample of configuration for this action.

Output Parameters

Parameter

Description

Example

Web URL

URL of the created SharePoint site.

https://contoso/sites/subSite/Sales_Department

Input Parameters

Parameter

Description

Example

Title

Title of new site.

Sales department

Description

Description of the web.

Sales department’s site

Template

Title of the site template that will be used for the new site. You can use custom templates or standard SharePoint templates.

There are a few standard SharePoint templates that you can use:

  • Team site

  • Team site (classic experience)

  • Blog

  • Project Site

  • Community Site

  • Document Center

  • Records Center

  • Business Intelligence Center

  • Enterprise Search Center

  • Basic Search Center

  • Visio Process Repository

  • SAP Workflow Site

Leaf URL

A string that represents the URL leaf name

Sales_Department

Lcid

LCID of the new web.

1033

Inherit Permissions

Specifies whether the new site will inherit permissions from its parent site.

Yes

Inherit navigation

Specifies whether the site inherits navigation.

No

On top navigation

Display this site on the top link bar of the parent site. The default value is Yes.

Yes

On quick launch

Display this site on the Quick Launch of the parent site. The default value is No.

No

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Create SharePoint Subsite from Template Example

Create Modern SharePoint Site

Warning

This action work only with SP Custom Credentials key type

Creates a modern SharePoint Team or Communication site with the help of Power Automate (Microsoft Flow).

“Create Modern SharePoint Site” is a complex action that includes 3 different operations for creating Team’s or Communication’s sites.

Once you added this action to your Flow, you need to specify the initial parameter:

  • Site type - the type of the site for create: TeamSite, CommunicationSite or TeamSiteWithNoGroup

Create Modern SharePoint Site Example

Once you did this, you will see the rest of parameters for this particular operation.

You can find the documentation for all operations included in “Create Modern SharePoint Site” action below:

Create Team SharePoint Site

Output Parameters

Parameter

Description

Example

Web URL

The URL of a new site.

https://contoso.sharepoint.com/sites/team-site

Input Parameters

Parameter

Description

Example

URL

The full qualified URL (e.g. https://yourtenant.sharepoint.com/sites/team-site).

https://contoso.sharepoint.com/sites/team-site

Display Name

The title of the site to create.

Team site

Site Design

The custom site design that will be used. You can select a value from a dropdown list of the available values. If in some reasons you can’t see target site design, you can specify it manually by its identifier value.

Contoso customer tracking
a317d0e7-a13d-4427-a302-2875c628a46e

Classification

The Site classification to use.

HR

Description

The description to use for the site.

Site for HR

Is Public

Defines whether the Office 365 Group will be public (default), or private.

Yes

Example

Create Team SharePoint Site Example

Create Communication SharePoint Site

Output Parameters

Parameter

Description

Example

Web URL

The URL of a new site.

https://contoso.sharepoint.com/sites/communication-site

Input Parameters

Parameter

Description

Example

URL

The full qualified URL (e.g. https://yourtenant.sharepoint.com/sites/communication-site or https://yourtenant.sharepoint.com/teams/communication-site).

https://contoso.sharepoint.com/sites/communication-site

Title

The title of the site to create.

Communication site

Description

The description to use for the site.

Site for HR

Site Design

The built-in and custom site design to use. You can select a value from a dropdown list of the available values. If in some reasons you can’t see target site design, you can specify it manually by its identifier value or name (for built-in values: Topic, Showcase, Blank).

Topic
Showcase
Blank
Contoso customer tracking
a317d0e7-a13d-4427-a302-2875c628a46e

LCID

The language to use for the site. If not specified will default to the language setting of the clientcontext.

1033

Allow File Sharing For Guest Users

If set to true, file sharing for guest users will be allowed.

Yes

Classification

The site classification to use.

HR

Example

Create Communication SharePoint Site Example

Create Team SharePoint Site with No Group

Output Parameters

Parameter

Description

Example

Web URL

The URL of a new site.

https://contoso.sharepoint.com/sites/team-site

Input Parameters

Parameter

Description

Example

URL

The full qualified URL (e.g. https://yourtenant.sharepoint.com/sites/team-site).

https://contoso.sharepoint.com/sites/team-site

Title

The title of the site to create.

Team site

Description

The description to use for the site.

Site for HR

LCID

The language to use for the site. If not specified will default to the language setting of the clientcontext.

1033

Site Owner Login

The login of the user that will be a site administrator.

admin@contoso.onmicrosoft.com

Time Zone ID

Time zone for the site. For more information about time zone check this list.

93

Site Design

The custom site design that will be used. You can select a value from a dropdown list of the available values. If in some reasons you can’t see target site design, you can specify it manually by its identifier value.

Contoso customer tracking
a317d0e7-a13d-4427-a302-2875c628a46e

Example

Create Team SharePoint Site With No Group Example

Apply SharePoint site design

Applies the selected site design to the specified SharePoint site. See more information here. You can get a list of available site design by PowerShell cmdlet Get-SPOSiteDesign .

Please find an example of using the action in this article How to apply a site design to SharePoint site using Apply Site Design action.

Input Parameters

Parameter

Description

Example

URL

The fully qualified SharePoint site url.

https://contoso.sharepoint.com/sites/subsite

Site Design

You can specify both the name and the identifier

contoso site design bb6b6e04-88fe-4824-bd70-b813681c0360

Example

Apply selected design to SharePoint Site

Add SharePoint site navigation node

Adds a menu item to either the quicklaunch or top navigation. You may find an example how to manage quick launch and top navigation items for a SharePoint site in this article .

Note

At this moment the action is only available in custom connector. Please read here how to create one.

Input Parameters

Parameter

Description

Example

Location

Mandatory parameter. The location of the node to add. Two options: Top navigation bar, Quick launch

Quick launch

Title

Mandatory parameter. Title of navigation node

Text

SharePoint Site URL

Mandatory parameter. URL of the target SharePoint site

https://contoso.sharepoint.com/sites/subSite

URL

Optional parameter. Target URL. If the URL is empty, then the top-level navigation item will be created.

https://contoso.sharepoint.com/sites/subSite

Prepend

Optional parameter. Yes or No. The default value is No.

Yes

Parent

Optional parameter. It is the title of a parent navigation item. If there are multiple top-level items with the same title, we will pick only the first.

Text

Example

Add SharePoint Site Navigation Node Example

Remove SharePoint site navigation node

Removes a menu item from either the quicklaunch or top navigation. You may find an example how to manage quick launch and top navigation items for a SharePoint site in this article .

Note

At this moment the action is only available in custom connector. Please read here how to create one.

Input Parameters

Parameter

Description

Example

Location

Mandatory parameter. The location of the node to add. Two options: Top navigation bar, Quick launch

Quick launch

Title

Mandatory parameter. Title of navigation node

Text

SharePoint Site URL

Mandatory parameter. URL of the target SharePoint site

https://contoso.sharepoint.com/sites/subSite

Parent

Optional parameter. It is the title of a parent navigation item. If there are multiple top-level items with the same title, we will pick only the first.

Text

Example

Remove SharePoint site navigation node Example

Get SharePoint Site Option Value

Reads a value from SharePoint Site Options (Property Bag) with the help of Power Automate (Microsoft Flow).

Output Parameters

Parameter

Description

Example

Option Value

A value of a specific SharePoint site option.

SPOStandard

Input Parameters

Parameter

Description

Example

Option Name

Name of the option.

sharepointhelpoverride

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Get SharePoint Site Option Value Example

Update SharePoint Site Properties

Updates web properties with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Title

The title for the website.

Sales

Description

The description for the site.

The site for Sales department

Quick Launch Enabled

A value that specifies whether the Quick Launch area is enabled on the website.

Yes

Tree View Enabled

A value that specifies whether the SharePoint Foundation TreeView is enabled in the left navigational area of website pages.

Yes

Site Logo URL

The absolute URL of the website logo.

https://contoso.sharepoint.com/sites/subSite/pics/logo.png

Alternate CSS URL

The URL for an alternate cascading style sheet (CSS) to use in the website.

https://contoso.sharepoint.com/sites/subSite/css/alternate_css.css

Associated Member Group

The users who have been given contribute permissions to the website.

SalesMembersGroup

Associated Owner Group

The associated owner groups of the website.

SalesOwnersGroup

Associated Visitor Group

The associated visitor group of the website.

SalesVisitorsGroup

Contains Confidential Info

A value that specifies whether the SharePoint site contain a confidential information.

Yes

Custom Master URL

The URL for a custom master page file to apply to the website.

https://contoso.sharepoint.com/sites/subSite/masterurl/custom.master

Enable Minimal Download

A value that specifies whether the Web site should use Minimal Download Strategy.

Yes

Is Multilingual

A value that indicates whether a multilingual user interface is enabled for the website.

Yes

Master URL

The URL of the master page that is used for the website.

https://contoso.sharepoint.com/sites/subSite/masterurl/master.master

Members Can Share

Allow Members to share the site and invite others.

Yes

No Crawl

A value that specifies whether searching is enabled for the website.

Yes

Overwrite Translations on Change

A value that indicates whether changes made to user-specified text in the default language should automatically overwrite existing translations made in all alternate languages.

Yes

Request Access Email

The e-mail address to which requests for access are sent.

admin@contoso.onmicrosoft.com

Save Site as Template Enabled

A value that specifies whether the Web site can be saved as a site template.

Yes

Server Relative URL

The server-relative URL for the website.

Sales_Department

Syndication Enabled

A value that specifies whether Really Simple Syndication (RSS) is enabled in the website.

Yes

UI Version

The current version number of the user interface.

1

Example

Update SharePoint Site Properties Example

Delete SharePoint Site

Deletes the SharePoint site by a specific URL with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Delete SharePoint Site Example

Invite External User to SharePoint

Invites external users with specific permission to a SharePoint site, a specific SharePoint group or an item in a SharePoint list with the help of Power Automate (Microsoft Flow).

“Invite External User to SharePoint” is a complex action that includes 3 different operations for inviting external users to a SharePoint site, a SharePoint list item or a SharePoint group.

Once you added this action to your Flow, you need to specify the initial parameter:

  • Target - the target of the operation: Site, Item, Group

Invite External User to SharePoint Example

Once you did this, you will see the rest of parameters for this particular operation.

You can find the documentation for all operations included in “Create Modern SharePoint Site” action below:

Also, you can find examples how to share a site with external users in this article and how to share documents in this one.

Invite External User to SharePoint Site

Invites external users with specific permission to an SharePoint site with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Email Addresses

Email addresses to send an invitation, you can specify multiple using semicolon as delimiter.

Chris@plumsail.com;John@plumsail.com

Email Body

Body of the invitation message.

External Users

Permission Role

The permission role which will granted to the user. You may specify a custom value for this field.

Full Control
Design
Edit
Contribute
Read
Approve

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Invite External User to SharePoint Site Example

Invite External User to SharePoint Item

Invites external users with specific permission to an item in a SharePoint list with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

List URL

The name or the URL of the list. You can use full URL as well as domain relative URL.

Employees

Item ID

ID of the item for which you want to grant the permission.

25

Email Addresses

Email addresses to send an invitation, you can specify multiple using semicolon as delimiter.

Chris@plumsail.com;John@plumsail.com

Email Body

Body of the invitation message.

External Users

Permission Role

The permission role which will granted to the user. You may specify a custom value for this field.

Full Control
Design
Edit
Contribute
Read
Approve

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Invite External User to SharePoint Item Example

Invite External User to SharePoint Group

Invites external users to an specific SharePoint group with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Email Addresses

Email addresses to send an invitation, you can specify multiple using semicolon as delimiter.

Chris@plumsail.com;John@plumsail.com

Email Body

Body of the invitation message.

External Users

Group Name

Name of the group which will include invited users.

External Users

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Invite External User to SharePoint Group Example

Set Default SharePoint Site Group

Configure default groups for a site with the help of Power Automate (Microsoft Flow). It is alternative of the <site URL>/_layouts/15/permsetup.aspx page in SharePoint UI.

Input Parameters

Parameter

Description

Example

Group Type

Type of the group: owners, members or visitors

Owners

Group Name

Name or ID of the group

Sales owners

SharePoint Site Url

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Set Default SharePoint Site Group Example

Copy SharePoint Document from Library

Copies the document from the document library to the specified URL with the help of Power Automate (Microsoft Flow). You can copy the document to another document library cross-site, to another site collection or to another folder.

Output Parameters

Parameter

Description

Example

Document ID

The ID of the copied document

1024

Document URL

The URL of the copied document

https://contoso.sharepoint.com/sites/subSite/Folder2/NewDoc.docx

Input Parameters

Parameter

Description

Example

Source URL

The URL of the document to be copied. You can use full URL as well as domain relative URL.

/sites/subSite/Folder1/Doc.docx
https://contoso.sharepoint.com/sites/subSite/Folder1/Doc.docx

Destination URL

The URL where the source document will be copied. You can use full URL as well as domain relative URL.

https://contoso.sharepoint.com/sites/subSite/Folder2/
https://contoso.sharepoint.com/sites/subSite/Folder2/NewDoc.docx

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Copy SharePoint Document from Library Example

Move SharePoint Document from Library

Moves the document from the document library to the specified URL with the help of Power Automate (Microsoft Flow). You can move the document to another document library cross-site, to another site collection or to another folder.

Output Parameters

Parameter

Description

Example

Document ID

The ID of the moved document

1024

Document URL

The URL of the moved document

https://contoso.sharepoint.com/sites/subSite/Folder2/NewDoc.docx

Input Parameters

Parameter

Description

Example

Source URL

The URL of the document to be moved. You can use full URL as well as domain relative URL.

/sites/subSite/LibraryName/FolderName/DocumentName.docx
https://contoso.sharepoint.com/sites/subSite/Folder1/Doc.docx

Destination URL

The URL where the source document will be moved. You can use full URL as well as domain relative URL.

https://contoso.sharepoint.com/sites/subSite/Folder2/
https://contoso.sharepoint.com/sites/subSite/Folder2/NewDoc.docx

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Move SharePoint Document from Library Example

Remove SharePoint Document by URL

Remove a SharePoint document by a specific URL with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Document URL

The URL of the document to be removed. You can use full URL as well as domain relative URL.

/sites/subSite/LibraryName/FolderName/DocumentName.docx
https://contoso.sharepoint.com/sites/subSite/Folder/Doc.docx

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Remove SharePoint Document by URL Example

Create SharePoint Document Set

Creates a new document set in the document library by the specified URL with the help of Power Automate (Microsoft Flow).

Output Parameters

Parameter

Description

Example

Document set ID

The ID of the created document set

1024

Document set URL

The URL of the created document set

https://contoso.sharepoint.com/sites/subSite/Lib/DocSet

Input Parameters

Parameter

Description

Example

DocumentSet Name

The name of the document set.

DocSet

Target List

The name or the URL of a library or a list where the document set will be created. You can use full URL as well as domain relative URL.

https://contoso.sharepoint.com/sites/subSite/Lib/

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Create SharePoint Document Set Example

Copy SharePoint Document Set

Copies a SharePoint document set from the document library to the specified URL with the help of Power Automate (Microsoft Flow). You can copy the document sets to another document library cross-site, to another site collection or to another folder.

Output Parameters

Parameter

Description

Example

Document set ID

The ID of the copied document set

1024

Document set URL

The URL of the copied document set

https://contoso.sharepoint.com/sites/subSite/Folder2/NewDocSet

Input Parameters

Parameter

Description

Example

Source URL

The URL of the document set to be copied. You can use full URL as well as domain relative URL.

/sites/subSite/LibraryName/FolderName/DocumentSet
https://contoso.sharepoint.com/sites/subSite/Folder1/DocSet

Destination URL

The URL where the source document set will be copied. You can use full URL as well as domain relative URL. If the url ends with slash ‘/’ the document sets will be placed in this folder without name changes. Otherwise, the document set will be renamed.

https://contoso.sharepoint.com/sites/subSite/Folder2/
https://contoso.sharepoint.com/sites/subSite/Folder2/NewDocSet

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Copy SharePoint Document Set Example

Move SharePoint Document Set

Moves a SharePoint document set from the document library to the specified URL with the help of Power Automate (Microsoft Flow). You can move the document sets to another document library cross-site, to another site collection or to another folder.

Output Parameters

Parameter

Description

Example

Document set ID

The ID of the moved document set

1024

Document set URL

The URL of the moved document set

https://contoso.sharepoint.com/sites/subSite/Folder2/NewDocSet

Input Parameters

Parameter

Description

Example

Source URL

The URL of the document set to be moved. You can use full URL as well as domain relative URL.

/sites/subSite/LibraryName/FolderName/DocumentSet
https://contoso.sharepoint.com/sites/subSite/Folder1/DocSet

Destination URL

The URL where the source document set will be moved. You can use full URL as well as domain relative URL. If the url ends with slash ‘/’ the document sets will be placed in this folder without name changes. Otherwise, the document set will be renamed.

https://contoso.sharepoint.com/sites/subSite/Folder2/
https://contoso.sharepoint.com/sites/subSite/Folder2/NewDocSet

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Move SharePoint Document Set Example

Create SharePoint Folder by URL

Creates a new SharePoint folder in the document library by the specified URL with the help of Power Automate (Microsoft Flow).

Output Parameters

Parameter

Description

Example

Folder ID

The ID of the created folder

1024

Folder URL

The URL of the created folder

https://contoso.sharepoint.com/sites/subSite/Folder2/Folder

Input Parameters

Parameter

Description

Example

Folder URL

The URL of the folder. If you specify full path, you can create several folders.

https://contoso.sharepoint.com/sites/subSite/Folder2/Folder

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Create SharePoint Folder by URL Example

Create SharePoint Folder in List

Creates a new SharePoint folder in the document library or list using the specified path with the help of Power Automate (Microsoft Flow).

Output Parameters

Parameter

Description

Example

Folder ID

The ID of the created folder

1024

Folder URL

The URL of the created folder

https://contoso.sharepoint.com/sites/subSite/Lib/Folder1/Folder2

Input Parameters

Parameter

Description

Example

Target List

The name or the URL of the library or the list where the folder will be created. You can use full URL as well as domain relative URL.

LibraryName
/sites/subSite/LibraryName
https://contoso.sharepoint.com/sites/subSite/Lib

Folder Path

The path where the folder will be created. The action will create all folders included into the path.

Folder1/Folder2

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Create SharePoint Folder in List Example

Remove SharePoint Folder by URL

Removes a SharePoint folder from the document library or list by the specified URL with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Folder URL

The URL of the library where the source folder will be removed. You can use full URL as well as domain relative URL.

/sites/subSite/LibraryName/FolderName
https://contoso.sharepoint.com/sites/subSite/Lib/Folder

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Remove SharePoint Folder by URL Example

Copy SharePoint Folder from Library

Copies a SharePoint folder from the document library to the specified URL with the help of Power Automate (Microsoft Flow). You can copy the folder to another document library cross-site, to another site collection or to another folder.

Output Parameters

Parameter

Description

Example

Folder ID

The ID of the copied folder

1024

Folder URL

The URL of the copied folder

https://contoso.sharepoint.com/sites/subSite/Lib2/Folder2

Input Parameters

Parameter

Description

Example

Source URL

The URL of the folder to be copied. You can use full URL as well as domain relative URL.

/sites/subSite/LibraryName/FolderName
https://contoso.sharepoint.com/sites/subSite/Lib/Folder

Destination URL

The URL where the source folder will be copied. You can use full URL as well as domain relative URL

https://contoso.sharepoint.com/sites/subSite/Lib2
https://contoso.sharepoint.com/sites/subSite/Lib2/Folder2

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Copy SharePoint Folder from Library Example

Move SharePoint Folder from Library

Moves a SharePoint folder from the document library to the specified URL with the help of Power Automate (Microsoft Flow). You can move the folder to another document library cross-site, to another site collection or to another folder.

Output Parameters

Parameter

Description

Example

Folder ID

The ID of the moved folder

1024

Folder URL

The URL of the moved folder

https://contoso.sharepoint.com/sites/subSite/Lib2/Folder2

Input Parameters

Parameter

Description

Example

Source URL

The URL of the folder to be moved. You can use full URL as well as domain relative URL.

/sites/subSite/LibraryName/FolderName
https://contoso.sharepoint.com/sites/subSite/Lib/Folder

Destination URL

The URL where the source folder will be moved. You can use full URL as well as domain relative URL

https://contoso.sharepoint.com/sites/subSite/Lib2
https://contoso.sharepoint.com/sites/subSite/Lib2/Folder2

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Move SharePoint Folder from Library Example

Declare SharePoint Document as Record

Declares a document from the specified library as a record.

Check out the example How to declare SharePoint documents as a record in this article .

Input Parameters

Parameter

Description

Example

List Name

Mandatory parameter. Title or Url of a list

DocumentLibrary

Item ID or URL

Mandatory parameter. Library’s item id or full URL to document

1

SharePoint Site URL

Mandatory parameter. URL of the target SharePoint site

https://contoso.sharepoint.com/sites/subSite

Example

Declare SharePoint Document as Record

Undeclare SharePoint Document as Record

Uneclares a document from the specified library as a record.

Input Parameters

Parameter

Description

Example

List Name

Mandatory parameter. Title or Url of a list

DocumentLibrary

Item ID or URL

Mandatory parameter. Library’s item id or full URL to document

1

SharePoint Site URL

Mandatory parameter. URL of the target SharePoint site

https://contoso.sharepoint.com/sites/subSite

Example

Undeclare SharePoint Document as Record

Check In SharePoint Document

Check-in a SharePoint document at the specified URL with the specified comment with the help of Power Automate (Microsoft Flow).

Output Parameters

Parameter

Description

Example

Document ID

The ID of the document which was check in

1024

Document URL

The URL of the document which was check in

https://contoso.sharepoint.com/sites/subSite/Lib/Doc.docx

Input Parameters

Parameter

Description

Example

Document URL

The URL of the document to check in.

https://contoso.sharepoint.com/sites/subSite/Lib/Doc.docx

Comment

The comment to accompany document check in.

Comment to the document

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Check In SharePoint Document Example

Check Out SharePoint Document

Check-out a SharePoint document at the specified URL with the specified comment with the help of Power Automate (Microsoft Flow).

Output Parameters

Parameter

Description

Example

Document ID

The ID of the document which was check out.

1024

Document URL

The URL of the document which was check out.

https://contoso.sharepoint.com/sites/subSite/Lib/Doc.docx

Input Parameters

Parameter

Description

Example

Document URL

The URL of the document to check out.

https://contoso.sharepoint.com/sites/subSite/Lib/Doc.docx

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Check Out SharePoint Document Example

Check if SharePoint Group exists

The action checks whether a SharePoint group with a specified name exists in a SharePoint site using Power Automate (Microsoft Flow).

Check out an example in this article.

Input Parameters

Parameter

Description

Example

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Group Name

The name of the SharePoint group.

SharePointGroup

Example

Check if SharePoint Group exists Example

Create SharePoint Group

Creates the SharePoint group with a specified name with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Group Name

The name of the SharePoint group.

SharePointGroup

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Group Description

The description of the SharePoint group.

Can approve documents

Group Owner

The owner of the SharePoint group, can be email or the user login.

m.anderson@contoso.onmicrosoft.com

Example

Create SharePoint Group Example

Update SharePoint Group Properties

Updates SharePoint group properties with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Group Name

The name of the SharePoint group.

SharePointGroup

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Title

The title for the SharePoint group.

New SharePoint Group

Description

The description of the SharePoint group.

Can approve documents

Owner

The owner for the SharePoint group, which can be a user or another group.

m.anderson@contoso.onmicrosoft.com

Allow Members Edit Membership

A value that specifies whether group members can modify membership in the group.

Yes

Allow Request to Join Leave

A value that specifies whether to allow users to request membership in the group and to allow users to request to leave the group.

Yes

Auto Accept Request to Join Leave

A value that specifies whether users are automatically added or removed when they make a request.

Yes

Only Allow Members View Membership

A value that specifies whether only group members are allowed to view the list of members in the group.

Yes

Request to Join Leave Email Setting

The e-mail address to which membership requests are sent.

m.anderson@contoso.onmicrosoft.com

Example

Update SharePoint Group Properties Example

Remove SharePoint Group

Removes the SharePoint group by a specified name with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Group Name

The name of the SharePoint group.

SharePointGroup

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Remove SharePoint Group Example

Add User to SharePoint Group

Adds a user to a specific SharePoint group with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Group Name

The name of the SharePoint group.

SharePointGroup

User

Login or email of the user which will be added to the specific group. Also you can specify multiple items using semicolon ‘;’ delimited.

m.anderson@contoso.onmicrosoft.com

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Add User to SharePoint Group Example

Is User Member of SharePoint Group

Checks if a user is a member of a specifed SharePoint group with the help of Power Automate (Microsoft Flow).

Output Parameters

Parameter

Description

Example

User Exists

Boolean result of checking.

True

Input Parameters

Parameter

Description

Example

Group Name

The name of the SharePoint group.

SharePointGroup

User

Login or email of a user for checking if he is a member in the specified group.

m.anderson@contoso.onmicrosoft.com

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Is User Member of SharePoint Group Example

Get Members of SharePoint Group

Gets members of a specific SharePoint group with the help of Power Automate (Microsoft Flow).

Output Parameters

Parameter

Description

Example

Users

The list of information about users that contain in a specified SharePoint group. Include Id, LoginName, Email.

[{
    "Id": "25",
    "LoginName": "i:0#.f|membership|admin@contoso.onmicrosoft.com",
    "Email": "admin@contoso.onmicrosoft.com"
}, {
    "Id": "32",
    "LoginName": "i:0#.f|membership|m.anderson@contoso.onmicrosoft.com",
    "Email": "m.anderson@contoso.onmicrosoft.com"
}]

Input Parameters

Parameter

Description

Example

Group Name

The name of the SharePoint group.

SharePointGroup

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Get Members of SharePoint Group Example

Remove User from SharePoint Group

Removes a user from a specific SharePoint group with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

Group Name

The name of the SharePoint group.

SharePointGroup

User

Login or email of the user which will be removed from the specific group. Also you can specify multiple items using semicolon ‘;’ delimited.

m.anderson@contoso.onmicrosoft.com

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Remove User from SharePoint Group Example

Get SharePoint Items By CAML Query

Executes a CAML query on a list or on a document library and returns the collection of elements with the help of Power Automate (Microsoft Flow).

Output Parameters

Parameter

Description

Example

Count Items

Count of items in the result.

21

Items

The output variable where the results will be saved. You may see the fields from found items as fields of “Items” in “Apply to each” action if you are used “ViewFields” tags in your CAML query and you will get JSON string as result of this action otherwise.

{
    "countItems": 14,
    "items": [
        {
        "FileRef": "/sites/subSite/Shared Documents/Folder",
        "FileLeafRef": "Folder"
        },
        {
        "FileRef": "/sites/krios/Shared Documents/Folder/1.png",
        "FileLeafRef": "1.png"
        }
    ]
}

Input Parameters

Parameter

Description

Example

List URL

The name or the URL of the list. You can use full URL as well as domain relative URL.

Documents

Folder URL

The server relative URL of a list folder from which results will be returned.

/SiteUrl/Lists/ListName/Folder1/SubFolder

CAML Query

CAML query that will be run.

<View Scope="RecursiveAll">
    <Query>
        <Where>
            <Contains>
                <FieldRef Name="FileLeafRef" />
                <Value Type="Text">Contract</Value>
            </Contains>
        </Where>
    </Query>
    <ViewFields>
        <FieldRef Name="FileRef"/>
        <FieldRef Name="FileLeafRef"/>
    </ViewFields>
</View>

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Get SharePoint Items By CAML Query Example

Update SharePoint List Item

Updates list item values by a passed JSON object. It supports updating of any SharePoint list column type and doesn’t require specifying mandatory field values. You can update single or multiple column values at a time. More details on the action features are in this article.

Input Parameters

Parameter

Description

Example

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

List

The name or the URL of the list. You can use full URL as well as domain relative URL.

Issues

ID, URL or Name

The ID of the source item or name of the document in library or path to it.

10 https://contoso.sharepoint.com/sites/site01/docLib/document.docx

Field values

JSON object of the List Item fields with values. The property name in the JSON object is an internal name of a list field. Value in JSON object is a string representation of the field value.

{
  "StringFieldName": "Some text",
  "DateTimeFieldName": "01/03/1995",
  "LookupFieldName": 54
}

Example

Update SharePoint list item example

Get SharePoint Item Versions History

Returns the changes history for the specific field from the SharePoint list item with the help of Power Automate (Microsoft Flow).

Output Parameters

Parameter

Description

Example

Count Versions

Count of versions.

2

Versions

The list of information about each version that includes Editor, Modified, and Value.

[
    {
        "Editor": "10;#John Smith,#i:0#.f|membership|john@plumsail.onmicrosoft.com,#john@plumsail.onmicrosoft.com,#john@plumsail.onmicrosoft.com,#John Smith",
        "Modified": "2016-04-15T16:48:00+00:00",
        "Value": "Test 3"
    },
    {
        "Editor": "10;#John Smith,#i:0#.f|membership|john@plumsail.onmicrosoft.com,#john@plumsail.onmicrosoft.com,#john@plumsail.onmicrosoft.com,#John Smith",
        "Modified": "2016-04-15T16:47:12+00:00",
        "Value": "Test 2"
    }
]

Input Parameters

Parameter

Description

Example

List URL

The name or the URL of the list. You can use full URL as well as domain relative URL.

Documents

Item ID

Item ID of the item for which you want to get the version history.

10

Field Name

Name of the field for which you want to get the version history.

Title

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Get SharePoint Item Versions History Example

Copy SharePoint Item Attachments to URL

Copies attachments from the SharePoint list item to the library using the specified folder URL with the help of Power Automate (Microsoft Flow).

Output Parameters

Parameter

Description

Example

File URLs

The list of copied files URLs.

[
    'https://contoso.sharepoint.com/sites/subSite/SharedDocuments/Doc1.docx',
    'https://contoso.sharepoint.com/sites/subSite/SharedDocuments/Doc2.docx'
]

Input Parameters

Parameter

Description

Example

List URL

The name or the URL of the list. You can use full URL as well as domain relative URL.

Issues

Item ID

The ID of the source item.

22

Destination Folder URL

The URL of the folder where the attachments will be copied.

https://contoso.sharepoint.com/sites/subSite/SharedDocuments/

Overwrite

Overwrite if a file with the same name already exists.

Yes

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Copy SharePoint Item Attachments to URL Example

Move SharePoint Item Attachments to URL

Moves attachments from the SharePoint list item to the library using the specified folder URL with the help of Power Automate (Microsoft Flow).

Output Parameters

Parameter

Description

Example

File URLs

The list of moved files URLs.

[
    'https://contoso.sharepoint.com/sites/subSite/SharedDocuments/Doc1.docx',
    'https://contoso.sharepoint.com/sites/subSite/SharedDocuments/Doc2.docx'
]

Input Parameters

Parameter

Description

Example

List URL

The name or the URL of the list. You can use full URL as well as domain relative URL.

Issues

Item ID

The ID of the source item.

22

Destination Folder URL

The URL of the folder where the attachments will be moved.

https://contoso.sharepoint.com/sites/subSite/SharedDocuments/

Overwrite

Overwrite if a file with the same name already exists.

Yes

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Move SharePoint Item Attachments to URL Example

Add Content Type to SharePoint List

Adds the specified content type to a SharePoint list with the help of Power Automate (Microsoft Flow).

Input Parameters

Parameter

Description

Example

List URL

The name or the URL of the list. You can use full URL as well as domain relative URL.

Employees

Content Type Name

Name of the content type.

Contact

Make It Default

Make the content type default for the list.

Yes

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Add Content Type to SharePoint List Example

Copy List Item to SharePoint List

Copies the specified list item to another SharePoint list with the help of Power Automate (Microsoft Flow).

You may find an example how to copy or move SharePoint list items with attachments cross-site in this article.

Output Parameters

Parameter

Description

Example

Result Item ID

The ID of the copied item in the new SharePoint list.

22

Input Parameters

Parameter

Description

Example

List URL

The name or the URL of the list. You can use full URL as well as domain relative URL.

Issues

Item ID

The ID of the source item.

10

Destination List URL

The URL of the destination list. This list must contain same fields like in the source list.

https://contoso.sharepoint.com/sites/subSite/Lists/Problems

Copy Attachments

Copy the item with attached files or not.

Yes

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Copy List Item to SharePoint List Example

Move List Item to SharePoint List

Moves the specified list item to another SharePoint list with the help of Power Automate (Microsoft Flow).

You may find an example how to copy or move SharePoint list items with attachments cross-site in this article.

Output Parameters

Parameter

Description

Example

Result Item ID

The ID of the moved item in the new SharePoint list.

22

Input Parameters

Parameter

Description

Example

List URL

The name or the URL of the list. You can use full URL as well as domain relative URL.

Issues

Item ID

The ID of the source item.

10

Destination List URL

The URL of the destination list. This list must contain same fields like in the source list.

https://contoso.sharepoint.com/sites/subSite/Lists/Problems

Move Attachments

Move the item with attached files or not.

Yes

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Move List Item to SharePoint List Example

Start SharePoint Site Workflow (2013)

Starts a SharePoint site level workflow and pass input parameters, if they were specified. The action can run only 2013 workflows with the help of Power Automate (Microsoft Flow).

Output Parameters

Parameter

Description

Example

Workflow GUID

Guid of a site level workflow that was started.

{89823af6-95f8-4694-85ba-665abc180f1c}

Input Parameters

Parameter

Description

Example

Workflow Name

Name of the workflow which will be started.

Send notifications

Input Parameters

JSON string that contains input parameters for workflow.

{
    "Address":"john@plumsail.com",
    "Body":"Notification message"
}

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Start SharePoint Site Workflow Example

Start SharePoint List Workflow (2013)

Starts a SharePoint list level workflow and pass input parameters, if they were specified. The action can run only 2013 workflows with the help of Power Automate (Microsoft Flow).

Output Parameters

Parameter

Description

Example

Workflow GUID

Guid of a list level workflow that was started.

{89823af6-95f8-4694-85ba-665abc180f1c}

Input Parameters

Parameter

Description

Example

List URL

The name or the URL of the list. You can use full URL as well as domain relative URL.

Notifications

Item ID

Item ID of the item for which you want to start the list workflow.

22

Workflow Name

Name of the workflow which will be started.

Send notifications

Input Parameters

JSON string that contains input parameters for workflow.

{
    "Address":"john@plumsail.com",
    "Body":"Notification message"
}

SharePoint Site URL

This property defines the context of the action. The action will be executed on specified SharePoint site.

https://contoso.sharepoint.com/sites/subSite

Example

Start SharePoint List Workflow Example

Parse CSV

Parses a CSV file into an array of objects with properties in Power Automate (Microsoft Flow). Review How to read a CSV file in Power Automate (Microsoft Flow) and bulk generate documents article for more information.

Output Parameters

Parameter

Description

Example

Items

The collection of objects. Each object represents a CSV row and has properties corresponding to the CSV headers.

Each CSV header is represented by an output parameter. You can refer to a single item selecting it in MS Flow.

[
  {
    "Id": "12345",
    "PurchaseDate": "2019-05-01",
    "ExpirationDate": "2020-05-01",
    "ProductName": "Product1",
   }
 ]
../../_images/actions-parse-csv-output.webp

Input Parameters

Parameter

Description

Example

Source CSV file

The raw content of the source .csv file.. You can extract file content from other connectors like:

  • SharePoint

  • Salesforce

  • Box

  • OneDrive

  • Google Drive

  • Dropbox

  • SFTP

  • File System

List of Power Automate (Microsoft Flow) connectors

It is content of the source file.

Headers

Comma separated list of columns.

You need to specify the headers in the same order as in the CSV file. Ex.: Id, PurchaseDate, ExpirationDate, ProductName

Delimiter

Delimiter of columns. By default it’s a comma.

You can select from the following default values: Comma, Semicolon, Tab or specify a custom value.

Skip First Line

Select ‘Yes’ if your CSV has headers as a first line

If your CSV file has headers as a first line the select ‘Yes’. In that case the action will start collecting the values from the second line of the CSV file. If you select ‘No’, or the empty value then the action will start collecting values from the first line of the CSV file.

Example

Parse CSV file

Regular Expression Match

Searches an input string for all occurrences of a regular expression and returns all the matches with the help of Power Automate (Microsoft Flow). We would recommend you to use Regex 101 tool to test your expressions. It supports the same syntax as actions.

Note

By default, Regex101 works with the PCRE2 syntax. You should change it to .NET (C#) in the “Flavor” section under “Save & Share”.

You can find more examples in this article.

Output Parameters

Parameter

Description

Example

Is Success

True if the input string has at least one occurrences of a regular expression, otherwise false.

true

Matches

The dynamic response based on a pattern that is used in this action. Contains all matches groups that included in the pattern (named or unnamed).

Match0, TaskId, status

Input Parameters

Parameter

Description

Example

Pattern

Regular expression pattern. This pattern can contain inline options to modify behavior of the regular expression. Such options have to be placed in the beginning of the expression inside brackets with question mark: (?YOUR_OPTIONS). For example options (?mi) will allow to process multi line text with case insensitivity. You can find additional information about inline options in the MSDN article. Also you can find an example in this article.

Task (?<TaskId>\d+):(?<status>Approve|Reject)

Text

String to search for matches.

Task 5:Approve\nTask 53:Reject\nTask 52:Approve

Example

Regular Expression Match Example

Regular Expression Replace

In a specified input string, replaces all strings that match a regular expression pattern with a specified replacement string. We would recommend you to use Regex 101 tool to test your expressions. It supports the same syntax as actions.

Note

By default, Regex101 works with the PCRE2 syntax. You should change it to .NET (C#) in the “Flavor” section under “Save & Share”.

Output Parameters

Parameter

Description

Example

Result

Result string with replaced substrings that match a regular expression pattern.

John Smith

Input Parameters

Parameter

Description

Example

Pattern

Regular expression pattern. This pattern can contain inline options to modify behavior of the regular expression. Such options have to be placed in the beginning of the expression inside brackets with question mark: (?YOUR_OPTIONS). For example options (?mi) will allow to process multi line text with case insensitivity. You can find additional information about inline options in the MSDN article.

Name: (?<Name>.+)

Text

String to search for matches.

Name: John Smith

Replacement

Replacement string or backreference. The name or number of a captured group should be put between braces in ${}.

${Name}

Example

Regular Expression Replace Example

Regular Expression Test

Indicates whether the regular expression specified in the Regex constructor finds a match in a specified input string. We would recommend you to use Regex 101 tool to test your expressions. It supports the same syntax as actions.

Note

By default, Regex101 works with the PCRE2 syntax. You should change it to .NET (C#) in the “Flavor” section under “Save & Share”.

Output Parameters

Parameter

Description

Example

Is Success

True if the input string has at least one occurrences of a regular expression, otherwise false.

true

Input Parameters

Parameter

Description

Example

Pattern

Regular expression pattern. This pattern can contain inline options to modify behavior of the regular expression. Such options have to be placed in the beginning of the expression inside brackets with question mark: (?YOUR_OPTIONS). For example options (?mi) will allow to process multi line text with case insensitivity. You can find additional information about inline options in the MSDN article.

(?<TestGroup1>\d4) (\d5)

Text

String to search for matches.

24 45\n435 64 85

Example

Regular Expression Test Example