Microsoft Flow Merge Excel Files

broken image


  1. Merge Excel Files Into One File
  2. Microsoft Flow Merge Excel Files Online
  3. Microsoft Flow Merge Excel File

We're pleased to announce that Microsoft Flow is now integrated into Excel. With this integration that uses the For a selected row trigger and the Flow launch panel, you can create and trigger on-demand flows for selected rows in any Excel table on spreadsheets hosted in SharePoint or OneDrive for Business. The Microsoft Flow for Excel add-in enables you to connect your data to a wide range of services such as SharePoint, Outlook 365, Dynamics 365, Teams, Visual Studio Online, Twitter, Approvals, etc. In this post, we'll walk you through this new capability with a hands-on example.

To get started, in Excel, go to the Insert tab in the ribbon and select Store. Then, in the dialog, search for Microsoft Flow. Then, click Add.

Let's imagine that you work for Cronus Energy, a multi-national energy production company, which generates energy through wind turbines and hydroelectric power plants. Cronus is on the lookout for better ways to streamline and standardize internal processes to make things easier for their employees. They've identified a key process they want to modernize:

  1. Document Merge (Preview) SharePoint Document and Mail Merge is the simple, fast and clean way to merge SharePoint list data into predefined Word, Excel and PowerPoint document templates with NO CODE!
  2. Document Merge (Preview) SharePoint Document and Mail Merge is the simple, fast and clean way to merge SharePoint list data into predefined Word, Excel.
  3. Jul 15, 2012 First task scans through each file looking for new unique values and adds them to the lookup tables before the file is imported (second data flow task). In order to find new lookup values, first data flow task's process is as follows: OLE DB Source connected to the source files (using XLSX files in this case).
  4. To merge data in Excel using this method, open your Excel files and, in the target Excel file for merging data, create a new worksheet by pressing the + (plus) button next to the sheet tabs at the bottom of the window. In your new worksheet, press Data Consolidate.

Read large excel files within seconds without creating tables using Microsoft Graph. At this point of got an array of items available and read from Excel ready to update the data in my SharePoint list. For convenience I'm pushing the data through a select action. This way it will be easier to refer my data later on in my flow.

Transfer market data entered by Commercial Analysts (minimum energy to generate, maximum energy, and target energy based on revenue goals) to SharePoint so that the Operations team can decide which turbines to use for the week. After moving the data to SharePoint, they also want to send an alert to the team on Microsoft Teams and facilitate a discussion if needed. The Operations team uses a SharePoint list called Turbine Energy Distributions with the columns shown below.
Their development team is already short on resources, so they want to be able to stand up the solution quickly while avoiding as much custom development as possible. Let's see how Flow can help.

The Commercial Analysts at Cronus Energy enter market data in a spreadsheet hosted in SharePoint. To follow along, download this spreadsheet and upload it to SharePoint or OneDrive for Business.
To get started, click the Flow menu from under the Data tab in the ribbon.
This will open the Flow launch panel in Excel where you will be prompted to Sign in and consent to the permissions requested by the add-in. Click Accept.

Once you've signed in, you can explore several templates to quickly connect to a wide variety of services with minimal set up. Scroll down the screen and choose Create an item in SharePoint for a selected row.
Selecting the template will prompt you for your credentials and provide additional details about the template. Click Continue.
In the trigger (For a selected row), click the drop-down next to the Table field and select your table, e.g. Table1. The trigger may be collapsed; if so, click on Edit and confirm that the Table field is set to Table1.
The For a selected row trigger is similar to other manual triggers like the Flow button for mobile or SharePoint's For a selected item – users can be prompted for inputs when they run the flow (Text, Yes/No, File, Email, or Number) and all flows run with the credentials of the invoker. For this flow, add a Text input called Message with the hint text of 'Enter a message for the team.'
In the SharePoint-Create item action, enter the Site Address and List Name for Cronus Energy's Turbine Energy Distributions List.
Click the Week field and select Week from the Dynamic content pane.
The parameters in the Dynamic content pane consist of your table's columns – Week, Min Energy (mWh), Target Energy (mWh), Max Energy (mWh), Price ($/mWh), Revenue, and Profit, information about the person invoking the flow – Timestamp, User email, User id, and User name, and lastly any 'manual' Outputs you add to the trigger like Message.
Repeat this for the Energy Target, Min Energy, and Max Energy.
Now, add a Microsoft Teams – Post message action. Choose a Team and Channel to post your message to. In the Message field, enter a link to the newly created item along with the Message populated by the flow invoker.
Save the flow by clicking the Save button.

Select a row in the table and then click Run flow in the Flow launch panel.
The first time you run this flow, you'll be asked to confirm your credentials. You can also learn more about what this flow does. Click Continue.
Now enter a message to send to your team, requesting feedback. Click Run flow.


Voila! An item is created in SharePoint with details from the row you selected in Excel and a message is posted on your behalf including your note asking for feedback and a link to the item.

Now that you've created the flow, you can share it with colleagues either by adding them as an owner of the flow or as a run-only user. The latter allows you to maintain ownership of the flow, while enabling your colleagues to run it. In Flow, head over to My Flows and choose the Create an item in SharePoint for a selected row flow. Note – To run the flow, they must have access to the spreadsheet.

Under Manage Run-Only Users, click Add another person.
Here you can enter individuals, AD security groups, O365 groups, or even anyone that has access to the SharePoint list. For each connector used in the flow, you can decide whether the invoker should bring their own credentials ('Provided by run-only user') or use your credentials ('Use this connection'). Click Save to add the user as a run-only user.

We hope you enjoy this new update. If you have ideas for templates or other feedback, please leave us comments below or post on our Community forums.

This article demonstrates how to merge PDF files with the help of Power Automate (Microsoft Flow).

In this example, we will read three DOCX files from a specific folder, convert these files to PDF, merge them and send the result PDF file by email.

For instance, it may be useful in a situation when a few employees prepare different sections of a contract at the same time. They load the parts of the contract to a folder, then all files from this folder are merged to form the final document.

So, our source DOCX files have to be stored somewhere. Power Automate (Microsoft Flow) has a lot of connectors for different systems. Here are just a few of them:

  • SharePoint

  • Salesforce

  • Box

  • OneDrive

  • Google Drive

  • Dropbox

  • SFTP

  • File System

In this example, we will store our source DOCX files in SharePoint in a library that we named Source Files Library, but you can get data from other sources. You may use these links to download 3 sample DOCX files: 1, 2, 3.

Merging PDF files¶

Here, we will guide you step by step through creating the flow. Google right now media. You also will find a screenshot of the complete flow at the end of the article.

Flow trigger¶

You can actually pick any trigger. For example, you can start Flow on file creation in a SharePoint document library. We use Manually trigger a flow trigger here to simplify the Flow.

Get files (properties only)¶

We start with getting properties of all our DOCX files stored in a specific folder - * Source Files Library*. In the next step, we will iterate through the output from this action to get those files contents.

You can use any other connector to get files from your system.

Initialize variable¶

We need to prepare an array of files, that we will put in Plumsail Documents - Merge PDF action when composing the final document.

Add a new action and search for Variables - Initialize variable action. Enter a name for the variable and choose the Array type for it.

Get file content using path¶

Now, you need to add Get file content using path action to get source DOCX files contents.

Click File Path field and add there Folder Path and File name with extension from a menu on the right. This will automatically transform this action into repeating one which will be performed for each file from the source folder.

Convert DOCX to PDF¶

This is an action from Plumsail Documents connector.

Put here File content from the output of the previous action.

You can find more detailed information about Convert DOCX to PDF action here.

Append to array variable¶

Now, add Variables - Append to array variable action. Into the Value field, put Result file from the output of the previous operation:

The array of PDF files is ready, now we can move to the main step - merging PDFs into the final document.

Merge PDF¶

This is an action from Plumsail Documents connector.

Click a small array icon on the right to switch to the view where you can input an entire array. Add the Array of the PDF files you received in the loop to the Content of PDF documents field:

Send an Email¶

Once the result file is generated, we send an email using Office 365 Outlook - Send email action. In the Attachments section, we add a name and the extension for the merged PDF file and choose Result file output from the previous Merge PDF action.

Merge Excel Files Into One File

So, here is the complete flow:

Conclusion¶

That is all, the flow is configured. Hope, these steps will help to ease the work with documents.

Excel

Microsoft Flow Merge Excel Files Online

Hint

Microsoft Flow Merge Excel File

You may also be interested in this article explaining how to Split PDF files in Power Automate (Microsoft Flow) and Azure Logic Apps.





broken image