Extracting data from emails, PDF invoices, Excel sheets, or other documents is a crucial element in the job of a Power Automate Developer. Unfortunately, there is no built-in free RegEx support in Microsoft Power Automate.
If the data is structured, the go-to solution is using Regular Expressions (RegEx). This article assumes you know have a basic knowledge about RegEx. If that’s not the case, check this.
Excellent post, Anders. Thanks for sharing.
The limit on the number of Office Scripts an individual can run per day has been updated from 400 to 1,600. This is a pretty big jump; probably has something to do with the fact that people are using a lot of Office Scripts (now that I’ve been introduced to them by your post, I’m sure I will!).
Ref: https://docs.microsoft.com/en-us/office/dev/scripts/testing/platform-limits
Hey John. That’s so awesome. 1600 might still be too less when automating in the enterprise space, but it’s getting there If you want, you’re very welcome at my developer community: https://discord.gg/d8KQpTUvFD And thanks a lot for the nice words Kind regards, Anders
Hi, i am currently using AI builder to extract the invoice amount from invoices. The workflow is setup in a way that the data will be stores in an Excel file. The issue is that i want to remove characters like: €,£ and text: “vat” how can indo this with regex can you please help me i am lost searched for hours on internet then i found this which could be the solution but i am not familiar with regex
Hey my friend. Can you post the extracted text? Either here or at my Discord: https://discord.gg/d8KQpTUvFD Kind regards, Anders