Merge multiple files in multiple folders into one file using OneDrive Create a File Action

Like (0) Share

Report

Posted on 15 Dec 2023 19:03:45 by ChrisS81

134

Hello,

I'd like to know if there is a way for Power Automate to take multiple files, stored within multiple folders, of a document library, and combine all of those files into one file. Then to take that file and convert it to a PDF? I've done some research and can see how to take one file and use OneDrive's "Create file" action and then convert the file to PDF using OneDrive's "Convert file (Preview)" action. In my case I need to take about 25 separate PowerPoint files and then create one PDF of the slides. I do not have access to premium connectors or have access to Third Party Muhimbi PDF connector. Any help would be greatly appreciated. Thanks.

All responses (1)

Answers (0)

Gdarmon Outlook 372 on 19 Dec 2023 at 06:51:02

Like (0)

Report

Re: Merge multiple files in multiple folders into one file using OneDrive Create a File Action

Here are the steps you can follow:
Use the “List files in folder” action to list all the files in the folders you want to merge.
Use the “Apply to each” action to loop through each file.
Use the “Get file content” action to get the content of each file.
Use the “Append to array variable” action to append the content of each file to an array variable.
Use the “Create file” action to create a new file with the content of the array variable.
Use the “Convert file (Preview)” action to convert the file to a PDF.

Gill