Number of pages in a PDF file

[nana001]

In a Flow I am building I would like to obtain the number of pages in a PDF document. Is there anyway?

[lucascroxatto]

Hi @Paulie78 as many have mentioned in the thread, I'm getting 0 in most cases. Is there I workaround? Has any changed since you posted this solution?

[JeganathanG]

Hi @nana001 ,

You can use Power Automate Desktop to easily get the total number of pages in a PDF. I've attached screenshots to help you understand.

1

2

To start the flow, select the file path for the pdf file.

after you've obtained the number of page counts from the flow output

Thank you,

Jegan

[dperez13]

HOW DO I do this for an incoming attachment thats a pdf I grab with get attachment from email?

get attachment then get content and then grab the page?

and if I want to first get the attachment from the email and save it to document library to sharepoint,

how can I concat a file path + attachment name in the get file content by path activity?

[AlexEncodian]

Hi, 

Only if the native solution is providing inconsistent results  for you, you can try Encodian's Get PDF Document Information action which will return the number of pages as well as other metadata (e.g. file size, author, creator, title, subject, keywords, page width and height, orientation, created/modified dates, PDF format and more).

@xhevahires1 / @PTadrous / @powerwood / @nana001 / @JustDabbling / @SCGC_Developer / @lucascroxatto 

[JoseC12]

I also tried the scenario starting with the SharePoint trigger 'When a file is created (properties only)' and used the following expression (you’ll get until 99 pages):

int(substring(split(base64ToString(body('Get_file_content')?['$content']), 'Count ')?[1], 0, 2))

 Flow:

[prathamesh26]

Hi!

I have figured out how to do this the smarter way. This solution works for all kinds of PDFs (scanned included) unlike other solutions listed here which work only for some but not all PDFs. 

See flow below:

Formula: length(body('Parse_JSON'))

To get the schema for the Parse JSON action, build the flow upto the AI model action "Recognise text in an image or a PDF document". Run it and then go to the run history, copy the output of the "Results" property, come back to editing the flow and paste it in the "Generate from sample" section of the action.

Voila! This works for all PDF types and returns the count of total pages in a PDF.

Hope this helps! 🙂

[Sathish1227]

@Paulie78 

Hi 
I hope everything is good with you.

I'm using the same fx on the compose action, but it returns the page count as 0.

I have a single page in my pdf file.

can you help me here.

sub(length(split(replace(base64ToString(outputs('Get_file_content')?['body']['$content']), 'Type/Pages', ''), 'Type/Page')),1)

[monteiro8029]

Hi @Sathish1227 ,

Use this: sub(length(split(replace(base64ToString(outputs('Get_file_content')?['body']['$content']), 'Type /Pages', ''), 'Type /Page')),1)

In this query, you need to include a space between type and page like this: 'Type /Pages'.

This function should work for some pdfs but not all.

Thanks

[jerryp48]

FYI: I had insert a white space after "Type" for this to work.

sub(length(split(replace(base64ToString(outputs('Get_file_content')?['body']['$content']), 'Type /Pages', ''), 'Type /Page')),1)

[Ethan_Power]

Thank you! This works, but I had to modify your expression to include a space between "Type" and "/Page". 

sub(length(split(replace(base64ToString(outputs('Get_file_content')?['body']['$content']), 'Type /Pages', ''), 'Type /Page')),1)

[Sathish1227]

@monteiro8029 
Hey, hope you are doing well.

Your right.
It is working for a few PDFs only, if the PDF has more white space then it is not working.

[jaopai2]

that works

[monteiro8029]

Hi @Sathish1227, yeah it should work for some but not all as some pdfs don't have 'Type/ Pages' in their metadata. 

Another way of tackling this is by using "Recognize text or image in a pdf document". 
Use the 'Results' value in the 'Parse_JSON' step from the previous step. Once you run the flow, you should get the pdf input data which you can use for the body in Parse_JSON step. 

Then all you need to do is identfy the length of the output of Parse_JSON. Use the Compose statement at the end. The formula would be :length(body('Parse_JSON'))


This does not check for "Type/ Pages" in the metadata and should give you the exact number of pages everytime you scan a document. 

Note that, the "Recognize text or image in a pdf document" consumes AI credits which could be expensive and would recommend not to use.