Report a problem
Go to KanBo Website

Creating KanBo Space Attached to Subfolder Created by Power Automate

This post is also available in: Deutsch

The “Add Space” now has a new variable called “Folder path”, which allows specifying 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.

To do that, we will need to initialize three variables.

  1. Initialize three variables.

First variable:

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

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'))

Third variable:

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

indexOf(variables('Path'),'/')

Now you are ready for further steps.

  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.