Thanks for all your support 🙌🔥 I've prepared these Advanced Power Automate Desktop Use Cases for you: ua-cam.com/play/PLXXz88_TPiHqbQENjPjBkO3DSro06cAcb.html
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 ?
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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?
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
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
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.
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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 :)
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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.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 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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
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): ua-cam.com/video/xWFz-S96XGo/v-deo.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): ua-cam.com/video/xWFz-S96XGo/v-deo.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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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.
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.
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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
@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.
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): ua-cam.com/video/xWFz-S96XGo/v-deo.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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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'."}}
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): ua-cam.com/video/xWFz-S96XGo/v-deo.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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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?
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"
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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.
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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"
Thanks for all your support 🙌🔥
I've prepared these Advanced Power Automate Desktop Use Cases for you: ua-cam.com/play/PLXXz88_TPiHqbQENjPjBkO3DSro06cAcb.html
This is the exact solution I was looking for. Many thanks for your effort
Hey Ammad - thanks a lot for letting me know, highly appreciated 🙌💪 Kind regards, Anders
thanks Anders, your content is awesome
I'm so happy to hear 😊 Thanks a lot, kind regards, Anders
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 ?
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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?
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
If my files are stored in the C:\users\desktop\invoice folder, not in the cloud
Which steps should be omitted? Thank you
@@anjugunakar what's his server name or how to find on discord?
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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
Hi! Thanks for the video. Can I apply this on Power Automate cloud? Thanks
Hey Nguyen, yes it's already integrated in PA Cloud 🙂
Do you have other resources to start learning about AI?
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
Is it a paid service (AI invoice recognition)? How much for how many runs?
Hey Zorikto. Yes, but for private use we can have it for free (my version is a trial). Kind regards, Anders
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.
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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 :)
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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
hii Anders ,do you know how to get filename to excel dynamically in cloud power automate
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Is there a way to collect QR code data into a Excel spreadsheet?
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
How to extract line items like QTY
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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.
Hey Ed. Great question. Because the process is used with Windows Legacy apps, which Cloud can't use 🙂 Kind regards, Anders
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.
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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
@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.
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Dear , i am getting below error: error":{"code":"NoResponse","message":"The server did not receive a response from an upstream server.
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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'."}}
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Getting this error:
{"error":{"code":"DirectApiAuthorizationRequired","message":"The OAuth authorization scheme is required. Please add authentication scheme and try again."}}
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
@@andersjensenorg i also posted this question on Discord channel but i havent receive any response
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?
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"
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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.
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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"