Thank you for all your support 🙌🔥 My most advanced AI Builder video: kzbin.info/www/bejne/j2m6o6qMmbKcgMk

FANTASTIC VIDEO! Extremely clear, yet fast and wasting no time. I am so happy I found this. Looking forward to your upcoming unstructured data AI video. Thumbs up 👍 and Thank You!!!

You have the best Video on this Topic ,even Microsoft would envy this !

Great video! Before using Power Automate I tried using Zapier and although I got it to work, it was very SLOW to populate Excel. Even though your video is from 2 years ago, it was still helpful in many ways. Currently, Microsoft has changed a few things in Power Automate but they're all good improvements. For instance, my flow was able to output my table values automatically without having to perform your last step with JSON viewer/custom expressions. My next step is figuring out how to get the all table values on a single row in Excel (in separate columns) vs having separate Excel rows for each row of table data from PDF form. In case anyone is wondering...my flow is DocuSign PowerForm > Email (i.e. extract data from DcouSign Attachment) > Excel

Thank you so much for this tutorial. I've been meaning to start using AI models in Power Automate and this has just given me the kickstart I needed to implement it on a small test project I was discussing with a colleague this week 🙂 Kudos and looking forward to more of your content!!

Amazing to watch the excel online file populate in real time! Thank you so much for this tutorial, you just opened a whole new world of possibilities for me!

Did this video help you? You can help me, and my channel, a lot by giving it a thumbs up 👍🙂 Full Power Automate Playlist: kzbin.info/aero/PLXXz88_TPiHqGlJoWhBDCAxZ9m1N_jsB6

You are my favorite content creator for this subject matter. Please continue to be great

Nicely done. This will help flatten the learning curve. Thank you!

Amazing content Anders, I've found you about a year ago now and your videos are hands down best in class. Keep it up 👍🏻

Not sure yet how I missed this video before. This is really great stuff. Thank you Anders for sharing and please keep it coming

Great stuff! That's what I'm looking for! Gonna get started next week. My final goal is to extract data from a pdf and input in a SharePoint list. Long road ahead! Thanks for doing what you do! Awesome!

Great resource. Thank you Anders for sharing this.

This is a fantastic video. finally I found it. Thank you Anders for this sharing.

This is MAGNIFICENT! can't wait to try it on our buisness case.

Thanks for sharing! Very helpful video🙂

Mange tak for denne video ! Det hjælper rigtig meget! Thanks for this video, it help me a lot!!

Great Post, looking forward to more such videos. Thank you :)

very good tutorial Anders

thank you for video, Its really helpful to learn AI builder in PA 🙂

Very nice. Thank you!

Anders, this is a most excellent video! Thank you for putting it together. I'm going to give it a try myself. The Payables staff will love me... ;-)

Great video!

Thank you for this video

Your so detailed ! SUBBED

Love it. It works

Great video. Question: If you wanted to do this for many different vendors, who all have different format invoices, would you create a collection per vendor, and when PA runs it will work out which collection to use based on the format of the PDF in the email?

Great tutorial, thanks a lot :) Had a small query - Can we interact with the model through APIs so that we can send a pdf document over a REST API and get the output of the model through the response. Even if we can trigger the model and save the response at a predefined place, would be really useful

Thank you for your Video.I would ask you if this can get multiple table or figure in each document? e.g There are several same items in different pages

Great video Anders. Love this capability within Flow but sometimes I don't get the "File Content" option to populate the Form field. Tried various triggers with success but the one i need to use is "When a File is created in a Folder" (I'm using Document Sets). Do you know how i can get the File Content option please?

Thanks Greate explain

Superbly explained :) I just want you know if the Trigger mode can be changed from "New email received" to files added to a folder and the data are extracted ?

Andres, Thank you so much for this great tutorial. Let's say that you want to do this over a folder with several pdf files? How would you do it? Thank you in advance.

VERY clearly described, thank you. However, I don't have BUILD as an option under AI Builder - is EXPLORE the same thing as BUILD?

Hi Anders, thanks for your job it´s a fantastic video-tutorial, i´d like to ask you about this issue, if you received by email 1pdf with 2 sheets ( 2 differents but wit the same structure ) how it solves this? thanks in advance

Not a very big issue, but for beginners: for Quantity, the formula should've been the same as for the other ones ?['Quantity']?['value'] instead of ?['Item']?['Quantity'] like in the video (as can be seen in the Excel table, Quantity hasn't been retrieved). Great video, Anders!

@andersjensenorg can i extract data from pdf this way and populate a word template without using excel using powerautomate or would you suggest first storing extracted data into an excel table rows to choose from?

Very good

Excellent video Anders - I have a quick question on checkboxes where the user is asked a single question (eg Are you a smoker?) but the form contains two checkboxes to answer from, a checkbox for YES and a checkbox for NO. Do you need to define two different fields here, once called SMOKER and one called NON-SMOKER thanks

Thank you. i love it. could we do it from PDF that arrived as an attachment via outlook automatically?

Amazing

Thank you for this video, very helpful. In minute 29, you mention that we can assign "OurItems" into separate columns. Do you have a video on how to do that?

Anders, Thanks so much. I've been trying to automate my Work Orders for months! This helped me get it done. I do have a question though, my model is bringing over the table words and numbers from each cell in the table, how can I make it extract the numbers only to my excel sheet? for example; each of the pdf table cells has the word "Quantity" and then the actual number. So on my spreadsheet in my quantity column is now says "Quantity 15" instead of just 15.

Great video as always Anders ! Can you share a light on its pricing as well sir ? Since I wanted to recommend this solution , but confused in productionalise pricing !

Thank you so much for this video. I noticed that your data values at the end showed the item name duplicated. Is that because you entered 'Quantity' overtop of 'value' instead of replacing 'Item' when copying the expression over at <a href="#" class="seekto" data-time="1611">26:51</a>?

Great video! I'm considering using Power Automate to extract data from a large PDF file that consists of different kinds of reports. Within the file, there may be multiple instances of the same report for different objects/parts. Additionally, there are some irrelevant pages that it should ignore. It's kinda a big investment, so do you think I can use it for this purpose?

Hi Anders Jensen Your videos is very helpful. Thank you for that and i have one doubt Please help me with this. How can i write the extracted data into a different excel sheets dynamically

Hi Anders, thanks for the video! Is there a similar one for more unstructured PDF files where information is not always in the same place and may have multiple records per page?

Good Vid

Thank for this Anders. I'm a new subscriber. I have a request. Can you make a video to rename scanned pdf files based on it's content (e.g Name, ID Number) using AI? I've been looking for a tutorial for awhile but could not find any.

Thanks for this video it solved the half of my problems. I have tryed all over KZbin to find the solution to the last half. But It looks diffecult. I need som of the values from the PDF to be converted to another value. I have tryed with VlookUp in Excel on another sheet, but it would not work. I am stuck. Do you know how to proceed?

Thanks. good video. Hey, I'm looking to insert image from PDF attachment while sending emails (using power Automate) How can i use AI builder

Hi, Can we duplicate the text after tagging the one already in table. For example i have taken a table, in that my first row first cell is having the data like "Test-1", can i duplicate this and use it in same table? If yes, please suggest me the process.

Great video! As a consultant at a very small company ( 6 employees) what you have demonstrated is very much something they could use, though their invoices are a bit more complex. Since this is a small company, with limited resources spending a lot of money on this kind of automation is not an option. Based on what you demonstrated what components of Power Automate would they need to purchase? Also how long would it take for someone to learn enough Power Automate to actually write this kind of tool? Thanks

Hi Anders, I have a standard form that I would like to extract certain columns from into a either a database or an excel table, it will be an ongoing process. Is there a way to setup and automate this process for an end users to scan these form and upload the data into a standard format.

Is there a possibility to extract the content (rows/columns) of an Excel attachment from a periodic email and then have that content posted on Microsoft Teams channel or group chat?

Thank you for the tutorial - however i am stuck at the step at minute mark <a href="#" class="seekto" data-time="682">11:22</a>. On my power automate page, there is no AI Builder "Extract Information from Invoices" option - where is that meantto be found?

Hi, do you think it's possible to standardize the field and table placements for all of the PDFs?

Hi Anders, thanks for the video. One question: how can I add the Filename to the Exceltable? Many thanks in advance.

hi... what if I dont have access (premium) to use AI builder? are we still able to use the dynamic content to extract date from pdf to excel using power automate?

Thank you!... I have a question, I have an email that I receive daily with a pdf attachment, and my boss asked me to powerbi dashboard... I contacted powerbi to a folder where all the pdf are, and powerbi does extract and combine the date... However I'm afraid it might become a heavy process once I have several years of daily filed... Do you suggest this solution for me? Or maybe extract the data out of that folder using a phyton script?

Hi Anders Thank you for making this video, i wanted to ask how can i extract the multiple same types of data from the same page ! for example: my single page pdf has 10 mulitpule choice question, i trained the model , now my question is how to extract all 10 questions and answers (trained model datas) from same page?? Thank you!

Hi, I am new to using Power Automate and I have reports with multiple pages from different banks that I take the same exact numbers from each time from each report, how would you suggest creating an AI build for this?

Hi Anders I need your help about the following: I have shared Library, and I need to make some fields (read only) not all. so how can I do that??

Can you demonstrate Ai Builder for unstructured document where we want a tabular data to be extracted from which is present in the document in two different tables.

Great Video - The only weird thing is - Whenever i add into the "Add a row inro a table" action the values (originating from AI Builder) it automatically create a second "Apply to each" queue. How can i avoid this?

How to reconcile the extracted data and make the system to get auto trained on errors and exeception.. Like in Abbyy we have verification stations

Hello, is the AI Builde only accesible with web version? I can't seem to find any AI Builder in the App version

I want to use this to extract data from multiple clinical records, NLP, (multiple pdf files) and organize it into an SQL/Excel file, with the variables I choose. Is it possible?

Hey great video, i did a similar project but i am facing a problem , my extracted data in not getting stored in 1st available row it gets stored randomly in the Excel and i am having some unwanted text in my output data please can you help me with the same??

Did you make the unstructured data video you had mentioned yet?

Can we train a model for PDF extraction if there are some different types of invoices ?if yes please let me know it works.

may i ask for the last part, how would you be able to separate it on different columns?

do you have some video with made the same but with unstructure data? plz thx

Which video should I continue to watch - if I want to export table data to each separate columns?

Please do more videos on power apps (canvas, model-driven), and all power platform course. And also Data extraction using canvas app. Is that possible?

Is it possible to publish the model of our custom documents as an API where I can send the document by post in base64 file, or a URL or bytes[ ] and it response me a json text instead to get the data from an email like this?😮

Great Video. My pdf invoice is missing a sale tax field. Anyway I can add the sale tax on pdf than add to the invoice pdf field .

Excellent video sir..Can we do similar kind of things without premium license??

Is it possible to extract multiple data invoices from pdf to excel in power automate or any other way easily,and not need data from mail, just from pc , to just extract some data from invoice (purchase and sale), looking for it all day, pls reply

Hi... can you help me with an addon action where if the pdf has more than 1 page...for example 4 invoices are sent in 1 pdf

Hey Anders!!! Thanks a lot for your videos, they have really helped me. I'm looking to convert a very long PDF file that contains a mixture of data in headers and table format but having problems with the steps shown on this video. The file is approx 50 pages long! Any help appreciated.

Hi Anders, I'm trying to create an exact model with the same flow, however the PDF I need to extract data from has multiple pages (and the number of pages vary from week to week). I currently leave the page range blank under "Extract information from documents" and the data imported into excel is only a very small portion of the multiple pages in my pdf. Is there a solution to this? Thank you for your time

if i have 1 to 20 pages every page has some table i need to extract all this detail in one excel sheet with file name , column 1 and column 2 ... i want a file name or page number value for first column where to get ??

Thank you alot! But it seems that we need premium account to use this AI Form processing at point time <a href="#" class="seekto" data-time="180">3:00</a> in your video. I dont have premium account to try! Do you have any other way or other AI with normaly account? One more time thank you so much!

I have tried this flow, but it is considering mail body content as well and showing error not unsupported type.

Thank You for explanation. As always from MS- useless solution for a standard user not a developer. This Json info is just pure craziness. Oldchool VBA was much easier then that. I think that everything a standard user would like to do in Power Automate is almost impossible without being MS developer. You see some colorfull puzzles..."yeah finally something just based on logic not a code"...but no...at the end it is absolutely the same or even worse. I think in MS it works like "let just make something intuitive and easy to use" and after some time it is more complicated then everything before and understandable by a few people. And the most fun part is we use AI and tons of code..and at the end it just doeasn't work well here when a document is a bit more complicated then MS uses as a sample. Taking in to account 60% chance to hit right data from invoice and the additional complications - it just easier when a employee put data into excel.

Hi I have daily report of pdf files with same column header and need to inserted into excel into different sheets. how to automatize the process. please help

When we have multiple table in a pdf but we only fetch related table e.g in pdf have credit, debit table but how to fetch credit table only in pdf

I have issue to get value that is negative into excel when extracting info from PDF, sample 123.90-, it just put nothing in field?

Even though I give Expressions to get data from Burger Table Entries in OurItems, still it gets the whole JSON string instead of each individual Item(Item, Rate, Quantity, Amount). Am I doing anything wrong or missing on anything?

Bonjour c'est très bien expliqué merci ! par contre j'ai un soucis à la dernière étape ça ne me propose pas les colonnes de mon tableau Excel :/

Does anyone know how many AI Builder service credits per page this method consumes? The Microsoft Power Platform Licensing guide claims it is 32 per page for invoice processing if the operation type is "prebuilt," but how do we know if this is prebuilt or not? Also, aside from the AI builder credits, does this method need the attended RPA power automate license or is the regular non-RPA power automate per user license OK?

is there any flow to remove the matadata (properties) from PDF?

I see you use the same layout type. I process over 50k pgs per year with many types of invoice formats. Do you need to create a new layout for each different type? How does it handle table objects that are a little bit shifted? I can image int will fail, correct?

Thanks Greate explain brother' <a href="#" class="seekto" data-time="734">12:14</a> <a href="#" class="seekto" data-time="734">12:14</a>

Hi anders, Referring your tutorial i tried to extract file from one drive but it throw error [The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@triggerOutputs()?['body']' is of type 'Object'. The result must be a valid array.] can you help me to sort out with this error

It goes really fast after <a href="#" class="seekto" data-time="1440">24:00</a>. Without any experience with JSON or the formula syntax, it's daunting. I was lost there.

Is there a way so teach the AI to do it with a document that contains more than 50 pages with the same format?

Hi please share the video name for unstructured doc processing