No video

Advanced Invoice Processing with AI Builder in Power Automate Desktop

  Рет қаралды 18,627

Anders Jensen

Anders Jensen

Күн бұрын

Пікірлер: 51
@andersjensenorg
@andersjensenorg Жыл бұрын
Thanks for all your support 🙌🔥 I've prepared these Advanced Power Automate Desktop Use Cases for you: kzfaq.info/sun/PLXXz88_TPiHqbQENjPjBkO3DSro06cAcb
@nathangoel8894
@nathangoel8894 4 ай бұрын
thanks Anders, your content is awesome
@andersjensenorg
@andersjensenorg 4 ай бұрын
I'm so happy to hear 😊 Thanks a lot, kind regards, Anders
@ammadkhan4687
@ammadkhan4687 Жыл бұрын
This is the exact solution I was looking for. Many thanks for your effort
@andersjensenorg
@andersjensenorg Жыл бұрын
Hey Ammad - thanks a lot for letting me know, highly appreciated 🙌💪 Kind regards, Anders
@indeotelsonline
@indeotelsonline 7 ай бұрын
Hi Anders , Thanks for wonderful video , i implemented in same way what you explained me , could you help how we can get line item details from AI Builder table , it is showing Line Item variables but how we can pass in JSON ?
@andersjensenorg
@andersjensenorg 7 ай бұрын
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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@dadicam
@dadicam 10 ай бұрын
Nice video! I got a question, do you know when Microsoft team will add "signature detection" field type in ai builder form recognition custom model creation?
@andersjensenorg
@andersjensenorg 10 ай бұрын
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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@calvinjeng
@calvinjeng Жыл бұрын
If my files are stored in the C:\users\desktop\invoice folder, not in the cloud Which steps should be omitted? Thank you
@brijendraydv
@brijendraydv Жыл бұрын
@@anjugunakar what's his server name or how to find on discord?
@andersjensenorg
@andersjensenorg Жыл бұрын
Hey calvinjeng 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: kzfaq.info/get/bejne/lbeCfJCK1JjMaIk.html Have a great day. Kind regards, Anders
@edtignor4235
@edtignor4235 Жыл бұрын
If you have to tell PA (Power Automate) where the files are in the cloud, why not just create a PA flow that runs when it detects a new file in the folder. That's my current setup. I save the PDF to the OneDrive folder on my desktop, it uploads to the cloud, the PA flow is triggered, AI bot extracts my info, then it calls a PAD (Desktop), flow on my laptop and sends the extracted information as input variables for my PAD flow. I also have a sub flow in PAD which creates a new folder on my laptop for the PDF and removes it from the OneDrive folder. The PDF is a real estate contract, so each PDF needs its own file for other information that is needed with a real estate closing.
@andersjensenorg
@andersjensenorg Жыл бұрын
Hey Ed. Great question. Because the process is used with Windows Legacy apps, which Cloud can't use 🙂 Kind regards, Anders
@nguyentrunganhtrung.anh.ng2070
@nguyentrunganhtrung.anh.ng2070 Жыл бұрын
Hi! Thanks for the video. Can I apply this on Power Automate cloud? Thanks
@andersjensenorg
@andersjensenorg Жыл бұрын
Hey Nguyen, yes it's already integrated in PA Cloud 🙂
@buryats_usa
@buryats_usa Жыл бұрын
Is it a paid service (AI invoice recognition)? How much for how many runs?
@andersjensenorg
@andersjensenorg Жыл бұрын
Hey Zorikto. Yes, but for private use we can have it for free (my version is a trial). Kind regards, Anders
@nickvanoort9609
@nickvanoort9609 Жыл бұрын
Nice and helpfull video! I do have one question: Is there a workaround to only pick one file from sharepoint? If I upload only one file then I cannot use %Invoice.Path% in the 'Invoke web service' action. The reason I am asking this is because of the data my AI Builder model extracts from the documents. It contains data insides tables which are put into collections. Therefore I cannot select them in the 'Response' action in de Cloud flow. I get this error: "The output you selected is inside a collection and needs to be looped over to be accessed. This action cannot be inside a foreach." So, I need to find a way to workaround the foreach. I am stuck at this point as I need all the data extracted by the AI Builder. Hopefully you have a idea :)
@andersjensenorg
@andersjensenorg Жыл бұрын
Hey Nick van Oort 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: kzfaq.info/get/bejne/lbeCfJCK1JjMaIk.html Have a great day. Kind regards, Anders
@user-tw2un7fy5m
@user-tw2un7fy5m 9 ай бұрын
HI, thank you for this video. I wanted to know do I need a Power Automate Premium Plan to try this Advanced Invoice Processing or is there a any free plan for developers to try this.
@andersjensenorg
@andersjensenorg 9 ай бұрын
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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@datalevi
@datalevi Жыл бұрын
Do you have other resources to start learning about AI?
@andersjensenorg
@andersjensenorg Жыл бұрын
Great question and sorry about the late reply. In regard to RPA and Power Automate, I would focus heavily on Document Processing (text processing), and here the AI Builder is the number one approach. Kind regards, Anders
@myousefi6600
@myousefi6600 11 ай бұрын
Hey Lovee your work, I have a question and haven't been able to find an answer. How can I retrieve items from descriptions that aren't unique, such as quantity, item description, etc.? I suspect they need to be iterated over, assigned to a variable, and then passed to the JSON object. However, I've had difficulty implementing this
@andersjensenorg
@andersjensenorg 8 ай бұрын
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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@sempaxbolong6259
@sempaxbolong6259 Жыл бұрын
Cons : - Need to install onedrive app in pc, file input rely on sync. - Consume api rate limit everytime you execute invoke webrequest from PAD, because this method using on http request received action trigger from cloud flow. - Not good for processing thousand of documents. (api rate limit/slowness) - Invoke webrequest does not upload the file directly, its just supplying the file name from one drive All of this cons will be eliminated if we are using azure form recognizer api.
@andersjensenorg
@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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@maleenonline
@maleenonline 4 ай бұрын
Is there a way to collect QR code data into a Excel spreadsheet?
@andersjensenorg
@andersjensenorg 3 ай бұрын
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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@user-zh4id3df8l
@user-zh4id3df8l 10 ай бұрын
hii Anders ,do you know how to get filename to excel dynamically in cloud power automate
@andersjensenorg
@andersjensenorg 10 ай бұрын
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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@wamiqsattar
@wamiqsattar 9 ай бұрын
@wamiqsattar 0 seconds ago I am using Power Automate Desktop and want to execute "GPUPDATE /FORCE" on the CMD Prompt window. This will send the command to regular CMD prompt window, but not to the Admin CMD prompt window. So, how can I invoke CMD prompt window with Admin rights and do the "GPUPDATE /FORCE". Most of my work will require Power Automate Desktop to operate in CMD Prompt window with ADMIN RIGHTS? Thank you.
@andersjensenorg
@andersjensenorg 9 ай бұрын
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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@roshanmk007
@roshanmk007 Ай бұрын
How to extract line items like QTY
@andersjensenorg
@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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@vygintasgrinis3913
@vygintasgrinis3913 5 ай бұрын
Great videos, Anders!!! Everything works for me, I get a response that FileName was processed. However after adding "Get file metadata using path" and running the flow I get an error. {"error":{"code":"NoResponse","message":"The server did not receive a response from an upstream server. Request tracking id '08584905007209957731683973228CU99'."}} Anyone ran into the same issue?
@vygintasgrinis3913
@vygintasgrinis3913 5 ай бұрын
when i check power automate cloud the error i get is: { "status": 404, "message": "The resource could not be found.", "source": "api.connectorp.svc.ms" } i thougt maybe it is related with one drive, but it gives response when i dont use "get file metadata using path"
@andersjensenorg
@andersjensenorg 4 ай бұрын
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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@chavvasrilatha9980
@chavvasrilatha9980 Жыл бұрын
i am not able to get an option "extract information from invoices". i can use ai builder in my account. but in the middle of the flow not able to access ai builder operations. do i need to get any permissions.
@andersjensenorg
@andersjensenorg Жыл бұрын
Hey Chavva Srilatha 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: kzfaq.info/get/bejne/lbeCfJCK1JjMaIk.html Have a great day. Kind regards, Anders
@MsKaryn
@MsKaryn Жыл бұрын
For some reason, I can't get past the flow error "Not Found". The path name is correct as it shows up the way I want it in the Display. The files are PDFs and do exist in the folder path I'm sending. The files are just never found. Does file type matter? I watched this video over and over following it to a T and still can't get it to work. The error coming back in Result and WebServiceResponse = {"error":{"code":"NoResponse","message":"The server did not receive a response from an upstream server. Request tracking id '08585209595401517484192995827CU103'."}}
@andersjensenorg
@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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@MUHAMMADSOHAIL-cx2rl
@MUHAMMADSOHAIL-cx2rl Жыл бұрын
Dear , i am getting below error: error":{"code":"NoResponse","message":"The server did not receive a response from an upstream server.
@andersjensenorg
@andersjensenorg Жыл бұрын
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@baldeepsinghnagi8943
@baldeepsinghnagi8943 Ай бұрын
Getting this error: {"error":{"code":"DirectApiAuthorizationRequired","message":"The OAuth authorization scheme is required. Please add authentication scheme and try again."}}
@andersjensenorg
@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): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@baldeepsinghnagi8943
@baldeepsinghnagi8943 Ай бұрын
@@andersjensenorg i also posted this question on Discord channel but i havent receive any response
@aswathyk2419
@aswathyk2419 Жыл бұрын
while am doing the same step i get this error {"error":{"code":"WorkflowTriggerIsNotEnabled","message":"Could not execute workflow 'b39ff62e-9c57-4594-a35d-4cdde7b2a5dc' trigger 'manual' with state 'Disabled': trigger is not enabled."}} help me pls how can i solve this error
@andersjensenorg
@andersjensenorg Жыл бұрын
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzfaq.info/get/bejne/rr12rZCEnpy8d6M.html Kind regards, Anders
@user-tw2un7fy5m
@user-tw2un7fy5m 9 ай бұрын
I am also having the same issue.. to resolve it I even purchase the monthly Power Automate Premium license $15 per month BUT STILL I am getting "Your premium flows are turned off"
Extract Data from ID Documents - Power Automate AI Builder Use Case
37:07
The Giant sleep in the town 👹🛏️🏡
00:24
Construction Site
Рет қаралды 21 МЛН
Power Automate Invoice Processing Tutorial AI Builder and Azure
27:58
Document Processing with AI Builder in Power Automate
1:06:31
Anders Jensen
Рет қаралды 48 М.
Power Automate RPA Licensing | AQL Technologies | Sameer Mohammed
8:52
Get Data from PDFs and Send to EXCEL with Power Automate Desktop!
18:52
Christine Payton
Рет қаралды 53 М.
Power Automate Desktop - Invoice Processing
10:59
Microsoft Power Platform
Рет қаралды 45 М.
Outlook Emails in Power Automate Desktop - Full Tutorial
33:10
Anders Jensen
Рет қаралды 45 М.
Multiple forms Processing using AI Builder (Different Layouts)
19:43
Microsoft Power Automate Tutorial - AI Builder Explained
13:26
RPA Champion
Рет қаралды 23 М.