Answered

Problem with join pdf

(0) Share

Report

Posted on by dannygi1982

Hi all, i've an issue with join pdf in power automate desktop.

I've build a flow that give from a bill of materials in excel all the values (code) of articles, put it in a list, copy the corrispective files from a net folder to a temporary folder in my local pc (C:\temp) and join all in a unique pdf.

Example:

A excel sheet contain in B column all the articles to produce a machinery.

example: 000.000.0001 in b1

000.000.0002 in b2

000.000.0003 in b3 etc etc

The files called 000.000.0001.pdf, 000.000.0002.pdf, 000.000.0003.pdf is stored in \\server\pdf\publishedpdf\

My flow collect all articles in B column of the spreedsheet, create a list with path of all, and join all.

But if my list is "short" (around 20-30 pdfs) it work correctly. Otherwise if the list is long (around 150-200 pdfs) it stop and get me the error "System.NullReferenceException"

Someone know why? Thank you

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (1)

Sort by

miketran13 720 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello,

I think this is an unknown error from PAD. I have tried more than 10 times with different numbers of pdf files. And I got a same error with you when trying to merge pdfs. The thing I found that, the error is more likely to happen when you have more than 50 files and I always got error when I have more than 120 files.
I have no ideas why it happened. I hope we can get answer from MS for this issue.

Thanks and hope it can help you.
Mike
---------------------------------
Did I answer your question? Please consider to Mark my post as a solution! to guide others

Was this reply helpful? Yes No
dannygi1982 20 on at

Like
a
(0)

Report
Copy link

Link copied!

There is a workaround to do the job in a different way?
thank you for your time

Was this reply helpful? Yes No
miketran13 720 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I think you should try to minimize the number of pdf files by just combining your texts.
Or you can call the Action Merge Pdf multiple times inside a loop.

Thanks and hope it can help you.
Mike
---------------------------------
Did I answer your question? Please consider to Mark my post as a solution! to guide others

Was this reply helpful? Yes No
dannygi1982 20 on at

Like
a
(0)

Report
Copy link

Link copied!

What do you mean for combining texts?

is possible to do this example?

Example

If list > 20
split list every 20 elements and create nel lists

Thank you very much

Was this reply helpful? Yes No
miketran13 720 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Danny,

I think you can do something like this:

Thanks and hope it can help you.
Mike
---------------------------------
Did I answer your question? Please consider to Mark my post as a solution! to guide others

Was this reply helpful? Yes No
dannygi1982 20 on at

Like
a
(0)

Report
Copy link

Link copied!

@miketran13 how can i add .Count to "If batchcombinedlist" function?

Thank you

Was this reply helpful? Yes No
Verified answer

miketran13 720 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

You can select it from here.

Thanks and hope it can help you.
Mike
---------------------------------
Did I answer your question? Please consider to Mark my post as a solution! to guide others

Was this reply helpful? Yes No
dannygi1982 20 on at

Like
a
(0)

Report
Copy link

Link copied!

@miketran13 yes! It works perfectly!

Just to finish my flow: how i can truncate text to get only the first characters before space?

example: i've a filename called ASM30070059.1 Structure vertical mill.xml
and i want to get only the first characters before space. In this case ASM30070059.1.
How i can do it? Thank you, you've save me!

Was this reply helpful? Yes No