Unanswered

Adobe Merge PDFs from Array

(2) Share

Report

Posted on by Community Power Pla...

Hi all,

I have a Flow that gets attachments from a SharePoint list, creates PDFs out of them using the Adobe convert image to PDF action. The number of list items and attachments will vary.

Now I need to use the Adobe Merge PDFs action to merge all of these PDFs.

It needs to be dynamic.

I've tried adding the file contents to an array like in this guide and then dropping the array into the File Content part of the Merge PDFs, but I get the error:
"For application/pdf mime-type The input file appears to be corrupted and cannot be processed."

Has anyone done anything similar?

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (2)

ChristianAbata 8,951 Most Valuable Professional on at

Like (1)

Report

Re: Adobe Merge PDFs from Array

hi @Anonymous you can find here some options

Solved: Merging two pdf files - Power Platform Community (microsoft.com)

Solved: Merge PDF Files - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Re: Adobe Merge PDFs from Array

Thanks Christian, I won't be getting a subscription, and I need a sustainable solution so no free trials. I will look at the Cloudmersive tool, but specifically wondering if anyone has experience with the Adobe action, since it seems to be capable of accepting arrays and I'd rather use the actual Adobe tool.
Thanks again.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

Re: Adobe Merge PDFs from Array

Looks like it was an issue caused by an earlier step in my flow, the action is now working properly.

Was this reply helpful? Yes No
timbo23 22 on at

Like (1)

Report

Re: Adobe Merge PDFs from Array

Hi SylvieLet17, I'm running into the same issue. Would love to connect with you to learn how you were able to use the Adobe Merge PDF from Array too. Could you share how you constructed your array please? Thanks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Re: Adobe Merge PDFs from Array

Hope this helps:

Was this reply helpful? Yes No
timbo23 22 on at

Like (1)

Report

Re: Adobe Merge PDFs from Array

Thanks - helpful to guide how to construct the array. I'm still getting the same error unfortunatley. What was the issue you noted earlier in your flow? Maybe it's the same for me too...Thanks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Re: Adobe Merge PDFs from Array

Hey timbo23, sorry this took me so ridiculous long to answer...things get in the way you know?
I JUST fixed it properly (I think) :

Basically - try adding the "$content-type=application/pdf" part and the curly brackets. That should work

Was this reply helpful? Yes No
Verified answer

timbo23 22 on at

Like (3)

Report
Re: Adobe Merge PDFs from Array

Hi SylvieLet17,
Thanks for your answer. It was a help, and got me a long way down the road. I found a solution which seems to work now and I'll put it into production tomorrow.
I don't seem to have permission to upload a photo, so let me try to explain what I did:
1. After getting the file content, I set the value of my first "Append to array" command to be the "File Content" dynamic content item.

2. Then, after getting the file content for the subsequent files, I had to set the value of all subsequent "Append to array" commands to include the base64 function like this:

Note - the expression for the "$content" comes from the expression builder, and is actually:
trim(base64(outputs('Get_file_content')?['body']))

The catch was that I had to use both the 'trim()' and the 'base64()' expression in the JSON.
The base64() expression solved the issue of the subsequent PDF files being merged in as blank pages (i.e. i struggled with an issue where the first doc merged fine, but all subsequent docs were just blank pages).
The trim() expression solved the issue of the base64() dissapearing when I went back into the flow to check, edit and test it.
The actual MergePDF command was as simple as you show it, and I can then use the output either on sharepoint or attach it to an email.

Thankyou for your help.

Was this reply helpful? Yes No
happyccy 71 on at

Like (0)

Report
Re: Adobe Merge PDFs from Array

Dear Expertise/ Specialist, @Anonymous @timbo23

I have encountered the flow error with message “For application/pdf mime-type The input file appears to be corrupted and cannot be processed.” On the Flow of “Adobe Merge PDFs”. And having the similar problem. I would greatly appreciate it if you could share your successful scenario. Much Obliged.

I have 2 Tables/ Lists and the flows below:

From ‘Table 1’, I use Do-Loop to extract the Attachment from multiple records I needed.
After that, I use “Adobe Convert Doc to PDF” function to convert the (1) Attachment from multiple records to SAVE it ALL to a single raw record in ‘Table 2’. And the Loop function ended.
Then,
I get the Raw Record from ‘Table 2’
Get Attachment
Get Attachment Content
Based on (3) result, I append it to the array Variable “varPDF”
I called the “Adobe Merge PDFs” function and attach the “varPDF” to it for merging, then I could save it back to my Database.

Was this reply helpful? Yes No
happyccy 71 on at

Like (0)

Report

Re: Adobe Merge PDFs from Array

I would very appreciate your help. Best.

Was this reply helpful? Yes No