Creating KanBo Space Attached to Subfolder Created by Power Automate

The Add Space now has a new variable called Folder Path, which allows you to specify the folder that will become the space's default Document Source.

Here is how to automate it using Power Automate:

  1. Configure your Create new folder SharePoint action.

In this case, we want to create a new subfolder inside the “gogreenproject” folder called “solarplant” in a site collection with the name “SaveThePlanet”. This “solarplant” folder will become the default Document Source – the space will see only documents contained in that folder and below.

KanBo’s “Add Space” action takes in the folder path with a slash (“/”) at the beginning, which means that we will have to transform the output of the SharePoint Power Automate action. In order to do that, we will need to initialize three variables.

  1. Initialize three variables:

a) First variable:

Here, we need a String variable called “Path”. We need to add dynamic content from SharePoint to the variable called “Full Path”.

b) Second variable:

Here we will need an Integer variable called PathLength. We will need to use an expression here for value. Please copy the code excerpt below:

length(variables('Path'))

c) Third variable:

Here we will need an Integer variable, with the name “IndexOfSlash”. The expression here should be:

indexOf(variables('Path'),'/')
  1. Configure the Add Space action.

Type in the name of the space, choose the space color, and the space language. These variables are up to your personal choice.

The important variables here are the “O365 Group GUID” and the “Folder path”.

For the “O365 Group GUID”, paste the ID of the O365 Group associated with the SharePoint site collection specified in the “Create new folder” action.

For the Folder path, paste this expression (mark it and copy/paste it):

substring(variables('Path'),variables('IndexOfSlash'),sub(variables('PathLength'),variables('IndexOfSlash')))

Once the Power Automate action “Add Space” is executed, you will find a new space that is attached to the subfolder of your choice.

If you set a Space Template in the parameters of the "Add Space" Power Automate action and if the space Template, you have selected has a folder structure and files included, then it will create that folder structure and files below the subfolder you have provided for the default Document Source.

Was this article helpful?

Please, contact us if you have any additional questions.