Advanced Invoice Processing with AI Builder in Power Automate Desktop

Рет қаралды 20,578

Күн бұрын

Пікірлер: 51

@andersjensenorg 2 жыл бұрын

Thanks for all your support 🙌🔥 I've prepared these Advanced Power Automate Desktop Use Cases for you: kzbin.info/aero/PLXXz88_TPiHqbQENjPjBkO3DSro06cAcb

@dadicam Жыл бұрын

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 Жыл бұрын

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

@indeotelsonline 11 ай бұрын

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 11 ай бұрын

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

@ammadkhan4687 Жыл бұрын

This is the exact solution I was looking for. Many thanks for your effort

@andersjensenorg Жыл бұрын

Hey Ammad - thanks a lot for letting me know, highly appreciated 🙌💪 Kind regards, Anders

@nathangoel8894 8 ай бұрын

thanks Anders, your content is awesome

@andersjensenorg 8 ай бұрын

I'm so happy to hear 😊 Thanks a lot, kind regards, Anders

@nguyentrunganhtrung.anh.ng2070 Жыл бұрын

Hi! Thanks for the video. Can I apply this on Power Automate cloud? Thanks

@andersjensenorg Жыл бұрын

Hey Nguyen, yes it's already integrated in PA Cloud 🙂

@datalevi 2 жыл бұрын

Do you have other resources to start learning about AI?

@andersjensenorg 2 жыл бұрын

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

@calvinjeng 2 жыл бұрын

If my files are stored in the C:\users\desktop\invoice folder, not in the cloud Which steps should be omitted? Thank you

@brijendraydv 2 жыл бұрын

@@anjugunakar what's his server name or how to find on discord?

@andersjensenorg 2 жыл бұрын

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: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

@nickvanoort9609 2 жыл бұрын

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 Жыл бұрын

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: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

@buryats_usa 2 жыл бұрын

Is it a paid service (AI invoice recognition)? How much for how many runs?

@andersjensenorg 2 жыл бұрын

Hey Zorikto. Yes, but for private use we can have it for free (my version is a trial). Kind regards, Anders

@QuratulainShams Жыл бұрын

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 Жыл бұрын

@myousefi6600 Жыл бұрын

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 Жыл бұрын

@VAMSIKRISHNAP-y3j Жыл бұрын

hii Anders ,do you know how to get filename to excel dynamically in cloud power automate

@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

@edtignor4235 2 жыл бұрын

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 2 жыл бұрын

Hey Ed. Great question. Because the process is used with Windows Legacy apps, which Cloud can't use 🙂 Kind regards, Anders

@maleenonline 8 ай бұрын

Is there a way to collect QR code data into a Excel spreadsheet?

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

@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 Жыл бұрын

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: kzbin.info/www/bejne/lYK1emCPpJebbrc Have a great day. Kind regards, Anders

@wamiqsattar Жыл бұрын

@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 Жыл бұрын

@roshanmk007 5 ай бұрын

How to extract line items like QTY

@andersjensenorg 5 ай бұрын

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

@MUHAMMADSOHAIL-cx2rl Жыл бұрын

Dear , i am getting below error: error":{"code":"NoResponse","message":"The server did not receive a response from an upstream server.

@andersjensenorg Жыл бұрын

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

@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 Жыл бұрын

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 Жыл бұрын

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 Жыл бұрын

@baldeepsinghnagi8943 5 ай бұрын

Getting this error: {"error":{"code":"DirectApiAuthorizationRequired","message":"The OAuth authorization scheme is required. Please add authentication scheme and try again."}}

@andersjensenorg 5 ай бұрын

@baldeepsinghnagi8943 5 ай бұрын

@@andersjensenorg i also posted this question on Discord channel but i havent receive any response

@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 Жыл бұрын

@QuratulainShams Жыл бұрын

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"

@vygintasgrinis3913 9 ай бұрын

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 9 ай бұрын

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 8 ай бұрын