How to Extract Data from PDF with Power Automate

[@andersjensenorg]

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

[@johnmcgregor4268]

Thank you! I may have more questions for you on my power automate journey. This is very powerful stuff.

[@Prasanna2567]

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

[@andersjensenorg]

You're very welcome, Prasanna Balachandran - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE

[@tiennguyenminh6753]

I came across this video in 2024 and all the knowledge in this video is still helpful for me. Thanks a lot Jensen

[@andersjensenorg]

I'm so glad to hear, thanks a lot - I should do a remake soon 😊🙌 Kind regards, Anders

[@jaredt.4048]

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!

[@andersjensenorg]

Thank you so much, Jaredt - appreciated 😊 Kind regards, Anders

[@tracy_dtc]

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

[@andersjensenorg]

Hey Tracy. Thanks a lot for taking your time to comment 🙂 I'll do more videos on the AI Builder and one of the engineers even offered to appear in one of them and help with questions. Kind regards, Anders

[@notinvolver]

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

[@andersjensenorg]

Thank you so much, Notin. I think it's time for a V2 😀 Kind regards, Anders

[@marcofilonzi8965]

The content of this video is really valuable ! Well done, many thanks !

[@andersjensenorg]

I'm so glad to hear, Marco - thanks 😊 I should create a new version soon. Kind regards, Anders

[@hostile_technics]

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

[@andersjensenorg]

I'm so happy to hear, thanks a lot 🥳🙌 Kind regards, Anders

[@stevenmicah8558]

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

[@andersjensenorg]

Steven! I'm so glad to hear, thanks a lot 😊🙌 Kind regards, Anders

[@otm777]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@hengmakara9718]

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

[@andersjensenorg]

My pleasure, thanks for the nice comment 😊

[@mtzmty]

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

[@andersjensenorg]

Hey Jorge. Thanks a ton 😎😍 Have you seen my newest, and most advanced, AI Builder video: kzbin.info/www/bejne/j2m6o6qMmbKcgMk Kind regards, Anders

[@mtzmty]

@@andersjensenorg already in my to do list for later this afternoon. This is great. Thank again !!!

[@andersjensenorg]

Thanks again 😊

[@agraharafamily5634]

Great resource. Thank you Anders for sharing this.

[@andersjensenorg]

You're very welcome, @agraharafamily5634 - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE

[@Payton-Prescott]

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

[@andersjensenorg]

So great, Payton 🙏🔥 How reliable do you find it? Kind regards, Anders

[@Payton-Prescott]

​@@andersjensenorg Hi Anders, very reliable I must say!

[@moloydey521]

Thanks for such a good tutorial

[@andersjensenorg]

My pleasure 😊 Kind regards, Anders

[@Pcontracts83]

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

[@andersjensenorg]

Nice 😀 Feel free to update about the process!!

[@chrisbare4547]

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!

[@andersjensenorg]

Thanks a lot, Chris Bare 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5300+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@ismailalcheikh8925]

I hope you were able to figure things out. Working on the exact same thing. Would you be able to share learning links please? Thanks

[@gregNFL]

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

[@andersjensenorg]

Thanks a lot, Greg F 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@totemimaging]

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

[@andersjensenorg]

You're very welcome, Anthony and thanks a lot for taking your time to write a comment. Let me know how your project goes 🙂

[@thedon8210]

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

[@andersjensenorg]

Haha, du er meget velkommen thedon8210 - jeg tænker ikke, jeg behøver lave et engelsk svar også 😊😍

[@paultran8161]

very good tutorial Anders

[@andersjensenorg]

Thank you so much, Paul 🙏

[@novascotian]

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?

[@andersjensenorg]

Many thanks - yeah it went a little fast, sry 😞

[@AshutoshKumar-tk1lm]

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

[@andersjensenorg]

You're very welcome, Ashutosh - are you gonna try yourself?

[@AshutoshKumar-tk1lm]

@@andersjensenorg yes

[@muhammadarbazbashir8783]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@stanTrX]

Looks good.any open source alternative?

[@EnormousKingCrab]

Great video, thanks!

[@andersjensenorg]

Many thanks 😊🙌

[@prasaddumbre560]

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

[@andersjensenorg]

You're very welcome, Prasad Dumbre - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE

[@ridingnorthernlights]

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... ;-)

[@andersjensenorg]

You're very welcome, ridingnorthernlights - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 7000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE

[@ridingnorthernlights]

@@andersjensenorg Subscribed! Looking forward to seeing more.

[@timoliver9892]

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

[@andersjensenorg]

Hey Tim. Thank you 🙂 Exactly (the last part of Today's video covers that). Kind regards, Anders

[@yossilouk8479]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@jonathan1q2w3e4r]

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

[@andersjensenorg]

Not yet, but it's in the pipeline for next week 😊🙋‍♂️

[@phucngo1199]

I think it looks like a mistake at 26:52 when you mistakenly replace the last squared bracket to Quantity from value. Isn’t it supposed to replace the first squared bracket from Item to Quantity instead? I see that the result at the end of this video has the Item name repeating twice and it misses the Quantity field. Can you please show me how to have different field in the table to be in different column in the excel file.

[@bigheadwu1735]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@golamrafibadhon2549]

Great video, Do you have any information on costs? For power automate and Ai builder both?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@TrassBI]

Thanks for sharing! Very helpful video🙂

[@andersjensenorg]

You're very welcome, Trass - I have a lot of Power Automate videos coming up 🙂

[@AdiCristea]

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]

Thanks a ton, Adi, for clarifying. Let me know, if you see something similar again 🙌🙂

[@t.a.n.e.s.h]

@@andersjensenorg Great vid! I also made the same observation and corrected as per Adi's suggestion. Unfortunately only one row got added to the Excel with a null value for OurItems. Will need to dig deeper to figure out what's wrong with the expressions.

[@kevinmctarsney36]

@@t.a.n.e.s.hI had the same issue. In the video I noticed a second "Apply to each" that wasn't in the first run of the flow before trying to break out the BurgerItem table detail. The fx had 'apply_to_each_2'. My flow errored on that when saving. I changed them to 'Apply_to_each' and the flow saved, ran, but didn't populate the OurItems column. Update: Figured it out! There is, indeed, a second 'Apply to each'. I added it right after the 'Extract info from forms' action then dragged the 'Add a row...' up into t for the four BurgerItems in the JSON. Worked just like the video.

[@gregzschaschel7472]

Hi Anders, this is very helpful tutorial. I keep running into issues minute 26:12 of the video. I keep getting the following error, please help "Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'Appy_to_each_2' referenced by 'inputs' in action 'Add_a_row_into_a_table' are not defined in the template.'.'.

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@pmd7530]

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?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@xristoforossolomonides784]

Hey great video. Did you ever do the video about the unstructured data/pdf files? I searched the whole internet and i still cannot find a good way to do it. This videos is as close as one can get but still not enough for the harder more demanding files. Have a great day!

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@ashishkahu3673]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@rwfrench66GenX]

Great video, thank you very much! I know you said this will work on PDF, png or jpg but on PDF if the file is scanned as an image instead of a document will this still work? I work in AP at a large healthcare company and usually I use Power Query to import PDF’s but when I get PDF’s from our imagers the PDF is an image so I need to take a screenshot and use the image to text feature in Excel and it takes a long time to clean the data.

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@syedumair422]

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 ?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@manikrishnanayinala6888]

Thanks Greate explain

[@andersjensenorg]

I'm glad to hear, kind regards, Anders 😊

[@sandeept8676]

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

[@Datascience-Bigdata-MathsDS]

I need thé answer too

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@martineikmeier]

Very nice. Thank you!

[@andersjensenorg]

A pleasure - thank you 😊

[@liaohsiang2603]

Love it. It works

[@andersjensenorg]

Hey liao hsiang. Thanks a lot 😊 Have a great day. Kind regards, Anders

[@luisespina3256]

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.

[@andersjensenorg]

Hey Luis. Thanks a lot. I will then do a loop like here: kzbin.info/www/bejne/j2m6o6qMmbKcgMk 😊 Kind regards, Anders

[@alexanderbitschi7623]

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

[@andersjensenorg]

Hey Alexander. Quick answer: I do it in this video (grap the filename): kzbin.info/www/bejne/j2m6o6qMmbKcgMk Kind regards, Anders

[@alexanderbitschi7623]

Perfect - thanks for your feedback.

[@Karthi_Max]

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?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@julianvigo_]

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

[@andersjensenorg]

Hey Julián Vigo Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@ranjanroy1623]

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 !

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@zedzeduk]

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?

[@andersjensenorg]

Hey zedzeduk, then I would use the invoice processing. The forms processing are great, when it's structured data (all PDFs the same), but not when unstructured (e.g. different vendors). Thanks a lot 🤗

[@josephdaquila2479]

Can't you just set up email rules? And then run different processes depending on which folder the invoice ends up in? Edit: nevermind this youtube video owner is right you'd have to set up different training models

[@drsharanthapa]

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!

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@drsharanthapa]

@@andersjensenorg appreciate thank you !

[@drsharanthapa]

@@andersjensenorg appreciate thank you !

[@MyTravelFlashBack]

Thank you for this video

[@andersjensenorg]

You're very welcome, Akshay. I'm happy you could use it :)

[@rajkumarm8088]

Your so detailed ! SUBBED

[@andersjensenorg]

Thanks a ton, Rajkumar 😊 Have you seen my video from Yesterday: kzbin.info/www/bejne/j2m6o6qMmbKcgMk where I show, how to easily do KYC checks with Power Automate AI Builder. It's still hidden (will premiere in a week or so), but you can find it through the link. Kind regards, Anders

[@samaruti9446]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@checkidout]

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?

[@andersjensenorg]

Hey ADASTRA MAN Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@manhtadong942]

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!

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@richboiii17]

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?

[@andersjensenorg]

Hey Ricardo Tay Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@andersjensenorg]

Hey Ricardo, sorry for the autoresponse. Yes, for sure - I'll create a video around that 😊

[@BraeFrogs438]

@@andersjensenorg I am also looking for this information, Thanks!!

[@sundeepthota5976]

Hello @@andersjensenorg, Greetings! Is there any Video around unstructured data in PDF file?

[@partththombre7446]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@martinlynch8548]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5300+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@nathenluu9573]

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 .

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@kellymartinovitch2034]

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.

[@andersjensenorg]

Thanks a lot, Kelly. You can either use the Substring function or the Substring action (I prefer the first mentioned). If you need help appliying it, please just post your problem on my Discord (with a screenshot) and we'll solve it. The Discord is ofc free and the link is in the description 😊

[@kellymartinovitch2034]

@@andersjensenorg Can I just retrain my model and only grab the numbers? I don't know what substring function means...LOL I will post to your Discord

[@gilbertflores3101]

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?

[@andersjensenorg]

Thanks a ton, Nicolás Lupo 🤩 Have a great day. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@ouaklikenza2223]

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

[@andersjensenorg]

Hey ouakli kenza Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@k-lida7793]

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?

[@andersjensenorg]

Hey K-Lid A Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@ebenezerasare9934]

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

[@andersjensenorg]

Hey Ebenezer Asare Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@andersjensenorg]

ANd yes 😀

[@AAKINify]

Great video!

[@andersjensenorg]

Thanks a lot, Adem 🙂

[@jamblerx69]

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.

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@camillasommer3326]

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?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@blooperioo]

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

[@andersjensenorg]

Hey blooperio. Microsoft will be launching AI Builder in Power Automate Desktop soon (it's currently ik preview). Kind regards, Anders

[@polevo]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@ivalneisena]

Very good

[@andersjensenorg]

Thanks a lot, Ivalnei! 😊

[@ankitshekhar9317]

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.

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@IrfanAbdulRahman-ky1wh]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@manikrishnanayinala6888]

Thanks Greate explain brother' 12:14 12:14

[@andersjensenorg]

Hey @manikrishnanayinala6888. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@vinayrane2008]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@stephanieparas8533]

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?

[@andersjensenorg]

Hey Stephanie Paras Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@cjquispe]

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

[@andersjensenorg]

Hey Carlos, not yet 😐 What kind of data are you looking to automate? Kind regards, Anders

[@johnmcgregor4268]

do you have a video for unstructured data?

[@andersjensenorg]

Hey John. Have you seen this with Joe: kzbin.infotmxvLAT3C7s Kind regards, Anders

[@johnmcgregor4268]

@@andersjensenorg can you do a video showing how to connect chat GPT to your outlook to draft email responses that can be reviewed and sent?

[@samiseddiki9598]

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?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@a2kashyap]

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

[@andersjensenorg]

Hey Abhishek Aditya Kashyap Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@michaelbarber5651]

Did they do away with AI builder? I see AI Hub and I see AI models?

[@rajat13777]

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

[@andersjensenorg]

Hey Rajat Sharma Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@reinacp140]

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?

[@andersjensenorg]

Hey Reina CP Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@francosepulcri4283]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@arunsivakannan6007]

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

[@andersjensenorg]

You can create an approval flow: kzbin.info/www/bejne/aXfJlH6LmdF-gZo 🙂

[@ZEDMED-UKLTD]

This is exactly what i wish to do but for some reason on my home page of power automate i don't the option for AI builder, is it because i am using free trial period

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@rocknrollwoodworker]

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?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@ItsAlreadyDone]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@pradyumnakumarprusty3301]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5300+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@AkhtarHussain-ct2hr]

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.

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@MyTravelLife1000]

Hi please share the video name for unstructured doc processing

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@ThaRepok]

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?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@jiteshpillai7166]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@ShitalMali-th7ps]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@radumelian9934]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@sirishayerramasu2631]

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?

[@andersjensenorg]

Hey sirisha yerramasu Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

[@harshchovatiya-gh7hn]

my date output is come in "2024-07-08T00:00:00Z" this way. i need only 08-07-2024. in my pdf its also like this. please guide

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@mustakali6459]

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

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders