Integrate Excel & Outlook SDK based automations to single project

As a first step, let us add baseFolderPath as an environment variable

We will use this new path in Save All Mail Attachments

To reuse this automation we will release the in preview project to released project. You can do so in two ways. (1) Either you can do so from Lobby by pressing (…) or from within the project you can do so by clicking the button Release

Another way to release the project

At release time, it will ask you to specify a version number, you can accept the default suggestion

Notice the name change from Editable to (version number) Released

As a first step let us add Get Folder Collection to the baseFolderPath environment variable. This step will return all the sub folder names within a given folder. In our case, it will give each timestamp based folders fetched from each email from the outlook. Rename the output parameter to folderList

You can see the folder name by using a Log Message

We will loop through each folder. for this will add For Each loop to the flow

We will add all the required steps into the folder. the idea is on each file, a certain set of actions needs to be performed

Within each index of For Each, we can fetch list of excel files in each folder. for this, we will add Get File Collection to the loop

the value for Get File Collection is as given in the image

We will add one more For Each to loop through each excel file in that sub folder. Here to distinguish both the loop variables, you can rename it appropriately. Also include the required excel actions within this sub For Each loop.

first create a string variable to generate from the loop variable full path to the excel file

Adjust the Get File Name to take the output variable

We have hard coded ranges in Filter Range. when we generalise the functionality, we may wanted to calculate this at run time. For this, we will be adding Get UsedRange Row and Get UsedRange Column activities to find out the start and end cell values.

We will now use a custom script activity to calculate complete range.

var startColumn = 1;
var startCell = String.fromCharCode(startColumn + 64) + startColumn;
var endCell = String.fromCharCode(columnRange + 64) + rowRange;
return startCell + ":" + endCell;

just for demonstration purpose, we will filter against first column and look for cell values containing a

We will use similar approach to find out range of values after filtering to be used with Copy Range

We will append “_new” to the new CSV file name in Save As Workbook

Like Outlook sample, you need to release the package and publish to the library. You can do so either from the SAP Process Automation Lobby or from within the project.

Let us create a brand new Automation project Main Automation

Include both Excel and Outlook projects as dependency. Here I am adding Excel Project. Similarly you have to add outlook sample project

this is the result after adding both projects as dependency

We will call this new project as Main Automation project

Add both outlook sample and excel sample projects (i named it as Excel Cloud Link) to the flow

Save Project and test the project to see the result by yourself

In the end, when this tutorial was tested, we used this below source data

After Automaton is executed, it has filtered the data (Town starting with a), hide a column (Column F with title storey_range) and resultant excel will look like this