In this step-by-step tutorial, learn how to use Microsoft AI Builder to extract data from a PDF document. Along with extracting text fields, tables, and text boxes, you can use AI Builder to determine text sentiment, identify objects in images, and much more. Once we extract data from the PDF you can automatically insert the data into a spreadsheet, Microsoft Teams, or any other connector. You can leverage your new AI model in Power Automate and Power Apps.
We begin by entering the fields we want to extract from the PDF. Next, we upload sample documents into a collection. With the documents uploaded, we tag the documents to teach the computer what data is contained within and where the data is located. We then train our model based on the sample documents and tagging. We then upload a sample document to ensure that the model works as we expect. Lastly, we create a Power Automate flow that leverages the model. At the end, you’ll be able to automatically extract data from a PDF document.
👋 Additional resources
– Microsoft AI Builder License details:
– Get to AI Builder using Office.com:
– Introduction to Power Automate video:
– Introduction to Power Apps video:
⌚ Timestamps
0:00 Introduction
1:02 Caveats
1:25 Get to AI Builder
2:17 AI Builder overview
2:42 Choose info to extract
3:38 Create collection
4:22 Tag documents
5:06 Train & publish model
6:04 Use model in Power Automate
8:26 Run test
9:15 Wrap up
📃 Watch related playlists
– Playlist with all my videos on Power Automate:
– Playlist with all my videos on Power Apps:
🚩 Connect with me on social
– LinkedIn:
– Twitter:
– Facebook:
– TikTok:
– Instagram:
🔔 Subscribe to my YouTube channel
🎬 Want to watch again? Navigate back to my YouTube channel quickly
🛍 Support me with your Amazon purchases:
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel — the price to you is the same.
#stratvert…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
If failed to make a free account to trial. They must have changed something as they was schools and enterprise only
Is this limited for 4 variables only?
Hi do you have any info on how to save mhtml from browser to desktop folder
wow this is great. Can i do this with a document that lays out a table with product information and order numbers
for example at my shop i have someone write down manually onto a piece of paper the product in column A and the number of that product they want to order in column B.
can i take this manual hardcopy piece of paper, scan it and upload the information directly into excel? any help on this will be amazing
Kevin, if i wanted to take the pdf info and have it input into an online portal what option do i choose?
Hello, thank you for the video. Is there a way redact the text from PDF using AI and power automate?
Why does it seem like it's an AI that made this video?
Stopped watching after I saw the $500/month AI builder license. Thanks but no thanks.
Can I extract info like this from websites? Or is it limited to PDF documents?
Hey Kevin, do you know how to remove the background from a photo in power automate?
How to get output in Excel files
I am extracting txt pdf not images using python (Pypdf2) with a 99% accuracy, we batch multiple files with many pgs. with no problems. I got 91% passing score on my third try with AI Builder: I normally load multiple pdf files with many pages, with similar but different layouts. I found you can’t load multiple pgs in AI Builder so I circumvent the issue by running pyhton to split pgs in one pg docs. Notes: My data is structured (aprox 6 tables per pg) , and The final output is Excel in tabular format. How can i Batch? I found a power automate flow video to trigger the event when files are saved in a onedrive folder. ( 01/23) I managed to output many files and it takes 6 seconds to process each pg. How long will it take to process around 20k pgs? Pyfpf2 is super fast.
Are there any python related libraries to this task???? does anybody know???
Wow!!!
You’re amazing. Your voice is soothing. Your flow is perfect. I can’t stand watching anyone else explain things to me. They suck lol.
Hi, how do I search for the names of my users in a pdf and then send an email with the page with their reference name?
how to detect signature in a document with ai builder?
If this worked with raster-based pdf scans, I would be all over it. : (
Thank you sir, finally i understood the purpose of power automate ❤️
Great , but that $6,000 per year fee ..
And just like that we turned hours/days/weeks worth of work into seconds/minutes
Thanks Kevin, how I can to extract info from PDFs with different pages ans unestructured data? What advice can you give us? Best
Sir pls do something on , Adobe illustrator plssss.
Hey Kevin, I follow your content from Nigeria. Great content! please let's have another video for using AI Builder in Power Apps
it is so frustrating when your organization will not allow you to use these tools
Hi Kevin. thanks for this fantastic video. I wish this option was not premium. Do you know if something similar can be done without using premium connectors?
Hi Kevin, I have a requirement like I need to extract the data from Resume one and need to import the data to Resume 2, Can we do this by implementing Power Automate, if yes let me know how can we do this? Thank you
You talk like a robot.
Are you human?
Awesome Video; thank you for sharing!
"Today!" – Kevin Stratvert
Crab indeed … Stupid software that lacks any intelligence!
How about checkbox items? Is it possible and how?
That was epic, thank u sir!
hey kevin i need your help my rewards account got suspended and i cant do anything please help!
I have a field that appears multiple times on a page, but AI Builder only allows me to tag it once. It also doesn't recognize the range as a PDF table.