Merge Documents using Muhimbi FLOW action..

I have been working a lot with PowerAPP and Flow 💡 with Muhimbi Actions in my recent weeks. This is my second Blog for Muhimbi.

In this Blog Post we will build a FLOW which will Loop though all the documents once a day in a OneDrive for Business Folder, Merge them and Create the Merged file in a different Folder.

Before we start building the FLOW, Let’s have a look at Final FLOW.

FinalFLOW

Does the above FLOW screen-shot look complicated? Don’t worry. For the sake of simplicity. I have broken the FLOW into two parts and will explain each and every step in details.

So without wasting time let’s get into the Meat and Potatoes.😀

Part 1:

Merge FLOW Part 1

Step 1: “Recurrence” The FLOW will run once a day.

Step 2: “Initialize variable” Flow action to store the Merged Contents of

Type: “String”

Initial value: Null

Step 3:  “Initialize variable” Flow action to store the Merged Count

Type: “Integer”

Initial Value: Null

Step 4: Add the OneDrive for Business “List Files in folder” Action on the Folder library for which contain all the files that we need to be Merged.

Part 2:

Merge FLOW Part 2

Step 5:Add the “Apply to Each Loop” after Step 4 and add the Output(Body) of “List Files in folder” (Step 4)Merge FLOW Step 5

Step 6: This step will skip any sub-folder and will only select the files.

Merge FLOW Step 6

  • Add a condition.
  • IsFolder is the Output of “List Files in folder” (Step 4) and you need to set it to “False”.

Step 7: Now if the Step 6(above step) evaluates to True.

  • Add the action “Get file Content using Path”
  • File Path : Path is the  Output of “List Files in folder” (Step 4)

Merge FLOW Step 7

Step 8:

  • Add a condition.
  • Merge Count is the Output of “Initialize variable – Merge Count” (Step 3).

Merge FLOW Step 8

Step 9:Now if the Step 8(above step) evaluates to True.

Add Muhimbi “Convert Document Action”

The Action has two parameters

  • Source File Name: Name is the  Output of “List Files in folder” (Step 4)
  • Source File Content: File Content is the Output of “Get file Content using Path” (Step 7).

Merge FLOW Step 9

Step 10: Add the OneDrive for Business “Create File” action, under Step 9

The Action has three main parameters

  • Folder Path: The Path of your destination Folder.
  • File name: You can create a  variable for File name but for Simplicity I have hardcode it “MergedFile.PDF”.
  • File Content: “Processed File Content” Output of “Convert Document” Action(Step 9).

Merge FLOW Step 10

Step 11: Now if the Step 8(above step) evaluates to False i.e. Merge Count is now not equal to 0. 

  • Add the action “Get file Content using Path”
  • File Path : For simplicity Hardcode the Path with reference to Step 10. i.e.“/MergedSource/MergeDestination/MergedFile.pdf”

Merge FLOW Step 11

Step 12:  Now this is where the real Magic happens.

  • Add the Muhimbi “Merge documents” Action.
  • The Action has the following two main Parameters “Source File name” and “Source File Content”

Now let’s, configure this action.

  • “Source File name -1”: Hardcode the File Name “MergedFile.pdf” This file name should be same as Step 10 and 11″.
  •  “Source File Content -2”: File Content is the output of “Get file Content using Path 2”  Step 11.
  • “Source File name -1”: Name is the Output of “List Files in folder” (Step 4).
  • “Source File Content -2”: File Content is the output of “Get file Content using Path ”  Step 8.

Merge FLOW Step 12

Step 13:Add the OneDrive for Business “Create File” action, under Step 12

The Action has three main parameters

  • Folder Path: The Path of your destination Folder.
  • File name: You can create a  variable for File name but for Simplicity I have hardcode it “MergedFile.PDF”.
  • File Content: “Processed File Content” Output of “Merge Document” Action(Step 12).

Merge FLOW Step 13.png

Step 14: Add the Set Variable Action outside the Condition.
The Action has two main parameters.

  • Name: Select the “Merged Count” variable Initialized on Step 2
  • Value: Set the Value 1

Merge FLOW Step 14.png

Now, for Testing Purposes you can set the “Recurrence” Frequency to “Minute”. This will trigger the Flow after a Minute and Merge the document.

Merge FLOW Step 15

But Remember ❗to set the Frequency to “Day”, you don’t want to exhaust all you Muhimbi Conversion.

Happy Converting….

Advertisements

2 thoughts on “Merge Documents using Muhimbi FLOW action..

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s