
Announcements
Hi everyone,
I am starting to develop in next weeks a project that probably will become my Master Thesis.
I have a question: I need to read all the rows in an excel file and then validate some cells to implement a business logic. To do this, I use today some VBA macro and RegEx validation mechanism, but I want to move to the cloud infrastructure that my subscription, with my company, has.
My question is: how can I work with no problem of "quantity" of calls with RegEx? I saw online something like using scripts, but I am not sure that it is the best solution. Probably it could be better to write an API directly on Azure, create a connector and use it in flow.
About the number of requests, each excel file, which I need to evaluate, has maximum 5000 rows with maximum 10000 email address to validate and the same quantity of mobile phone number to validate.
Can you help me to find a good solution?
Thanks in advance,
Andrea