Document Processing with AI Builder in Power Automate

Learn how to use the AI Builder in Microsoft Power Automate. Today's live showcase is about easily doing document processing by combining Power Automate and AI Builder.
Today's guest is Joe Fernandez, Product Manager at AI Builder.
CONTACT JOE:
💼 LinkedIn: / fernandezjoe
🐦 Twitter: / fdezjose
🗣 AI Builder Community Forum: powerusers.mic...
VIDEOS FOR YOU:
🔹 Power Automate Beginners Guide: • How to Learn Microsoft...
🔹 Extract PDF Data with Power Automate: • How to Extract Data fr...
👨‍👩‍👧‍👦 Discord: / discord
Join my network with 3500+ RPA Developers, where we solve RPA problems, network, and help each other upgrade our careers. It's free!
FOLLOW ME:
💼 LinkedIn: / andersjensenorg
📸 Instagram: / andersjensenorg
👨 Facebook: / andersjensenorg
🐦 Twitter: / andersjensenorg
💌 Email Newsletter: andersjensen.o...
MY MONITOR (Amazon affiliate):
🖥️ Samsung 49-inch CRG9 Curved Monitor = geni.us/MDpejc
If you are buying this, I can recommend the Mi Monitor Light Bar = geni.us/3Wwad
#microsoft #powerautomate #aibuilder

[@andersjensenorg]

Thank you again Joe for this opportunity 🙌🔥 LIKE AND SUBSCRIBE IF YOU ENJOYED!

[@tylerrichardson3869]

Well done gentlemen! This video is clear and concise whilst being comprehensive. I am from a suburb of Chicago, IL. USA and must admit this video is far superior to anything that has been done by the content creators in the USA. USA creators are more concerned with their own personal appearance and how their videos are edited. This video was focused around the content and explanation of said content. Thank you very much Anders and Joe for making this video.

[@andersjensenorg]

Wow, thanks a lot, Tyler 😍 Much appreciated - this one is a bit more polished (hopefully it doesn't go into your second catetory): kzbin.info/www/bejne/j2m6o6qMmbKcgMk a step-by-step example you can build yourself 🙂 Kind regards, Anders

[@hduluard]

Thank you for this very informative video and demo. I learned much from watching and feel confident to try this feature myself.

[@andersjensenorg]

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

[@TH-fe1vs]

FANTASTIC video, thanks.

[@andersjensenorg]

I appreciate it, thanks x1000 😊🙌 Kind regards, Anders

[@HammamDisini]

Great discussion. Thank you for sharing this.

[@andersjensenorg]

Our pleasure, Hamman 😊

[@padynz9869]

Thank you very much for a highly informative session🙏

[@andersjensenorg]

My pleasure, Pady 👍🙏 And kudos to Joe!

[@MoisesLopez-k9i]

Great video! It’s been a year did we get multi page support yet ? And did you happen to create a video for it? I can’t seem to get my multi page documents read correctly 😅

[@The_Sunrisers-c7q]

This is really very helpful. I just want to ask what is the minimum number of documents required to put into 1 collection so that the accuracy of extraction is more perfect.

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

[@jose00033]

Would there be another demo like this one? This is really useful!

[@andersjensenorg]

Hey Jose, thanks a lot. Have you seen this: kzbin.info/www/bejne/j2m6o6qMmbKcgMk Kind regards, Anders

[@malkotia12]

great presentation. Many thanks. Can we review data extracted by model and then review the information and give a feedback to the model based on corrections manually done.

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

[@Cookies2069]

Thank you for this powerful video

[@andersjensenorg]

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

[@MichaelMeighu]

This is really great! Would be great to see a video on how to place the extracted values from the PDF instead to a Table in a spreadsheet - but to columns in a sharepoint library.. If this tutorial exist - please let me know! 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 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

[@kevinjoseph9023]

Thank you for all the help with these videos. I have now fashioned a solution that automatically processes invoices using this platform. The customer is very happy with the solution. I now need to fashion a service agreement and could use some advice. A customer is a midsize government agency of about 300 people they process nearly 2000 invoices, here is my question how much should I charge the customer for servicing the solution on a monthly basis? I’m just looking for a ballpark figure.

[@andersjensenorg]

Hey Kevin, thanks a ton for the nice comment - It's impossible for me to anwer, but have you tried my discord community (we're 8000 RPA developers helping each other), it's of course free. The link is in the description, Kind regards, Anders

[@vitaminservice_]

Great, great video!

[@andersjensenorg]

Thanks a bunch, Vitamin 💯🙌

[@paulramirez7792]

Great stuff! Does anyone know if you have to create a different custom model for each sales order layout?

[@lindal8596]

No you do not - you'd be surprised how far AI has come - just upload less than 50 documents even if they are different in their field placement to extract and then review each document 1 by 1 to make sure the tags are placed correctly. I just did this 2 days ago on a batch of 40 disparate docs and it worked very well.

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

[@fabianaltendorfer11]

Great introduction!

[@andersjensenorg]

Thanks a lot, Fabian 👍😊

[@mohammedghouse722]

Hi Anders Jensen, Which RPA tool is best to learn & get job quickly. UiPath or Power Automate ?

[@andersjensenorg]

Hey Mohammed. It depends on where you live. I can recommend looking at the job posts in the area, you want a job. See what tool they prefer. And there you have your answer 🙂 Kind regards, Anders

[@edjk6278]

Thanks for the video. I have a question. I am trying to perform math with output from AI builder but I cannot convert the data type to integer using int( ). Is this possible?

[@andersjensenorg]

Hey EDJK, are you sure the source is in integer format only (and not with . or a letter)? Please post the problem on my Discord with a screenshot of the source data, if the problem persists - the link is in the description below. Kind regards, Anders

[@annapurnabonakurthi9174]

Thanks for the Video. Is it possible to add aplha numeric variable in the custom model in Power Automate.If oour Document contains the Apha numeric variable.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 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

[@TheMKTube]

Is there a way to extract information from a structured fillable form without using the premium AI connectors? For example, how about extracting information from a PDF using Power Query and attaching the online version of that excel file to Flow to process each time a new row is added?

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

[@nithishkrish3442]

​@@andersjensenorg while adding a row in to table in Excel online business I need table name what is that table name

[@shirleialexandrinodosanjos4538]

Thank you Anders and Joe . I have this cenário in my work but the pdf page size is in portrait and didn't work. How i could solve this?

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

[@shirleialexandrinodosanjos4538]

Thank you @@andersjensenorg

[@davidsalas5756]

Quick question. I have a subscription for RPA Power Automate, which includes 5000 units, if I recall. Anyway, when building a custom model, I don't see the experimental option for Multi-Table support. I have gone to my Power Automate Settings and turned on preview features, but still no luck. I also went into my Power Apps Environment and made sure that the Preview Features were turned on for said environment. Any idea on what I could be missing?

[@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 4900+ 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

[@Riya_0309]

Hii @anders jensen ,is it possible to use trained AI model (power automate) in python code by API call? please conclude my question

[@andersjensenorg]

Hey RIYA TECH (its your vinny) 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

[@hernanmauricioperezmunoz4937]

Best Anders, I got a problem using Oracle connector to execute a begin transacction script. Do you have any tutorial to do? Thanks so much

[@andersjensenorg]

Hey hernan mauricio perez muñoz 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

[@femij9028]

Please how do I adjust the FLOW to trigger the data extraction once the status of the added document on the Sharepoint is "Approved"

[@andersjensenorg]

Hey Femi J 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

[@vishalwattamwar9592]

Where collection file gets stored ? How to move AI Builder from Dev to Production Environment ?

[@andersjensenorg]

Hey vishal wattamwar 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

[@bidhanghimire6868]

I'm having issues with tagging. Although the default tags are applied correctly, they do not appear as tagged during the training step. When I return to address the issue, it prevents me from proceeding to training; I have to manually untag and re-tag those values before I can move to the training stage. Can anybody please provide suggestions?

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

[@SarahKhan-dt2dp]

What all licenses do I require if I have 600 pdfs to extract?

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

[@jallabalaram4331]

Hi. I try to extract data from same table having more than one page. Currently I am getting only first page table data. Please help on this issue.

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

[@RDBclub40]

How to get specific data extracted if a ✔️ is selected against it?

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

[@RDBclub40]

@@andersjensenorg Thanks

[@Chennu-zz5me]

@andersjensenorg How to extract couples of invoices data from a folder in single flow?

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

[@sempaxbolong6259]

It lack features of document splitting/separation.

[@andersjensenorg]

That topic got asked a couple of times during the session - it's just around the corner 😊

[@sempaxbolong6259]

@@andersjensenorg Maybe they will release it in 2024, who knows...

[@thalapanenirakesh8459]

How to find entire document confidence score

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

[@valpere1892]

I cannot understand anything this man says... waste of my time

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