Thank you for all your support 🙌🔥 My most advanced AI Builder video: kzfaq.info/get/bejne/j56HpdqHybPNeps.html

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

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!

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

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

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

This is the best tutorial! My whole office now essentially runs off of this! Thank you so much!!

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!!!

This is a great video, thanks a lot! 👏 I have recently also started to use extraktAI for getting all my data from PDFs to excels

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

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!

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!

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!!

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.

Great resource. Thank you Anders for sharing this.

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

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

Nicely done. This will help flatten the learning curve. 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, thanks!

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

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 !

very good tutorial Anders

Thats really helpful. But i have a doubt, you have listed all the items in subsequent rows. Can't we list the items in columns? Is it possible to create columns only by giving each items in fields? Or is there any way? In general, shipment invoice of org has many fields related to fuel,transport,coolings etc., How will we get these items in columns?

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

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?

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 26:51?

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

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.

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.

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

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??

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

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

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

Thanks for sharing! Very helpful video🙂

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.

Thanks for this video it solved the half of my problems. I have tryed all over KZfaq 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?

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

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?

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

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?

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 the tutorial - however i am stuck at the step at minute mark 11:22. On my power automate page, there is no AI Builder "Extract Information from Invoices" option - where is that meantto be found?

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?

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 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

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.

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 :/

Love it. It works

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

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 .

Very nice. Thank you!

Your so detailed ! SUBBED

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

Thank you alot! But it seems that we need premium account to use this AI Form processing at point time 3:00 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!

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?

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

Great video!

Thanks Greate explain

Thank you for this video

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, 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.

Hi, I get the error: Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Add_a_row_into_a_table' at line '1 and column '2336' is invalid. Action 'apply_to_each_2' must be a parent 'foreach' scope of action 'Add_a_row_into_a_table' to be referenced by 'repeatItems' or 'items' functions.'.'.. Can do with some help!!!

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

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?

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

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?

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?

Great lesson. A bit too fast, though. It’s hard to follow the movement of your mouse. It will be great if you could use a mouse highlighter and hold your mouse for a few seconds over what you’re clicking. Referring back to previous step could also help.

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.

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?

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

I tried building this but I am getting this error " The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@item()?['attachments']' is of type 'Null'. The result must be a valid array". I dont why

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??

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?

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 ??

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

I'm trying to extract the data fields from the document invoice in "INVOICE DATE " column raising this type of error in POWER Automate The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Invoice_x0020_Date' is required to be of type 'String/date'. The runtime value '"string"' to be converted doesn't have the expected format 'String/date'

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

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?😮

@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?

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?

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

Anders - I trained my model, ran a test, and the model is giving me incorrect results. Is there a way to point out error to the model?

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?

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

Quick question; when testing OurItem either doesn't populate or it populates with the raw code again. What do I do?

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

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

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

Very good

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 way so teach the AI to do it with a document that contains more than 50 pages with the same format?

Would it have worked if you sent that test email from outlook desktop?

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?

Amazing