Did this video help you? You can help me, and my channel, a lot by giving it a thumbs up 👍🙂 Full Power Automate Playlist: ruclips.net/p/PLXXz88_TPiHqGlJoWhBDCAxZ9m1N_jsB6
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: ruclips.net/video/xWFz-S96XGo/видео.html
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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!
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!!!
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
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?
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.'.'.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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!
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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: ruclips.net/video/xWFz-S96XGo/видео.html
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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?
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 🤗
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
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 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.
@@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.
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.
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!
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
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 ?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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!
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: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
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!
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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.
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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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?
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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
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
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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
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?
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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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 !
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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??
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Thanks for this video it solved the half of my problems. I have tryed all over RUclips 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 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, 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!!
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.
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 😊
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?
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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
@@andersjensenorg Oh no.. I forgot to say just how great the rest of it is! I watched several of your videos now, including a 2hr. one, and it was just the primer I needed to get started in PA. Thanks!
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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: ruclips.net/video/xWFz-S96XGo/видео.html
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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?
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: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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
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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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: ruclips.net/video/xWFz-S96XGo/видео.html
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 ??
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, 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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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?😮
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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?
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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
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!!!
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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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?
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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
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.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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 for all your support 🙌🔥
My most advanced AI Builder video: ruclips.net/video/Y8WrwVdMiJg/видео.html
Thank you! I may have more questions for you on my power automate journey. This is very powerful stuff.
I came across this video in 2024 and all the knowledge in this video is still helpful for me. Thanks a lot Jensen
I'm so glad to hear, thanks a lot - I should do a remake soon 😊🙌 Kind regards, Anders
Did this video help you? You can help me, and my channel, a lot by giving it a thumbs up 👍🙂 Full Power Automate Playlist: ruclips.net/p/PLXXz88_TPiHqGlJoWhBDCAxZ9m1N_jsB6
You have the best Video on this Topic ,even Microsoft would envy this !
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: ruclips.net/video/xWFz-S96XGo/видео.html
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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!
Thank you so much, Jaredt - appreciated 😊 Kind regards, Anders
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!!!
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
You are my favorite content creator for this subject matter. Please continue to be great
I'm so happy to hear, thanks a lot 🥳🙌 Kind regards, Anders
Amazing content Anders, I've found you about a year ago now and your videos are hands down best in class. Keep it up 👍🏻
Thank you so much, Notin. I think it's time for a V2 😀 Kind regards, Anders
The content of this video is really valuable ! Well done, many thanks !
I'm so glad to hear, Marco - thanks 😊 I should create a new version soon. Kind regards, Anders
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?
Many thanks - yeah it went a little fast, sry 😞
This is the best tutorial! My whole office now essentially runs off of this! Thank you so much!!
Steven! I'm so glad to hear, thanks a lot 😊🙌 Kind regards, Anders
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.'.'.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
VERY clearly described, thank you. However, I don't have BUILD as an option under AI Builder - is EXPLORE the same thing as BUILD?
Hey Tim. Thank you 🙂 Exactly (the last part of Today's video covers that). Kind regards, Anders
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
I need thé answer too
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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
So great, Payton 🙏🔥 How reliable do you find it? Kind regards, Anders
@@andersjensenorg Hi Anders, very reliable I must say!
Thank you. i love it.
could we do it from PDF that arrived as an attachment via outlook automatically?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
This is a fantastic video. finally I found it. Thank you Anders for this sharing.
My pleasure, thanks for the nice comment 😊
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!
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Did you make the unstructured data video you had mentioned yet?
Not yet, but it's in the pipeline for next week 😊🙋♂️
Great resource. Thank you Anders for sharing this.
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: ruclips.net/video/xWFz-S96XGo/видео.html
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hi Anders, thanks for the video. One question: how can I add the Filename to the Exceltable? Many thanks in advance.
Hey Alexander. Quick answer: I do it in this video (grap the filename): ruclips.net/video/Y8WrwVdMiJg/видео.html Kind regards, Anders
Perfect - thanks for your feedback.
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?
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 🤗
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
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!
Thanks a ton, Adi, for clarifying. Let me know, if you see something similar again 🙌🙂
@@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.
@@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.
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.
Not sure yet how I missed this video before. This is really great stuff. Thank you Anders for sharing and please keep it coming
Hey Jorge. Thanks a ton 😎😍 Have you seen my newest, and most advanced, AI Builder video: ruclips.net/video/Y8WrwVdMiJg/видео.html Kind regards, Anders
@@andersjensenorg already in my to do list for later this afternoon. This is great. Thank again !!!
Thanks again 😊
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!
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
@@andersjensenorg appreciate thank you !
@@andersjensenorg appreciate thank you !
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 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Great video, Do you have any information on costs? For power automate and Ai builder both?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Would it have worked if you sent that test email from outlook desktop?
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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
ANd yes 😀
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 ?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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!
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: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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 :/
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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
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!
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
very good tutorial Anders
Thank you so much, Paul 🙏
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.
Hey Luis. Thanks a lot. I will then do a loop like here: ruclips.net/video/Y8WrwVdMiJg/видео.html 😊 Kind regards, 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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Thanks for such a good tutorial
My pleasure 😊 Kind regards, Anders
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.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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?
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: ruclips.net/video/_QRI-Yo2h8U/видео.html
Have a great day.
Kind regards,
Anders
Hey Ricardo, sorry for the autoresponse. Yes, for sure - I'll create a video around that 😊
@@andersjensenorg I am also looking for this information, Thanks!!
Hello @@andersjensenorg, Greetings! Is there any Video around unstructured data in PDF file?
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
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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
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?
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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
may i ask for the last part, how would you be able to separate it on different columns?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Mange tak for denne video ! Det hjælper rigtig meget!
Thanks for this video, it help me a lot!!
Haha, du er meget velkommen thedon8210 - jeg tænker ikke, jeg behøver lave et engelsk svar også 😊😍
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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 !
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Looks good.any open source alternative?
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??
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Thanks for this video it solved the half of my problems. I have tryed all over RUclips 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 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
This is MAGNIFICENT! can't wait to try it on our buisness case.
Nice 😀 Feel free to update about the process!!
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!!
You're very welcome, Anthony and thanks a lot for taking your time to write a comment. Let me know how your project goes 🙂
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.
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 😊
@@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
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?
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: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders
do you have some video with made the same but with unstructure data? plz thx
Hey Carlos, not yet 😐 What kind of data are you looking to automate? Kind regards, Anders
It goes really fast after 24:00. Without any experience with JSON or the formula syntax, it's daunting. I was lost there.
I'm sorry, I will try to clarify it in coming videos 😐 Kind regards, Anders
@@andersjensenorg Oh no.. I forgot to say just how great the rest of it is! I watched several of your videos now, including a 2hr. one, and it was just the primer I needed to get started in PA. Thanks!
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Nicely done. This will help flatten the learning curve. Thank you!
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: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
do you have a video for unstructured data?
Hey John. Have you seen this with Joe: ruclips.net/user/livetmxvLAT3C7s Kind regards, Anders
@@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?
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 .
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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
You can create an approval flow: ruclips.net/video/3FfcKUdlKK8/видео.html 🙂
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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Great Post, looking forward to more such videos. Thank you :)
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: ruclips.net/video/xWFz-S96XGo/видео.html
Hello, is the AI Builde only accesible with web version? I can't seem to find any AI Builder in the App version
Hey blooperio. Microsoft will be launching AI Builder in Power Automate Desktop soon (it's currently ik preview). Kind regards, Anders
Can we train a model for PDF extraction if there are some different types of invoices ?if yes please let me know it works.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
thank you for video, Its really helpful to learn AI builder in PA 🙂
You're very welcome, Ashutosh - are you gonna try yourself?
@@andersjensenorg yes
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?
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: ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hi, do you think it's possible to standardize the field and table placements for all of the PDFs?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
I have tried this flow, but it is considering mail body content as well and showing error not unsupported type.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Is there a way so teach the AI to do it with a document that contains more than 50 pages with the same format?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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
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: ruclips.net/video/_QRI-Yo2h8U/видео.html
Have a great day.
Kind regards,
Anders
Hi please share the video name for unstructured doc processing
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
17:33 Extract Information from forms is no longer exist. it's change to Extract Information from documents
Thansk a ton, Name RANDOM! 🙂👋
Thanks for sharing! Very helpful video🙂
You're very welcome, Trass - I have a lot of Power Automate videos coming up 🙂
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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... ;-)
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: ruclips.net/video/xWFz-S96XGo/видео.html
@@andersjensenorg Subscribed! Looking forward to seeing more.
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 ??
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, 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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
is there any flow to remove the matadata (properties) from PDF?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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?😮
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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?
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: ruclips.net/video/_QRI-Yo2h8U/видео.html
Have a great day.
Kind regards,
Anders
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!!!
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: ruclips.net/video/_QRI-Yo2h8U/видео.html
Have a great day.
Kind regards,
Anders
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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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??
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
dumb question but i cant get past the first step i do not dee ai builder any where on the menus...?
Hey Residential. Do you have a trial environment or are you in an organization? Kind regards, Anders
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?
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: ruclips.net/video/_QRI-Yo2h8U/видео.html
Have a great day.
Kind regards,
Anders
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.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Quick question; when testing OurItem either doesn't populate or it populates with the raw code again. What do I do?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Great video, thanks!
Many thanks 😊🙌
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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
if we need to get more data for same pdf what to do then
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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?
Hey klceve. Unfortunately not. Kind regards, Anders