วีดีโอ

Hey champ, let me know what else you got :)

Hey - yes for sure! I have my LinkedIn details on my profile, you can reach out to me there. I'd be happy to help - if I can :)

Hey, that's not great - can you help me understand what you are seeing, then I might be able to help you?

Hi Reza - do you have an example of a website where this is bugging you?

Thanks, I appreciate that!

Hey Zoran - yes, you are right, this will use AI Credit. From the research I did, you will be able to have this running on a profile for 15$ a month, as long as you don't receive more than 156 invoices a month. If you are in a big company with many automation flows running, you will need to upgrade the capacity but that might end up being quite expensive. What do you mean box model, if I can ask? :)

@@MatKjeldsen Hi Mat, When you use the custom model, you need to create collections, but there’s a 200-collection limit per model. For us, this was a hard stop, as we needed more collections. My team tested and ultimately switched to the prebuilt invoice processing model, which removed this limitation. However, we did lose some precision and functions, as the prebuilt model can’t recognize certain elements that our custom model could. And, it does not need training,so making the work much easier for the background team. I really liked your video; it covers important topics on handling invoices. One additional step we took was saving the results in a SharePoint list. This gave us a central place to view all received invoices for further processing. We also used the model’s accuracy data to filter out unrecognized information, allowing users to manually correct values as needed.

@@ZoranRuzic1 I did not know that, thanks for sharing! It sounds like you got quite the operation running. Saving it to a SharePoint list also makes sense, and the connections to do so is easy since everything is MS. Can I ask what your job position is called?

@@MatKjeldsen can we switch to LinkedIn or something with direct messages ?

I’m happy to hear that, you’re welcome :)

Exactly my expectation, PDF not image

How can we extract text from a PDF with power automate. I am looking for a solution that doesn't require having to manually write script for parsing as that solution is not reliable and can not work on different documents because of different formats, design and content of the document.

Hey - you guys are right! I will change the title of the video, and make a new one covering extraction of text in PDFs. Can I ask, would your need not be covered by using "Extract text from PDF" on your PDF files - why would you want to run the OCR on it? :)

@@Marcelmikael You can use Extract text from PDF. My bad this was confusing for you. Let me know if you are stuck using this action.

@@MatKjeldsen Hello, i hope you could answer my question but is it posible to use extract text from pdf and then to give a list of keywords that the ocr will need to extract ? as an example we could use the pdf you used in your video, what if i want the automate to extract me only the order number and some extra info like the order date. thanks for your answer

Hey when are you getting this error? Can you connect to SQL without running a query, or are you getting this error when you are executing a query?

I can connect to SQL using Desktop flow, it works fine without any issues. I have set up a gateway and can connect to SQL server using the cloud flow, however the only action that works is “GET ROWS”

@@TbvngM There are bigger limitations in executing SQL queries using cloud flows, so if I was you I would build the flow in Desktop application and then use the Cloud to trigger the flow when/if necessary. The Desktop flow should be able to contain everything needed like SELECT, WHERE, FROM, JOIN etc etc

@@MatKjeldseni was trying to avoid this lol. Thank you sooo much for your response and assistance

@@TbvngM you're welcome. It's funny why they don't support the same, but what do I know, there is probably a reason. Let me know if you have other issues :)

Thanks man, appreciate that!

Hey Dhruv. I particularly like Power Automate Desktop because it makes it easy to work with a lot of the other Microsoft applications, but if you are not a fan of this I suggest you look into UI Path, which is another really powerful and quite easy to work with application :)

@@MatKjeldsen thanks i agree that power automate is simple and robust. Personally not a fan of Uipath. Love your videos. Please keep uploading and also upload some uses cases for accounting and finance.

@@DhruvDua88 Thanks and I will :)

Hey - yes the solution requires taking pictures of each number for one file, but then it will be replicable for the 60 other PDF files the guy had - so setup is a bit cumbersome, but after that it will be able to just run through it all. Are you experiencing problems when trying to build this or something similar? :)

Got it, I'll try to look for a different approach and let you know if I find, thanks

You're welcome, thanks for the kind words :)

I appreciate that! Is there anything you are experiencing issues with, that you would like me to share some insights on?

That means a lot!