Dear All,
I am working on a project, but I did not find any hints whether it is doable or how difficult to solve the following problem. Your guidance would be greatly appreciated.
One partner of mine would like to collect data from excel attachments of e-mails arriving regularly from their partners into a given e-mail address. The content of excel files are not lists, they are tables in a given cell intervalls.
Also, it is requiered to attach other data of the e-mail to the records which were imported into the database (eg.: e-mail and name of sender, date of e-mail arrival...)
In order to give a little more detail, monthly and quarterly reports are collected from partners. Monthly and quarterly reports are sent in different time intervalls. Because of monthly and quarterly reports contain different data, they should be stored in different tables. We also would like to collect data whether partners have sent a given riport or not, and when they completed the reporting.
Is it possible to read these excel data from an e-mail attachment into dataverse tables using some kind of automatized flow? Or should I search for other direction?
If it was doable, could you also help what kind of licenses will my partner require?
Thx a lot in advance!
David
